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

check counters Expand / Collapse
Author
Message
Posted Monday, October 20, 2008 1:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 3, 2014 2:59 AM
Points: 313, Visits: 538
hi all,

I m checking couters for performance tuning ...
server config 28 GB ram windows 2003 sql x64 enterprise edition 3GHz processor

i want more sugesstions for these counters .. is thr any thing which can be more added.. are this counters suffcient

database size 5 GB....

Counters
Processor Time 60%

Buffer Manager
Buffer cache hit ratio 98.54
Lazy wirtes/sec 0
checkpoint pages/sec 10.242

Sql Statistics
Batch requests/sec 0

General statistics
user connection 4

Memory Manager
Sql cache Memory (KB) 344
Target server Memory (KB) 3551424
Total server Memory (KB) 1721600

SQL ERRORS
SQL errors/sec 0

Memory
Memory pages/sec 0

Logical Disk
Avg.diskqueueLenght 0.496
Avg.diskreadqueueLenght 0.036

Physical Disk
%Disk Time 0.8
Avg.diskqueueLenght 0.021
CurrentdiskqueueLenght 0

Plan Cache
Cache Hit Ratio 70.551

Number of deadlocks 0



Post #588394
Posted Monday, October 20, 2008 3:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 3, 2014 2:59 AM
Points: 313, Visits: 538
waiting for the reply....................
Post #588434
Posted Monday, October 20, 2008 4:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 9:41 AM
Points: 1,159, Visits: 6,478
Are you experiencing a specific problem or just creating a performance baseline?
Post #588440
Posted Monday, October 20, 2008 10:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 3, 2014 2:59 AM
Points: 313, Visits: 538
creating performance baseline bcoz we need to do migration and i m doing testing with this scenario .so are this counters suffecient and wat about cache hit ratio .. is the cache hit ratio ok for this.
Post #588927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse