Monitoring SSAS instance using Activity Viewer
Unlike other database systems, Analysis Services has no system databases. However, administrators still need to check the activity on the server, ensure that cubes are available and can be queried, and there is no blocking. You can exploit a tool named Analysis Services Activity Viewer 2008 to monitor SSAS Versions 2008 and later, including SSAS 2012. This tool is owned and maintained by the SSAS community and can be downloaded from www.codeplex.com.
Tip
To use Activity Viewer, you need to install Analysis Services OLE DB Provider for Microsoft SQL Server 2008, which you can obtain as a part of the SQL Server 2008 feature pack from Microsoft's website.
Activity Viewer allows viewing active and dormant ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
