I have a MSSQL Server 2008 R2 database running on a dedicated server (windows 2008) with 1 CPU and 6 cores and 2 disks that are software mirrored.
I have been having some issues with SQL performance and the last one seemed to be related to lots of waiting processes that referenced wait type of IO_COMPLETION. Does this indicate a disk problem?
I'm not sure what I should be monitoring, I've tried adding the Physical Disk Queue Length and this fluctuates between 0 and 10 up and down pretty consistently, does this indicate a problem? or should I be monitoring something else?
Any help greatly appreciated, thanks.