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.
