Help

Start a discussion
UNSOLVED

speedingwolf

updated

18 years ago

S

speedingwolf

18 Posts

0

9707

July 2nd, 2008 04:00

data base logs

Hi All,

 

I'm planning to install our SQL05 server and store its db files on the MD3000i. The server is Dell 1950 with RAID1 and partition C: for system and D: for database logs. From your experience, should I put the logs on the MD3000i as well? I read the best practices is to put logs on another controller in RAID1. Is this still apply if i put the diskgroup only for the sql server and put both logs and db files here?

 

Thanks,

  • DM

    Dev Mgr

    6 Operator

    •

    9308 Posts

    •

    3 Points

    283

    0

    Posted July 2nd, 2008 13:00

    I don't think the logs necessarily need to be on another 'controller', but definitely on a different set of physical disks.

    I'd suggest indeed 2 drives in a raid 1 for the logs and then 6 or more drives in a raid 10 for the actual database. Only put a single virtual disk in a diskgroup (max size).
  • S

    speedingwolf

    18 Posts

    283

    0

    Posted July 2nd, 2008 17:00

    Thanks Dev Mgr for your respond, as always!

     

Dell Support Resources

Latest Solutions

View More