Monday, February 20, 2012

Queue IO

HI !
Does anybody know what is an ideal or problem issue conserning ! Queue I/O ( FOR READ AND WRITE ) ! What number is considered HIGH or normal ! Does anybody know that ?
Thank'Hi
There are chapters on this sort of thing in the following book:
http://www.sql-server-performance.com/sql_server_2000_performance_tuning_review.asp
I don't have it with me to look up, but low single figures are ideal! Any
figure that impacts on your SLA or the usability of the system is too
high!!!
John
"Carrasco" <anonymous@.discussions.microsoft.com> wrote in message
news:498F6762-0B5B-4636-97CC-E04B243A54CE@.microsoft.com...
> HI !
> Does anybody know what is an ideal or problem issue conserning ! Queue I/O
( FOR READ AND WRITE ) ! What number is considered HIGH or normal ! Does
anybody know that '
> Thank's
>|||average disk queue over 2.0 is getting high (from my experience)
Greg Jackson
PDX, Oregon|||a general rule of thumb in anything > 2 per spindle is worthy of further
investigation.
ie in a RAID 5 system with 7 disks - > 14 would be considered worthy of
further investigation (7 Disks x 2 per disk)
regards,
Andy.
"Carrasco" <anonymous@.discussions.microsoft.com> wrote in message
news:498F6762-0B5B-4636-97CC-E04B243A54CE@.microsoft.com...
> HI !
> Does anybody know what is an ideal or problem issue conserning ! Queue I/O
( FOR READ AND WRITE ) ! What number is considered HIGH or normal ! Does
anybody know that '
> Thank's
>

No comments:

Post a Comment