Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008

    Unanswered: MSSQL 2005, new hardware - HD separation


    I have a client who is in the market for a dedicated SQL box. It's a smaller company of 50 users. The primary task of this machine is a backend for Sharepoint 2007. At first I'm stuck using MSSQL 2000 for a few months until the budget can be approved to upgrade them to 2005.

    I intend to spec this machine out for 2005, the question I have at the moment pertains to the HD configurations.

    How would you recommend rigging that up?

    Mirror for system, Mirror for the data store, mirror for transaction/temp files?

    Put everything on a Raid-5 and forget about it?

    I also have a question about Quad Core processors. How does MS sql's licensing work on that?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    For 50 users, you don't have to do very much. For best practice sake, I would have at least three physical devices. One for the OS to play with, one for the data, and one for temp/logs. If you can not get that, there is no big problem, as I would be very surprised if 50 users can stress a system that badly.

Posting Permissions

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