Ok, here is the problem.
Our Prod system is having Performance problems.
what I know:
All drives are RAID 5 (ON an EMC SAN).
We use TempDB a LOT (I know, I know...we shouldnt)
TempDB is Placed on the same logic drive as the Data
So....I recommend that we switch to RAID 1+0 (we are not a broke company)
I recommend moving TempDB to it's own logical drive RAID 0, 1 or 1+0 (Not 5)
the hardware guys say "This is not the problem"
so.....I need Statistics to PROVE that my hunch is correct.
how do I gather stats to PROVE that moving TempDB and switching to RAID 1+0 will improve perf by more than just a few % points...?
we are not seeing massive Disk Queueing at this point. So what other stats do I grab to prove my point ?
Gregory A Jackson MBA, CSM