Lost Perfcounters in SQL
Alright so I haven’t had the best week for my SQL databases lately. But that’s ok they are getting better and those things that don’t kill us make us stronger right. J
I ran into an interesting Performance counter issue yesterday. SQL Server stopped tracking stats inside its engine for major items like wait stats, and Read,cpu,writes for traces. This was a little odd and really screwed things up for us since we were trying to find a performance issue. So I found this KB Article . We found that if you have perfmon running against the server when you reboot this is caused by this. Now I’ve had perfmon up tons while rebooting but I’m starting to wonder if SQL Sentry might have helped out since they take more counters and more frequently. So we stopped all perfmon’s to the server and I stopped the sentry service and this time they came back up ok. I don’t think it’s a bad thing that sentry does this it’s just a necessary item. Or move to SP4 which is now in our near future. J
Pat