Tips and Tricks for Troubleshooting a Microsoft SQL Server PowerPivot for SharePoint Installation

Download this episode

Download Video


PowerPivot presents an interesting challenge for debugging and figuring out what is happening when problems occur. There are a lot of moving parts on a running farm. PowerPivot uses a mixture of SharePoint and SQL logging, tracing and debugging. In this chalk talk we review the various logs and trace files that are generated by SharePoint and SQL (and how they map to PowerPivot features). We take some common usage scenarios, inject faults, and show how you identify and rectify the problem. When do you look at IIS logs; when the NT event log; when SQL? And what do you do on a large farm where the various machine logs and traces are not consolidated. A customer’s first impression of a new product is all-important. This chalk talk is designed to help you guide customers, whether you are a TS, MCS, or support person. We give you the knowledge that will help you help your customers.







Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.