Monitoring Queries In Analysis Services
How can you monitor the queries your business users submit?
June 21, 2005
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.
About the Author
You May Also Like