This project is read-only.
1

Closed

ERROR ADDING COUNTERS Category does not exist. (@ startup)

description

@ startup i get the following error. No clue what i should enable on the SQL side to make it work ;)
 
Grtz,
Theo Ekelmans
NL
 
9/16/2010 4:25:22 PM Application Initialised - Version 1.30.3666.19187
9/16/2010 4:25:45 PM Connecting to Database [Driver={SQL Server};Server=PACMAN2BUFFER;Database=master;Trusted_Connection=true;]
9/16/2010 4:25:45 PM Server Version is - 9.00.4035.00 - SP3 - Standard Edition
9/16/2010 4:25:45 PM Server Has AWE Disabled
9/16/2010 4:25:45 PM Accessing Local Registry
9/16/2010 4:25:45 PM Server Has PAE Disabled
9/16/2010 4:25:45 PM Server Has /3GB Disabled
9/16/2010 4:25:45 PM Running second thread
9/16/2010 4:25:45 PM Adding Performance Counters ......
9/16/2010 4:25:47 PMERROR ADDING COUNTERS Category does not exist.

file attachments

Closed Jun 4, 2012 at 7:19 PM by glensmall

comments

glensmall wrote Sep 17, 2010 at 10:54 AM

It looks like your server has missing or corrupt performance counters.

SQL Live Monitor loads perfmon counters from the following Categories installed by SQL Server

Memory Manager
Buffer Manager
Locks
General Statistics
SQL Statistics
Databases
Cache Manager
Plan Cache
Access Methods

and then from these general system categories

Memory
Processor
System

I have seen a number of system with missing or corrupt perfmon counters, but there are processes that you can follow to add them back in. First I would verify in perfmon that you have the categories listed above. For a default instance of SQL Server, the categories will be SQLServer:<categoryname> and for a named instance they will be MSSSQL$<instancename>:<category name>

After that, you can add the counterds back in my following this simple process:

Stop SQL Server Service
Open Command Prompt (Start – Run – Cmd)
Run the command: NET STOP MSSQLSERVER
Then, this question will appear: “The following services are dependent on the SQL Server (MSSQLSERVER) service. Stopping the SQL Server (MSSQLSERVER) service will also stop these services: SQL Server Agent (MSSQLSERVER). Do you want to continue this operation? (Y/N) “
Press “Y”
Open Command Prompt and get located on the BINN directory of SQL Server. Probable locations are:
x:\Program Files\Microsoft SQL Server\90\Tools\Binn
x:\Program Files\Microsoft SQL Server\80\Tools\BINN
Once located on the BINN directory, using the Command Prompt, execute the following command: lodctr sqlctr.ini
Restart your computer.

Hope that helps.

wrote Sep 17, 2010 at 10:55 AM

wrote Sep 20, 2010 at 9:57 AM

Nexus64 wrote Sep 20, 2010 at 9:57 AM

Yup,

"lodctr sqlctr.ini" did the trick, though I still wonder why those perfmon counters got corrupted....

Anyways thanks for the quick response, on your AWESOME overview tool.

But being a dutchman, there is allways something else i need/like/want/<fill in random expletive> :)

I've added a query that sums up the (buffer)cache usage per database and how dirty those are.

It's something i allways run next to your tool.

Thanks again, and i'm looking forward to the next version !

Grtz,
Theo Ekelmans
DBA
Ordina
The Netherlands

Nexus64 wrote Sep 20, 2010 at 10:11 AM

Looking at the screen again, you could add a sqlmonitor'erised version of my query as a buffer drilldown?

<nudge><nudge><wink><wink>

glensmall wrote Sep 20, 2010 at 12:53 PM

I'm working on the next version at the moment, so mail me over your query and I'll see about adding it in.

mail it to glsmall@microsoft.com

wrote Jun 4, 2012 at 7:19 PM

wrote Feb 14, 2013 at 8:00 PM

wrote May 16, 2013 at 10:58 AM