March 18, 2004 at 8:05 am
Can some one please tell me how I can messure or calculate the average disk services times of a specified disk on my SQL*Server
March 19, 2004 at 2:01 pm
Have you tried using Performance Monitor from the OS? The Physical Disk performance Object has several counters for Activity%, Reads/Writes per sec., etc. If the server is dedicated to SQL, PM may provide you with what you need. If the server is shared then the information may be less useful.
March 22, 2004 at 1:48 am
I think I find it out
It's Avg Disk sec / transfer . This counter reflects how much time a disk takes to fulfill requests.
Values lower than 0,3 seconds on your phisical disks are recomended.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply