Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL 2005 Perfmon Objects/Counters Expand / Collapse
Author
Message
Posted Thursday, December 11, 2008 8:43 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 25, 2012 9:18 AM
Points: 522, 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!)
Post #617983
Posted Monday, June 18, 2012 4:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 15, 2014 5:18 AM
Points: 67, Visits: 353
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
Post #1317244
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse