Quick Look at the New SQL Server 2012 Analysis Services Management Pack

Release several hours ago a new Management Pack for SQL Server 2012 Analysis Services. There is also a version for SQL 2008 Analysis Services. But I will focus this blog post on the 2012 version. The SQL Server Management Pack provides some monitoring for SQL Analysis Services but does not goes too deep and now with this new MP you have that option. Let’s look on how to install it and import it:

As we can see from the installation the MP is done probably by the same team that brought the SQL Server MP which hints probably will be a good MP.

After installation you can import the MP files.

A Run As account needs to be created for monitoring your SQL Analysis Services. That account needs to be local administrator on the SQL Server Analysis services servers and administrator in the Analysis Services instances. Distribute the account only to the servers that have Analysis Services installed.

Than assign that account to the two profiles for Analysis Services:

You can see what views we have for usage:

We are also getting some alerts as soon as the objects are being discovered:

You can see my databases are discovered:

As with SQL Server 2012 MP in this one we also have some nice Dashboards:

My instances are also discovered:

Instance Dashboard:

We also have separate views for different types of Analysis Services:

 

The MP seems very solid and with a lot of information that will bring your SQL Analysis Services monitoring on another level.

Remember that if you will implement it to make some proper testing on your own and definitely read the included guide before importing.