HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL 2008 Server agent cant see perfmon counters

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
counters2008sqlagentcantseeperfmonserver

Problem

I am trying to create a new SQL server agent alert to capture "SQLServer:General Statistics|Processes Blocked||>|5' but it looks like alert creation GUI is not able to see any perfmon counters as in the following picture:

The drop downs for Object, counter and instance are empty.
I can't even create the alert using TSQL as follows:

I can see these counters collecting data in perfmon.

Any ideas?
Thanks in advance...

Solution

You'll have to work through this "SQL Server – Missing Performance Counters: A consolidated list of known issues" sorry.

I'm surprised this still happens: I last saw this with SQL Server 7/2000 years ago.

Context

StackExchange Database Administrators Q#3781, answer score: 5

Revisions (0)

No revisions yet.