October 20, 2008 at 1:26 am
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 Time60%
Buffer Manager
Buffer cache hit ratio98.54
Lazy wirtes/sec0
checkpoint pages/sec10.242
Sql Statistics
Batch requests/sec0
General statistics
user connection4
Memory Manager
Sql cache Memory (KB)344
Target server Memory (KB)3551424
Total server Memory (KB)1721600
SQL ERRORS
SQL errors/sec0
Memory
Memory pages/sec0
Logical Disk
Avg.diskqueueLenght0.496
Avg.diskreadqueueLenght0.036
Physical Disk
%Disk Time0.8
Avg.diskqueueLenght0.021
CurrentdiskqueueLenght0
Plan Cache
Cache Hit Ratio70.551
Number of deadlocks0
October 20, 2008 at 3:36 am
waiting for the reply....................
October 20, 2008 at 4:01 am
Are you experiencing a specific problem or just creating a performance baseline?
October 20, 2008 at 10:14 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply