performance question - SQL2k sp3 -- sql server clustering

wasnotwas
9/30/2004 3:29:34 PM

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

Mike Epprecht (SQL MVP)
9/30/2004 10:37:03 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : performance question - SQL2k sp3