Skip to Content
0
Former Member
Oct 20, 2005 at 04:06 AM

SQL Server 7 - high disk msec/Read

48 Views

Dear SDN Experts,

I'm not familiar with SQL Server.

Could someone advise me what could be tuned on the SQL database if disk queue length & disk msec/Read are too high? These statistics are based on OS performance monitor.

Fyi, the CPU and Memory are low on usage.

How to tune the SQL database to improve the disk queue length and time it takes per Read from disk? Any buffering? Indexing? Kindly give some advice on the required How-To's.

Many Thanks.

Alfonso.