+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, New SIMS server installation in Technical; We will be commissioning a new Dell R720 server to replace our current ageing SIMS server and have a question ...
  1. #1

    Join Date
    Sep 2009
    Location
    North West
    Posts
    263
    Thank Post
    27
    Thanked 22 Times in 20 Posts
    Rep Power
    19

    New SIMS server installation

    We will be commissioning a new Dell R720 server to replace our current ageing SIMS server and have a question about where to put the SIMS SQL Database.

    The Server is going to have 2x200GB (Raid 1) SSD drives for the OS and 4x300GB (Raid TBD) 15K SAS drives.

    Do I put the database on the SSDs or do I put them on the 15K SAS Drives?

    What are people thoughts on this?

    Thanks
    Mark

  2. #2

    Join Date
    Jan 2012
    Posts
    678
    Thank Post
    264
    Thanked 98 Times in 81 Posts
    Rep Power
    27
    I'd keep the OS and database separate if it were me. We had our server specced with 5xSSD's and did the same split

  3. Thanks to Bananas from:

    mdrabble (16th May 2014)

  4. #3

    Join Date
    Sep 2009
    Location
    North West
    Posts
    263
    Thank Post
    27
    Thanked 22 Times in 20 Posts
    Rep Power
    19
    That was my original intention to keep them separate but then thought about using the speed of the SSDs.

    We already have the new server, so bit late to change drives unless I put off the installation/migration

  5. #4

    Join Date
    Jan 2012
    Posts
    678
    Thank Post
    264
    Thanked 98 Times in 81 Posts
    Rep Power
    27
    Tough one that, you could partition the SSD drives to an OS and data partition if nothing else. This is going to be one of those situations where there's no correct answer

  6. #5
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Put it on the SSD for sure.

    We have ours on a 300GB virtual machines with a single SSD drive.

    Works great and is really fast.

    Microsoft's advice to put the SQL db on a separate disk is out of date, when it comes to SSD drives there is no performance improvement separating them.
    Last edited by zag; 16th May 2014 at 11:01 AM.

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I thought it odd to spec SSD for the OS. I still think regardless of the type of hardware separating to different units is worthwhile.

  8. #7
    AButters's Avatar
    Join Date
    Feb 2012
    Location
    Wales
    Posts
    465
    Thank Post
    140
    Thanked 107 Times in 82 Posts
    Rep Power
    41
    Swap it around. Use 3 x 300GB (plus 1 as a hot spare) for the O/S and the 2 x 256GB(?) SSD for the Database. Have the database back itself up to the O/S drive every night for good measure.

    It's a bit academic as if you're using 16 or more GB RAM accesible by SQL all writes will be written to ram and then occasionally offloaded to disk so SSD won't speed up write speed. It will of course speed up read speed which could be handy if you for example regularly open whole school attendace on more than one workstation.
    Last edited by AButters; 16th May 2014 at 01:00 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] New SIMS server install
    By Philip60 in forum MIS Systems
    Replies: 6
    Last Post: 4th November 2013, 06:13 AM
  2. [SIMS] Installing a new sims server
    By boolyn in forum MIS Systems
    Replies: 7
    Last Post: 9th November 2011, 11:32 AM
  3. Replies: 4
    Last Post: 29th October 2007, 12:21 PM
  4. Installing a new SIMS server ... in exam season !!
    By bobwright in forum MIS Systems
    Replies: 8
    Last Post: 21st June 2007, 08:49 AM
  5. Installing a new sims server
    By wesleyw in forum MIS Systems
    Replies: 4
    Last Post: 22nd January 2007, 09:34 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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