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 1 of 2

1 2 »»

SQL 2005 Perfmon Objects/Counters

Rate Topic

Display Mode

Topic Options

Author

Message

kelleysimmons

Posted Monday, February 18, 2008 8:05 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2008 8:55 AM
Points: 3, Visits: 2

I monitor performance on thousands of infrastructure servers and my scope is increasing to even more application servers. My question is what are the top key perfmon objects and counters I should be capturing?
I am using this performance data for both under-utilized and over-utilized servers for consolidation/virtualization and on the other end of the scope pro-active fixes in our environments so I will also need to get the proper thresholds that would fall in the under-utilized vs. over-utilized spaces. oh yeah, in between I also have a slot I call optimum performance :) any help would be greatly appreciated.

Kelley

Post #457167

Adiga

Posted Monday, February 18, 2008 8:31 PM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:50 AM
Points: 1,618, Visits: 20,898

I would suggest monitoring the following counters.

Processor:% Processor Time

PhysicalDisk:Avg.Disk Queue Length

PhysicalDisk:Disk Read Bytes/sec and PhysicalDisk :Disk Write Bytes/sec

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #457173

kelleysimmons

Posted Tuesday, February 19, 2008 4:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2008 8:55 AM
Points: 3, Visits: 2

I do monitor those reqular key counters but need to add the objects/counters specific to sql server 2005, what counters would I use to monitor utilization? what would tell me if a sql 2005 server is under/over utilized?

thanks much,

Kelley

Post #457308

Adiga

Posted Tuesday, February 19, 2008 4:37 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:50 AM
Points: 1,618, Visits: 20,898

You may pick the counters as per your requirement from the below URL

http://msdn2.microsoft.com/en-us/library/ms190382.aspx

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #457309

Grant Fritchey

Posted Tuesday, February 19, 2008 5:47 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:57 PM
Points: 13,371, Visits: 25,152

I've got a core, basic, set of counters that I suggest using here. They barely scratch the surface, but they ought to get you started.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #457326

Scalability Doug

Posted Tuesday, February 19, 2008 7:43 AM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 05, 2012 12:43 PM
Points: 655, Visits: 6,097

Kelly, some key counters and their significance...

processor queue length ( < 2 / processor )
disk queue length (<1000/spindle)
%disk time (obviously <100, the lower the better)
contect switches/sec (the lower the better)

Hope this helps,
Doug

Post #457388

kelleysimmons

Posted Wednesday, February 20, 2008 9:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2008 8:55 AM
Points: 3, Visits: 2

This is a great help and a perfect start, thanks so much for your help :)

Kelley

Post #458043

swineethamurthy

Posted Monday, July 28, 2008 12:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 22, 2010 2:05 AM
Points: 2, Visits: 5

Hi,

We have started monitoring our server's performance using PERFMON counter data.We have a doubt is by running this tool on the server(DB/APP server) of a site ,would result in any performance issues for the site/server?

Can anyone confirm us on the issues if any in just enabling the counters?

Post #541628

Scalability Doug

Posted Monday, July 28, 2008 6:24 AM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 05, 2012 12:43 PM
Points: 655, Visits: 6,097

IT depends on the number and type of counters used but in my eperience I've never seen more thant a 1% or 2% increase in CPU.

Post #541812

Grant Fritchey

Posted Monday, July 28, 2008 6:26 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:57 PM
Points: 13,371, Visits: 25,152

Just be sure that you're capturing them to a file and not using the GUI. If this causes your server to go down, you were already in severe trouble and you need this information.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #541816

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions