Monitoring Queries In Analysis Services

How can you monitor the queries your business users submit?

Carl Rabeler

June 21, 2005

1 Min Read
ITPro Today logo in a gray background | ITPro Today

As an administrator of a SQL Server 2000 Analysis Services instance, how can I monitor the queries my business users submit?

There's no server-based mechanism to capture MDX queries or Decision Support Objects (DSO) commands in Analysis Services 2000—an Analysis Services 2000 instance is essentially a black box. The Analysis Services query log lets administrators view the levels at which users are querying Analysis Services dimensions (but not the queries themselves). However, most Analysis Services clients do support the ability to specify a log file in the connection string to capture client queries on a per-client basis. In SQL Server 2005 Analysis Services, an administrator can use SQL Server Profiler to monitor all MDX queries and Analysis Management Object (AMO) commands submitted against an Analysis Services 2005 instance.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like