TheSQLGuru (4/25/2012)
GilaMonster (4/25/2012)
TheSQLGuru (4/25/2012)
SQLIOSIM is the tool to use to validate that an IO subsystem will properly handle SQL Server IO-style workloads.But SQL needs to be stopped when running that. The aim is to validate the IO subsystem, nor slaughter it.
I thought he/she said they wanted to know if the IO subsystem had problems with SQL Server data that was causing problems. SQLIOSIM is a/the way to validate that.
Sure, but they can't stop SQL Server without justification (proof of IO problems). Vicious circle.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability