SSAS Performance Monitoring Reccomendations

Hi guys

Can anyone recommend a software monitoring tool for checking performance on a SSAS instance specifically? I'm about to download "BI Suite" from SQL Sentry, but checking for other options.

Thanks Ruan

more ▼

asked Apr 07, 2014 at 01:13 PM in Default

avatar image

1.2k 31 38 46

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

You can run SQL Server Profiler against SSAS instance, Extended events, and also DMVs for checking SSAS performance. Refer http://technet.microsoft.com/en-us/library/bb500198.aspx . All of the above come free with SSAS.

more ▼

answered Apr 08, 2014 at 04:14 AM

avatar image

1.4k 1 3 6

Thanks Venkataraman, I am looking for a 3rd party software monitoring tool specifically for Analysis Services, the company doesn't mind paying.

Apr 10, 2014 at 07:34 AM ruancra
(comments are locked)
10|1200 characters needed characters left

Spotlight and SQLSentry both monitor SSAS with different pricing.

I have used Spotlight and found it was good for general monitoring, but SQLSentry's is more detailed, but is for more advanced SSAS architects.

more ▼

answered Apr 30, 2014 at 01:50 PM

avatar image

101 1 1 4

(comments are locked)
10|1200 characters needed characters left

There are a number of different tools you can use to monitor SSAS. In general, any company that develops SQL Server tools has some kind of SSAS monitor. I didn't have a chance to work with SQL Sentry, but I know they have a tool dedicated to SSAS specifically. Spotlight by Quest has already been recommended, but keep in mind that although it offers advanced features, the higher price range needs to be considered. ApexSQL has a dedicated solution for monitoring all SQL Server services, which has a good value for the price and Idera has both free and paid solutions. Their free tool is very simple and doesn't store data, so you can only monitor the state of the SSAS in real time, and their paid tool is more complex, similar to their other products.

Just decide exactly what your needs are and I'm sure you will find an appropriate tool - the BI market is vast and growing rapidly.

more ▼

answered Mar 16 at 01:33 PM

avatar image

11 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 07, 2014 at 01:13 PM

Seen: 568 times

Last Updated: Mar 16 at 01:33 PM

Copyright 2018 Redgate Software. Privacy Policy