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.

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

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

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

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