Varun Dhawan's Blog

Hands-on with SQL Server

SQL Server – Missing Performance Counters: A consolidated list of known issues

SQL Server – Missing Performance Counters: A consolidated list of known issues

Rate This
  • Comments 1

SQL Server performance counters missing!!

broken_chains

Past few hours been crazy one, breaking my head on a ‘Missing Performance Counters’ and now since this is resolved, I want to now off-load every bit of this issue from my brain so thought blogging it :-)

Issue: A customer is having 24x7 PERFMON counter collection and suddenly they found that all SQL Server related perform counters are missing.

Cause: While working on this for few hours, we could determine that a known issue described in Microsoft KB # 812915. The issue is specific to an ‘ancient’ SQL built (SQL2K SP3), wherein if SQL Server Service is shutdown (re-started) in between a perform collection then, after re-start, SQL Server related PERFMON counters do not appear in Performance object list.

Resolution:

Quick one – Ensure to always close the Performance console or Stop collection before you restart SQL Server.

Long (and better) one – Consider applying SQL 2000 SP4

However the story goes beyond. While working on this issue, I hit across so many distinct issues due to which SQL Perfmon counter goes missing and how to fix/retrieve them. I have consolidated a list of those articles / blogs where these distinct issues have been documented

SQL Server 6.5 / 2000

SQL Server 2005 / 2008

Operating System

Expect to find changes to this blog post, as I might come across more issue on ‘missing performance counter’, but as of today, so-far-so-good

Cheers!!

Leave a Comment
  • Please add 4 and 6 and type the answer here:
  • Post
  • For SQL Server 2008 R2 I found that you should use "LODCTR perf-MSSQL$<INSTANCENAME>sqlctr.ini" instead of sqlctr.ini

Page 1 of 1 (1 items)