Help with file placement please...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mike Hibbert
    #1

    Help with file placement please...

    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
    Mike
    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: Help with file placement please...


      "Mike Hibbert" <mike.hibbert@z urich.com> wrote in message
      news:ea62ce5c.0 401070539.59081 858@posting.goo gle.com...[color=blue]
      > 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?[/color]

      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.)
      [color=blue]
      >
      > Or, do I just leave everything as it is?
      >
      > Cheers
      > Mike[/color]


        Comment

        Previous template Next
        Working...