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

Monitor SSAS performance counters using a cube!

This is a tool I would have mentioned in the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book I wrote last year. Unfortunately, the ResMon sample cube has been published just a few days before PASS Summit 2010 on CodePlex. It simply use SSAS DMVs as a data source and makes a lot of information easily readable and browsable by using a PivotTable!

You can take a look at the documentation to see a few screenshot of possible usages. To me, also the simple static view can be really useful to understand which database is consuming SSAS memory. For example: if you have a development machine with SSAS installed and so many SSAS databases there… that nobody use anymore… well, you should be aware that SSAS reads some metadata anyway, even if you never queried that database. We are talking about tens of megabytes per database here, and the size depends on metadata complexity. Yes, maybe you will clean-up your SSAS development machine after you will realize how much memory your 2-years old projects still consumes just to start the Analysis Services process.

Kudos to Edward Melomed, who originally created this nice and elegant implementation, and to Greg Galloway that further refined and published it!

Published Friday, November 26, 2010 8:23 PM 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


No Comments

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