Announcement

Collapse
No announcement yet.

[SQL] SQL server setup best practice.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SQL] SQL server setup best practice.

    Well i don't know where to fit this topic so im trying here.

    Im busy setting up a new SQL 2005 machine to function as a central db box for all of the network applications.

    Now what Ive bought is a IBM x3650 with 2x Xeon Quadcores, 12gb ram and 8x 146gb SAS disks.

    Now im not worried about the performance of the entire machine but im not 100% sure what to do with the disks to ensure optimum performance. i have come up with the foloowing and i would like to hear your advice on this.

    I thought of 2x disks in raid1 for the OS + app | 2disks in raid1 for the transaction logs | 4 disks in raid5 for the actual db data.

    Any suggestions ?
    MCITP:SA 2008, MCITP:EA 2008
    MCTS Vista, MCTS Windows 7
    Cisco Certified Network Associate
    ITIL Practitioner V3
    IBM Certified Specialist: System X
    IBM Certified Systems Expert: BladeCenter
    VMWare Certified Professional
    Working on:
    Bcom Criminology, MS OCS

  • #2
    Re: [SQL] SQL server setup best practice.

    Sounds ok to me. If you had the budget, drives, server capacity and RAID capability, see if you can use Raid 10 on log files and database files. Also, some will also move the tempdb to a separate Raid but I wouldn't say you need to worry about that as much.

    Comment


    • #3
      Re: [SQL] SQL server setup best practice.

      well this is gonna be for 100 users with an estimated max active connections of around 40 so i think ill be fine for the next few years
      MCITP:SA 2008, MCITP:EA 2008
      MCTS Vista, MCTS Windows 7
      Cisco Certified Network Associate
      ITIL Practitioner V3
      IBM Certified Specialist: System X
      IBM Certified Systems Expert: BladeCenter
      VMWare Certified Professional
      Working on:
      Bcom Criminology, MS OCS

      Comment


      • #4
        Re: [SQL] SQL server setup best practice.

        Your right. That will be more than adequate then.

        Comment


        • #5
          Re: [SQL] SQL server setup best practice.

          Some would also recommend splitting the various I/O loads across separate channels or RAID controllers. Unless you're 100 users are doing some crazy data mining, that shouldn't be necessary though. Also, you may want to put the page file on a separate non-system disk. Make sure that the minimum and maximum page file size is the same (maybe about 18GB in your case) and the system can't auto adjust it.
          Wesley David
          LinkedIn | Careers 2.0
          -------------------------------
          Microsoft Certifications: MCSE 2003 | MCSA:Messaging 2003 | MCITP:EA, SA, EST | MCTS: a'plenty | MCDST
          Vendor Neutral Certifications: CWNA
          Blog: www.TheNubbyAdmin.com || Twitter: @Nonapeptide || GTalk, Reader and Google+: [email protected] || Skype: Wesley.Nonapeptide
          Goofy kitten avatar photo from Troy Snow: flickr.com/photos/troysnow/

          Comment

          Working...
          X