Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003

    Unanswered: The hard drive configuration

    Hello, everyone:

    Does any one have an idea for hard drive configuration on SQL Server 2K? How to determine the RAID level for datafile and log file? Thanks


  2. #2
    Join Date
    Aug 2003
    Kingston, Ontario

  3. #3
    Join Date
    Feb 2004
    San Antonio, TX
    i have been using the following suggestions
    raid 01 for mdf ,ndf
    raid 1 (duplexed) for ldf

    create the database (system tables mdf)
    then create a seperate file ndf for the data portions on your datastore.
    place this ndf in a seperate filegroup and make the new filegroup the default filegroup.
    this causes all objects to be created in the new filegroup, away from the io that reading and writing to the database catalog will create as users try to gain access to the database and it's objects.

    keep the log on a seperate mirrored (duplexed) drive to avoid the direct disk contention that anything on the disk with the log will generate.

    try not to use raid 5 due to the excessive io that comes with each disk write.

    with this said, understand that the bean counters wont allocate funds for you so you may end up installing on an thomas edison Phonograph Cylinder
    whew all that work for that obscure reference
    Last edited by Ruprect; 04-07-04 at 18:51.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts