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.
I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.
These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that