Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

Best Practices

The following are best practices from this chapter:

  • Verify that your hardware, devices, and drivers are supported by SQL Server 2008.
  • Stick to using the recommended or optimal hardware and software requirements when installing or upgrading to SQL Server 2008.
  • Leverage the planning tools and documentation associated with the SQL Server Installation Center when installing or upgrading to SQL Server 2008.
  • Run the System Configuration Checker tool as a prerequisite task when either installing or upgrading to SQL Server 2008.
  • Install and run the Upgrade Advisor to identify any upgrade anomalies when upgrading a system to SQL Server 2008.
  • When performing an upgrade, make sure you document your SQL Server system and database configuration information and perform a backup of any SQL Server data and objects that you want to keep.
  • Leverage Windows Server 2008 as the operating system when running SQL Server 2008.
  • Finalize a SQL Server implementation by hardening the system based on the best practices listed in Chapter 8.
  • Because the SAC tool has been deprecated, utilize Policy Based Management to configure the surface area of one or many SQL Server systems.
  • The Windows Server 2008 Advanced Firewall is enabled by default; therefore, review Chapter 8 to understand how to configure the firewall for SQL Server access.
  • Review Books Online if you need to upgrade other SQL Server 2008 features above and beyond the Database Engine.
  • Data, log, and tempdb directories should be on separate physical disks or Logical Unit Numbers (LUNs) for performance whenever possible.
  • + Share This
  • 🔖 Save To Your Account