
UNSOLVED
FAST, Pools and SQL I/O Contention
Hi All -
We have a CX4-480 (4.30), FAST enabled with 1 general pool that consists of SATA, FC and SSD drives. I have a DBA telling me that his SQL 2008 R2 db is stating it is running into i/o contention on a specific drive. We have our SQL data and log's separated on different LUNs. When I run Analyzer on the drive the DBA is telling me SQL is having challenges with, Analyzer does not find any major i/o contention. Has anyone else been unable to actually match up reported SQL i/o contention with SAN LUN contention and if so... what did you end up doing to fix it, if anything?
Maybe I am not looking at the right stats. I am looking at Read and Write IO/s Throughput, can some suggest other stats that may be more useful? Thanks!
Responses (0)
Solutions (0)
