SQL 2005 Perfmon Objects/Counters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » SQL 2005 Perfmon Objects/Counters

12 posts, Page 2 of 2

««1 2

SQL 2005 Perfmon Objects/Counters

Rate Topic

Display Mode

Topic Options

Author

Message

Danb7183

Posted Thursday, December 11, 2008 8:43 AM

Mr 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

Jai-SQL DBA

Posted Monday, June 18, 2012 4:47 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, February 07, 2013 5:10 AM
Points: 54, Visits: 194

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 Smile

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

Post #1317244

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions