Running Perfmon on sql 2005?

Question

Post reply

Running Perfmon on sql 2005?

Cory E.

SSCertifiable

Points: 7076
More actions
June 14, 2007 at 11:53 am

#117524

Good day

I have just completed our first major upgrade from sql 2000 to sql 2005 (x64). We had a set of perfomance counters running agaisnt the old SQL 2000 server, and these worked great. Preparing for SQL 2005, I made these counters for the new server, setting them up the same. When we started looking at the stats this morning, none of the counters for the SQL Server coutners had any data. Now, if I run the perfmon directly, I am able to get these counters (IE SQLServer:General Statistics/User Connections). I have read up on the sys.dm_os_performance_counters, however, I wanted all this in one central log.

Does anyone else have this issue? what have you done to resolve it? perhaps we need to totally rethink using perfmon, if this data is in the db, but it looks to me that querying sys.dm_os_performance_counters results in "at the moment" stats, no trending.

Thanks, Cory

-- Cory

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cory E. SSCertifiable Points: 7076 More actions · Answer 1

Looks like one of my server guys found the issue. This box is a clustered pair, and it seems that the OS cluster group and SQL cluster groups were on differnent nodes. While you can see the stats in real time, when running perfmon to a file, you cannot get the SQL stats.

Moral, keep your groups together

-- Cory