Great SSAS monitoring tool – The ResMon Cube

Since Analysis Services (SSAS) 2008, there are Data Management Views (DMVs) that present pretty good information about the resource consumption of SSAS. These can be accessed through SQL query syntax, but now there is an easier way. Thanks to Greg Galloway there is now a cube for analysing the DMVs. And it’s even free!

I was told about this tool, ResMon, last Monday during an excellent presentation to our Swedish SQL Server user group by Tim Peterson.

ResMon

Good work Greg – what a brilliant idea to use a cube to analyse Analysis Services!

About these ads

Leave a comment

Filed under Technical

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s