Help with file placement please... -- sql server (alternate)

mike.hibbert NO[at]SPAM zurich.com
1/7/2004 5:39:18 AM

Hello All,

I am looking at the performance of our production database. It is
40gb, and growing reasonably fast. It is placed in one file group on a
RAID-5 array. The array is made up of 20 (or so) 9gb disks. The data,
the indexes and the transaction log are all on the "one logical disk".

My question then, is, would it be better to move the transaction log
onto a separate device (with Raid-1), and then separate out the
indexes and the data and to place them onto separate devices (ie.
split the raid disks into 2 new drives). Or would it be better to
place the table into a larger number of smaller filegroups effectively
split across the raid device and to (strategically) place different
tables into the new logical disks. Does this make sense?

Or, do I just leave everything as it is?

Cheers

Greg D. Moore (Strider)
1/7/2004 2:31:33 PM

[quoted text, click to view]

Move your logs to a separate device. That's the best single thing you can
do for peformance here.

As for a larger number of smaller filegroups, under SQL 2000 that won't gain
you much performance-wise.

Though there may be reasons to do so from a maintenance POV (dependin on
your needs.)

[quoted text, click to view]

sql server (alternate) : Help with file placement please...