SQL SERVER 2008 R2 Install best practice?

  • Interested in learning things I can do during install to help availability and performance for the long haul.

  • The procedures aren't much different in SQL 2008 R2 as they are in other versions. Some basic things to keep in mind (I'm sure others can add to the list):

    1. Make sure drives are pre-sized for expected growth. This is less of a concern if the drives are dynamic but still important to avoid having to periodically shrink files.

    2. Make sure the service account is a Domain account that will be a standard account used only for SQL. Changing the SQL Service account later on will cause downtime.

    3. Don't create your user database files on the C drive!

    4. If you have the luxury, put your tempdb files on a separate LUN and ideally a separate volume.

    5. Remove BUILTIN\ADMINISTRATOR right away. This can be a tricky thing to remove later once people get their hooks into your SQL instance.

    6. Develop good, standard maintenance plans that include reorgs, backups, and stat updates.

    That's just my quick brain dump. Good luck!

  • Thanks!

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

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