Monitoring SSAS instance using DMVs

In the previous section you learned about a few DMVs referenced by Activity Viewer. Analysis Services supports many other DMVs not used by Activity Viewer. You can query DMVs directly using the SSMS or ASCMD command-line utility.

How to do it...

You can query DMVs by executing simple SELECT statements in the MDX query window within SSMS by performing the following steps:

  1. Navigate to FILE | New | Analysis Services MDX Query.
  2. Connect to your SSAS instance as an administrator.
  3. Paste the DMV queries you captured using SQL Server Profiler (see the previous section, Monitoring SSAS instance using Activity Viewer). The SELECT statements that you can use for querying DMVs are somewhat limited:
    • You can only query one DMV at ...

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.

Start your free trial