UNSOLVED

TCLiven

updated

14 years ago

T

TCLiven

44 Posts

0

1058

September 11th, 2012 09:00

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!