question

ruancra avatar image
ruancra asked

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
ssasmonitoring
10 |1200

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

Venkataraman avatar image
Venkataraman answered
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.
1 comment
10 |1200

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

Thanks Venkataraman, I am looking for a 3rd party software monitoring tool specifically for Analysis Services, the company doesn't mind paying.
0 Likes 0 ·
TheSmilingDBA avatar image
TheSmilingDBA answered
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.
10 |1200

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

JoshuaTurner avatar image
JoshuaTurner answered
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
10 |1200

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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