none
Installing DPM on a server with solid state disks RRS feed

  • Question

  • Hi

    I am putting a spec together for a DPM 2012 R2 server to protect about 9Tb of data and have so far come up with the following spec:

    Dell PowerEdge R630 server:

    Disk config:

    • C drive (OS) - 2 x 300Gb 15k disks
    • D drive (DPM Database) - 2 x 300Gb 15k disks
    • E drive (SQL transaction logs) - 2 x 300Gb 15k disks
    • F drive (Temp Database) - 2 X 300Gb 15k disks
    • R drive (Recovery area) - 2 x 1Tb 10k disks

    RAM: 64Gb

    NICs 2 x 10Gbps

    DPM Storage - Dell MD1220 with 24 x 1.8Tb drives providing 39.6Tb (RAID 5 with 1 hot spare)

    SAS Cards

    • 2 x 6Gbps SAS for a dual drive TL2000 tape library
    • 1 x 6Gbps SAS for MD1220

    I have been asked to spec the server with solid state drives and wanted some opinions on whether this would be a good idea or not - it initially strikes me as being overkill to say the least but wondered if anyone had had any situations where they have used SSD for their DPM server before?  Our main bottleneck at present is the network, but that is being spec'd for an upgrade as well to be implemented alongside this DPM server.  We also have a Hyper-V Cluster Shared Volume running on Hyper-V 2012 R2 which will need its VMs backed up and that needs an upgrade as well.

    If I did go for SSD, would it be a like for like swap with the drive configuration I have above, or would it be better to have a single SSD RAID 1 with the database, transaction log files and SQL temp db on it together and maybe another for the OS?  I've not used SSDs before in a server, so any advice for or against this suggestion would be most welcome.

    Thanks

    Chris

    Tuesday, June 12, 2018 9:12 AM

Answers

  • Hi!

    I have experience with SSD disks on the DPM server, I have also run a DPM on 10K & 15K disks previously and never really had any SQL performance issues, some might call it overkill with SSDs, but if you can afford it then go for it, but it is not a requirement.

    For the OS it won't really matter much what disks you use, either way go with a RAID1.

    If you have the possibility then go for SSD disks for both the SQL database and the SQL transaction logs and have them on separate RAID1 disks, as the data & log files are the ones which will benefit from being on high write performance drives.

    The Temp database and the recovery will be fine on slower disks.

    Otherwise your setup looks really good and very powerful to run DPM.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com  LinkedIn:   


    • Edited by Leon Laude Tuesday, June 12, 2018 1:40 PM typo
    • Marked as answer by chris624 Tuesday, June 12, 2018 2:32 PM
    Tuesday, June 12, 2018 1:39 PM
  • Unfortunately DPM 2012 R2 doesn't support SQL Server 2016 for hosting the DPM database, but it does support SQL Server 2014 with Update RollUp 4 installed.

    Here's the link for you!

    https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/jj860400(v%3dsc.12)

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com  LinkedIn:   

    • Marked as answer by chris624 Tuesday, June 12, 2018 2:33 PM
    Tuesday, June 12, 2018 2:15 PM

All replies

  • Hi!

    I have experience with SSD disks on the DPM server, I have also run a DPM on 10K & 15K disks previously and never really had any SQL performance issues, some might call it overkill with SSDs, but if you can afford it then go for it, but it is not a requirement.

    For the OS it won't really matter much what disks you use, either way go with a RAID1.

    If you have the possibility then go for SSD disks for both the SQL database and the SQL transaction logs and have them on separate RAID1 disks, as the data & log files are the ones which will benefit from being on high write performance drives.

    The Temp database and the recovery will be fine on slower disks.

    Otherwise your setup looks really good and very powerful to run DPM.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com  LinkedIn:   


    • Edited by Leon Laude Tuesday, June 12, 2018 1:40 PM typo
    • Marked as answer by chris624 Tuesday, June 12, 2018 2:32 PM
    Tuesday, June 12, 2018 1:39 PM
  • Thanks Leon,

    That's great info....  Do you also know if DPM 2012 R2 can be installed on SQL 2016 or does it need to be SQL 2012?  I am struggling to find info from Microsoft as the system requirements for DPM are annoyingly only showing versions 1801 and 2016.

    Cheers


    Chris

    Tuesday, June 12, 2018 2:09 PM
  • Unfortunately DPM 2012 R2 doesn't support SQL Server 2016 for hosting the DPM database, but it does support SQL Server 2014 with Update RollUp 4 installed.

    Here's the link for you!

    https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/jj860400(v%3dsc.12)

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com  LinkedIn:   

    • Marked as answer by chris624 Tuesday, June 12, 2018 2:33 PM
    Tuesday, June 12, 2018 2:15 PM
  • Thanks Leon,

    That's great,

    Cheers

    Chris

    Tuesday, June 12, 2018 2:32 PM
  • You're welcome, have a nice day!

    Blog: https://thesystemcenterblog.com  LinkedIn:   

    Tuesday, June 12, 2018 2:33 PM
  • Hi Leon,

    Just another quick question, but if I was to use SQL 2014 would I be able to install DPM 2012 R2 straight onto it, using it for the DPM database, and then apply the latest update rollup, or would I have to initially use SQL 2012, install DPM, apply the update rollup and then upgrade to SQL 2014?

    Chris

    Thursday, June 14, 2018 11:54 AM
  • Hi,

    A new installation of DPM 2012 R2 cannot be installed on SQL Server 2014, you will have to install the Update RollUp 6 first. To use SQL Server 2014 with DPM 2012 R2, you must install DPM 2012 R2 with SQL Server 2012, and then upgrade to SQL Server 2014.

    Hope this helps!

    Best regards,
    Leon 


    Blog: https://thesystemcenterblog.com  LinkedIn:   

    Thursday, June 14, 2018 12:04 PM
  • Thanks again Leon... :-)

    Chris


    • Edited by chris624 Thursday, June 14, 2018 12:10 PM
    Thursday, June 14, 2018 12:09 PM