How DBAs can use PowerPivot for Performance Tuning / Troubleshooting
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.
André is a freelance SQL Server specialist. He has done a lot of DBA work on 100’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW.
André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland