Microsoft KB Archive/908500

= BUG: SQL Server 2005 Analysis Services performance monitor counters do not report values =

Article ID: 908500

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Standard X64 Edition

-



SYMPTOMS
The following Microsoft SQL Server 2005 Analysis Services performance monitor counters do not report values when you select them in the System Monitor:
 * Connection:Successes/sec
 * Storage Engine Query:Total queries from file
 * Proc Indexes:Rows/sec
 * Storage Engine Query:Avg Time/Query
 * Storage Engine Query:Total queries from cache direct and Storage Engine Query:Total queries from cache filtered

Although these counters still appear in SQL Server Performance Monitor, these counters always return the value zero.

Note This behavior may also occur with other performance monitor counters.



WORKAROUND
Use the following methods to obtain the information that was previously provided by the affected counters:
 * Monitor connection activity through the Audit Login trace event in SQL Profiler.
 * Monitor the Analysis Services query log. This log file tracks all queries that are answered from a file.
 * Monitor indexing activity by using the EventSubclass 20 column of the Progress Report EventClass event class in SQL Profiler.
 * Track query times in the Duration column of the Query End EventClass event class when you use SQL Profiler.
 * Distinguish cached data requests from non-cached data requests by looking at the value of the EventSubclass column for the following event classes in the SQL Profiler trace log:
 * Query Subcube
 * Query Subcube Verbose
 * Query Dimension



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbbug kbsql2005as KB908500

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.