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.
Good work Greg – what a brilliant idea to use a cube to analyse Analysis Services!