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:

image

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.

image

image

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.

image

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

image

You can see what views we have for usage:

image

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

image

You can see my databases are discovered:

image

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

image

My instances are also discovered:

image

Instance Dashboard:

image

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

image

image

 

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.

Advertisements

3 thoughts on “Quick Look at the New SQL Server 2012 Analysis Services Management Pack

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