SSAS Performance Monitoring Reccomendations

Question

Question by ruancra · Apr 07, 2014 at 01:13 PM · ssas monitoring

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

1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2014-04-08T04:14:41Z

Best Answer

Answer by Venkataraman · Apr 08, 2014 at 04:14 AM

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.

3 Show 1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ruancra · Apr 10, 2014 at 07:34 AM 0

Share

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

Answer 2 · 2014-04-30T13:50:56Z

Answer by TheSmilingDBA · Apr 30, 2014 at 01:50 PM

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.

1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2018-03-16T13:33:55Z

Answer by JoshuaTurner · Mar 16, 2018 at 01:33 PM

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][1] 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][2] 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. [1]: https://www.idera.com/productssolutions/freetools/sql-bi-check [2]: https://www.idera.com/productssolutions/sqlserver/sql-server-business-intelligence

1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SSAS Performance Monitoring Reccomendations

3 Replies

Your answer

Follow this Question

Related Questions