I was going to go through the article on "How To Perform an SQL Server Performance Audit", but it appears as though I can not. Here is why: I do not have any SQL Server counters that I can add to my performance log. The machine appears to have been upgraded from SQL 6.5 to 7. How can I repair this? For example, I can not add "SQL Server Buffer: Buffer Cache Hit Ratio" to my counter list because SQL Server is not listed. Thanks...
Check the HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09 & hklmsystemcurrentcontrolsetservicesmssqlserverperformance registry keys value have proper privilege and access and ensure Sqlctr70.dll is registered to effect the SQL counters. HTH Satya SKJ
If you do a search at msdn.microsoft.com, there is at least one article on this issue, and series of steps on how to fix it. I don't remember them from the top of my head, and I am attending PASS today, and don't have the time to look this page up for you. ------------------ Brad M. McGehee Webmaster SQL-Server-Performance.Com
THe problem is MS is refurbishing KB articles, actually thishttp://support.microsoft.com/support/kb/articles/q227/6/62.asp link is somewhat useful to fix this issue. Hope they complete it soon and it would be available soon. HTH Satya SKJ
