Post reply

picking out dedicated sql server

  • November 16, 2006 at 3:27 pm

    #62381

    Guys I'm picking out a dedicated sql box that will be running

    sql server 2000 or 2005 I'm mainly trying to pick out the disk system.

    The box will hold about 10 sql server databases the system wil have 8 gigs of ram it will

    also be a dual 3gig 4 meg cache zeons. Also there will be a raid 1 with 2 73 gig grives and a

    raid 5 with 5 146 gig drives. I'm trying to decide if I need more than 73 gig drives for the

    mirror since I will install the os on the mirror also I wonder is 73 enough for the logs.

    So any help that you guys cane provide would be much appreciated.

  • November 16, 2006 at 3:38 pm

    #672484

    Are you saying that your want to put the transaction logs on the same mirrored set of disks with the OS?  Where is your paging file?

    The ideal situation would be seperate RAID sets for your OS, each data files, each transaction logs, and tempDB.  With this server servicing 10 DBs, I doubt you'll have the ability to split each MDF and LDF out to their own RAID set, but you should at least try to split out the OS, data, and t-log files (tempDB would be a bonus) onto their own RAID sets.  I would recommend that your t-logs are seperate from the disks that hold your OS's paging files.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • November 16, 2006 at 8:01 pm

    #672504

    "Are you saying that your want to put the transaction logs on the same mirrored set of disks with the OS?  Where is your paging file?"

     

    Yes I was going to put the t logs on the os drive I did not think that would be a problem but I see your point. Basically I should be keeping the data independent form the os by putting it on its on raid 1. I will than add an a raid 5 for the mdf files and another raid 1 for the tlogs.

  • November 17, 2006 at 5:12 am

    #672550

    Beware that RAID 5 is slower for writing. Consider RAID 1+0 instead.

  • November 17, 2006 at 5:45 am

    #672554

    I'd second that raid10 call.  Wrap the raid 5 5 disk into a r10 4 disk with a hotspare.  Or ideally add a load more disks - given the amount of ram you may as well get an external array - say 14 disks, on dual channels/cards in 2 8disk raid 10s and a hotspare!  You know you want it...

     

     

  • November 17, 2006 at 5:52 am

    #672557

    We talked about external disk I will have to check it out. Do you guys know of some good sas external arrays? Also if I did the raid 10 setup how should I break things up should I still have a mirror for the os I assime I should also do I put database files and logs on the raid 10 or is that just for that just for data files. If its just for data files do I need another mirror for the logs?

  • November 17, 2006 at 6:09 am

    #672560

    I went with a mirror for the os, a stripe for tempdb and mirror for logs, with a couple of raid10s for the data.  Worked nicely.

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

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