Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 908500 - Last Review: November 20, 2007 - Revision: 1.2
BUG: SQL Server 2005 Analysis Services performance monitor counters do not report values
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.
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
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
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
| kbsql2005as kbtshoot kbbug KB908500 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate