Extended Events for Analysis Services
This year I've spent quite a bit of time tracing Analysis Services events. In the lab, my goto has always been SQL Profiler for it's mere simplicity. At clients, I usually take the extra step of creating a server side trace (example) to reduce the "observer overhead". Both of these options have served me well. But now that SQL Profiler has been deprecated in SQL2012, it's time to start familiarizing myself with a shiny new hammer: Extended Events.
Read more...Tags: management