performance monitor counter issue 1

[deepsheep]

Ok, I think I have a good one.
I ran a log for a couple of my servers in performance monitor. One worked fine, I got the info I wanted. The other did somthing strange.
On the misbehaving server, I got all the counters to record, except the SQLServer ones. They recorded as 0, when it wasn't. I added a couple more in a live window and still got 0 in them too.

So, why is performance monitior being blocked from accessing these statistics? Or why aren't they being generated at all? I'm pretty sure the servers are set up the same...
Thanks!

 

[mrdenny]

There is a know issue where if you have any applications attempting to access the SQL perfmon counters when the SQL Server service is started all the counters will show as 0. Close all your perform apps and restart the SQL Server. The counters should all start reporting correctly.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[deepsheep]

Thanks! That's kinda what I though. I'm guessing my mystery trace is what's doing it. Now if only someone would answer that question...

 

[mrdenny]

Is it SQL 2000 or SQL 2005?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[deepsheep]

2005.
I finally figured the trace out too. It's the default system trace. A feature I was unaware of. And the machine it WASN't running on had an issue and required a re-boot.

I downloaded the Performance Dashboard from microsoft and that seems to get the information I was looking for in the system counters.

Although, if you know a way around my issue, I would appreciate it.

Thanks!