Post reply

Log and DB placement.

  • June 20, 2008 at 4:38 am

    #122831

    Hello,

    I have a quick question for those with more experience than I. I have a server with 2 disks, one of those disks has the OS and SQL(2000), the other has the DB and logs. The perfomance is pretty dire so I am putting a bit more RAM in it (which it definatly needs) but will I get a perfomance gain if I move the logs onto the same physical disk as the OS, or maybe put the DB in the OS disk?

    Thanks for any help.

    Regards,

    D.

  • June 20, 2008 at 5:26 am

    #831647

    Are they two different physical disks, or a single disk or array with two logical partitions?

    The advantage of having your database file and log file on different physical disks is that you end up with read and write heads that can act independantly of each other. So, you can write to the transaction log while writing to the database file. If the disks are just two logical partitions, you have not split the work onto two sets of read/write heads, so you will see no performance benefit.

    In addition to that, the RAID configuration of the disks will be pretty important as well as the type and speed of the drives, the number of type of controller cards, etc.

  • June 20, 2008 at 5:29 am

    #831652

    Hi,

    Thanks for getting back. The server is not that flash and quite old. Its just 2 physical disks, one C: and one D:.

    Regards,

    D

  • June 20, 2008 at 5:45 am

    #831665

    I wouldn't suggest putting the log on the OS drive. If you do that it's compeating with the swap file. Bad idea.

    Can you buy a 3rd drive?

    Where's TempDB?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 20, 2008 at 7:34 am

    #831755

    As Gail suggested.. see if you can get another HDD.

    Else always keep them seprate from OS Drive.. Anywways.. what is the size of each drives and how much free space is available in each drive....

    Maninder
    www.dbanation.com

  • June 20, 2008 at 9:23 am

    #831885

    Hello,

    Quite a bit space on the drives, I did have the idea of adding another drive, and I have just looked inside and there is space for one, so I am going to go with that.

    Thanks to all of you for your help.

    Kind Regards,

    D.

  • June 20, 2008 at 10:19 am

    #831928

    Actually if it's just 2 or 3 drives, implement RAID first. If a drive fails, you're in trouble. That's more important than moving stuff around.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply