Running Perfmon on sql 2005?
-
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
-
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
-
Cool that you posted the follow up!
-
Hi, Cory
Check this topic:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12363
Kindest Regards,Alexandr Volok
volok.blogspot.comMCITP: Database Administrator
SQL Server Russian Group www.sql.ru
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply