Performance counters - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Performance counters

Author

Topic

avmreddy17
Posting Yak Master

180 Posts

Posted - 2006-04-18 : 16:19:43

In the Performance object drop down list of Perfmon.

I don't see the below counter

SQLServer:AccessMethods
SQLServer:BufferManager
SQLServer:Databases
SQLServer:GeneralStatistics
SQLServer:Latches
SQLServer:Locks
SQLServer:MemeoryManager
SQLServer:SQLStatistics.

How to enable these?

Thx
Venu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-18 : 16:24:24

There are lots of causes. You'll need to google "missing sql performance counters" and try each solution. You could also try searching MS' knowledge base for this string as well.

Google:
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLC,GGLC:1969-53,GGLC:en&q=missing+sql+performance+counters

MS knowledge base:
http://support.microsoft.com/search/default.aspx?qu=missing+sql+performance+counters

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources