+ 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
    281
    Thank Post
    29
    Thanked 27 Times in 24 Posts
    Rep Power
    21

    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
    679
    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
    281
    Thank Post
    29
    Thanked 27 Times in 24 Posts
    Rep Power
    21
    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
    679
    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,946
    Thank Post
    967
    Thanked 461 Times in 388 Posts
    Blog Entries
    12
    Rep Power
    94
    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 12:01 PM.

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    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
    522
    Thank Post
    166
    Thanked 116 Times in 89 Posts
    Rep Power
    45
    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 02: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, 07:13 AM
  2. [SIMS] Installing a new sims server
    By boolyn in forum MIS Systems
    Replies: 7
    Last Post: 9th November 2011, 12:32 PM
  3. Replies: 4
    Last Post: 29th October 2007, 01:21 PM
  4. Installing a new SIMS server ... in exam season !!
    By bobwright in forum MIS Systems
    Replies: 8
    Last Post: 21st June 2007, 09:49 AM
  5. Installing a new sims server
    By wesleyw in forum MIS Systems
    Replies: 4
    Last Post: 22nd January 2007, 10: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
  •