Post reply

Guidelines to setup db part of data centre

  • April 8, 2015 at 10:46 pm

    #306729

    Hi

    My company is migrating all their servers to a new data centre and I get to specify what we need for the db servers.

    We've got a 22 prod servers (mainly physical) with a couple of TB of data on sql 2000 to 2012.

    We expect to move to sql2014, and consolidate and virtualise where ever possible.

    But I'd like start with specifying an overall architecture for this: some Best Practices to guide the build at a server and an installation level

    Can anyone point me in the right direction.

    TIA

    Martin

  • April 9, 2015 at 12:47 pm

    #1789977

    This is a loaded topic. A few thoughts....

    Get your disk configuration right. It's nice to split up your IO between different physical disks; such as:

    C: OS Files

    D: Program File/SQL Install

    E: TempDB

    F: Data files (MDF/NDF)

    G: Log files (LDF)

    H: Backups

    Allocate space correctly and use the right disk config/RAID level for the job... Note: http://sqlmag.com/storage/sql-server-storage-best-practices%5B/url%5D

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply