September 15, 2011 at 8:06 am
What is the solution for this problem
How to calculte the Avg Disk Hit Ratio in sql
September 15, 2011 at 8:10 am
Please don't cross-post, it just fragments replies and wastes everyone's time.
Forward all replies here plz : http://www.sqlservercentral.com/Forums/Topic1175734-1550-1.aspx
September 15, 2011 at 8:38 am
the average should be under 15ms with maximums up to 25ms. If your numbers are below these values then your I/O is in good standing and no additional disk bottleneck analysis is required. This rule of thumb can be used for any type of system
September 15, 2011 at 8:41 am
So the two primary counters used for quickly analyzing disk performance are:
• Avg. Disk sec/Read - is the average time, in seconds, of a read of data from the disk.
• Avg. Disk sec/Write - is the average time, in seconds, of a write of data to the disk.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply