Hi GUYS,
in my sql server recently i am getting high Avg. Disk
Queue Length of 40 for an array of 4 disks in every 5
minutes for around 20 sec and during this period the
server performance is poor.
any ideas?
thanks
Biju

Use the profiler to trace the query stream. You should filer on duration,
say, 5000 ms. When the disk queue shoots up, note the activity in the
profiler. Then, go after those queries.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
..
"biju george" <bijupg (AT) hotmail (DOT) com> wrote

Hi GUYS,
in my sql server recently i am getting high Avg. Disk
Queue Length of 40 for an array of 4 disks in every 5
minutes for around 20 sec and during this period the
server performance is poor.
any ideas?
thanks
Biju