January 24, 2005 at 9:03 am
I am trying to monitor a newly installed version of SQL Server 2000 Standard edition on Windows 2000 Server and am not seeing any of the SQL: objects under the Performance object list in perfmon. Has anyone else seen this before? If so, how do I go about adding these counters?
Thanks
January 24, 2005 at 11:36 am
This happened to me on two servers after I modified the start up accounts. Here is a link that has some good information.
http://www.extremeexperts.com/sql/FAQ/EnablingPerCounters.aspx
In my case, I had to start at step 4 to solve the problem.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 25, 2005 at 2:01 am
I had this a fair while ago now.
It can also happen if the SQL Services are restarted too quickly. I use sysinternals regmon and procexp and saw that that WMI (and/or SNMP, I'm not sure now) was hooked into that very same reg key, thence the sqlctr80.dll (or whatever it's called) and locked out access to the SQL service account.
I just bounced the SNMP (amd/or WMI) services along with SQL if I had to until tehe fix below.
See http://support.microsoft.com/kb/812915 to get this hotfix.Note the build number - it was broke in SP3a and fixed very quickly. It's in SP4 BTW.
I'd recommend Hotfix 818/819 at the very least (pre-requisite for some MS software these days such as SQLH2 and reporting Services) and this doesn't need a acall to MS to get it. See http://support.microsoft.com/kb/826161 (819 is client side fix, 818 is server)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply