How DBAs can use PowerPivot for Performance Tuning / Troubleshooting
User Rating: / 0
PoorBest 
Written by Andre Kamman   
Tuesday, 27 September 2011 18:21

The amout of perf data that we can collect for a SQL Server can add up quickly.The easiest way for us dba's is to load everything into a database and start querying. Unfortunately that sounds like a lot of work. Why not use PowerPivot ? It will give you all you need but still allows for the flexibility that you don't want to lose. That's where this session comes in. I'll show the good, the bad and the ugly parts of PowerPivot while trying work with, and even correlate, waitstats, virtualfilestats, perfmon counters, profiler trace data, extended events data, etc. This session will be filled with demo's and I'll explain all the perf tuning techniques that I use along the way.

Read more...

  Tags: video, usage
 

Pyramid+PowerPivot