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.