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 Monday, February 18, 2008 8:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, February 18, 2008 8:31 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
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
Posted Tuesday, February 19, 2008 4:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, February 19, 2008 4:37 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
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
Posted Tuesday, February 19, 2008 5:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:26 PM
Points: 13,871, Visits: 28,266
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 Query Performance Tuning
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
Posted Tuesday, February 19, 2008 7:43 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 2:01 PM
Points: 659, Visits: 6,104
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
Posted Wednesday, February 20, 2008 9:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, July 28, 2008 12:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, July 28, 2008 6:24 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 2:01 PM
Points: 659, Visits: 6,104
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
Posted Monday, July 28, 2008 6:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:26 PM
Points: 13,871, Visits: 28,266
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 Query Performance Tuning
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 »

Add to briefcase 12»»

Permissions Expand / Collapse