Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2005 Perfmon Objects/Counters


SQL 2005 Perfmon Objects/Counters

Author
Message
Danb7183
Danb7183
Mr or Mrs. 500
Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)Mr or Mrs. 500 (524 reputation)

Group: General Forum Members
Points: 524 Visits: 493
The other thing to bear in mind is how often you are capturing the data. I've read guides where its recommended to change the default value of how big the interval is (in seconds) from 1 second to 1 minute, up to around 10 minutes per 'scan'.

Also for a list of all specific counters for SQL2005 use the Dynamic Management View: sys.dm_os_performance_counters

This will however use counters for each DB on the server in question (so you could end up with quite a few!)
Jai-SQL DBA
Jai-SQL DBA
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 507
Hi All,

I was looking for the same Answer and I Found something really Helpful
Kindly go through the Following once and I m Sure woudl be a Good Learning for Starters :-):-)

http://www.sqlservercentral.com/articles/Administration/performancemonitoringbasiccounters/1348/#waittime
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search