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

SQL server and system counters list Expand / Collapse
Author
Message
Posted Monday, February 15, 2010 9:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:46 AM
Points: 101, Visits: 842
Hi all,

please give me any url or document where i check the Avarage value (minimum required) of All SQL server and system counters list so i identify the performnce issue

(List of Threshold Value for SQL Server Performance Counters )


Regards,
Shivrudra W
Post #865586
Posted Monday, February 15, 2010 12:10 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 21,290, Visits: 14,982
Here is a nice resource on the topic
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/





Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #865665
Posted Tuesday, February 16, 2010 7:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:50 AM
Points: 11,192, Visits: 11,098
I would recommend you take a look at This Microsoft Best Practice White Paper too.

Paul




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #866121
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse