We moved a large database & application from a single server with RAID
drives to a clustered server with a SAN and are not seeing any performance
gains. Statistics were updated, procs recompiled, etc. after the move. The
CPU load is lower (as seen in perfmon), and the SAN disks are also not
working nearly as hard as the RAID was, but the application shows no speed
improvement. Any thoughts on where to look next?

thx.

k

Hi

Generally, moving to a SAN will not improve performance, but might decrease
it due to the higher IO latency.

Disk layout is important, make sure your transaction logs are on a seperate
volume, with RAID-1 or RAID 10. If possible, don't put your data on RAID-5,
but RAID-10.

Run profiler to find your slowest queries and see if you can not optimize
them with indexing.

Regards
Mike

"wasnotwas" wrote: