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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 18, 2013 7:00 AM
Points: 99, Visits: 837
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858, Visits: 12,443
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 2008


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: Yesterday @ 10:48 AM
Points: 10,990, Visits: 10,578
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