3

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: enter image description here

The drop downs for Object, counter and instance are empty. I can't even create the alert using TSQL as follows: enter image description here I can see these counters collecting data in perfmon.

Any ideas? Thanks in advance...

Manjot
  • 1,213
  • 2
  • 21
  • 29

1 Answers1

5

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.

Glorfindel
  • 2,205
  • 5
  • 19
  • 26
gbn
  • 70,237
  • 8
  • 167
  • 244