Thanks for everyone who made it to my SQL Saturday Session in Olso today on load testing Analysis Services. If you are interested in getting started to building a load test harness in visual studio, I have attached the source code I used for the demos and sample database for AdventureWorks. Happy Load Testing! ssas_load_test_source.zip
Tag: SSAS
When you need to do load testing for Analysis Services its common to need to capture and “replay” MDX queries. I’ll go into replay tools later – the first step is to capture the queries. You will need An XMLA trace definition file capturing at a minimum the QueryBegin and QueryEnd events (Events 9 and … Continue reading Capturing a Service Side Trace for MDX<