THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

SSAS Performance Tools

Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer. It's a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank you Chris, if I only had this tool three months ago! :-)

Chris has also posted the news of an Analysis Services Load Testing tool that is available on CodePlex. More than the tool, it is the available documentation (which is a draft) that deserves most of your attention, beacuse illustrate you how to setup all the test environment using Visual Studio 2005.

Finally, another interesting document is this post from the SQLCat team about warming up cache in SSAS.

Published Sunday, April 29, 2007 1:31 AM by Marco Russo (SQLBI)
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Saagr said:


Is this tool will support SSAS2014 for load test.

July 20, 2015 3:20 AM

Marco Russo (SQLBI) said:

API should be the same, so it should work, but I didn't try. I suggest you to run a test.

August 21, 2015 6:31 PM

Marco Ramírez said:

Hello Marco

Do you know of current tools to create load testing aimed at SSAS Tabular models?

Thanks in advance!

October 13, 2016 5:10 PM

Marco Russo (SQLBI) said:

You can use the same described in this post - did you try them?

January 19, 2017 2:13 PM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement