r15 - 2015-01-23 - 17:54:24 - StevenBeardYou are here: TWiki >  Deployment Web > DeploymentAdminstering > ConfiguringAndTuningSQLServer

new.png Configuring and tuning SQL Server

Authors: PatrickRemington
Build basis: CLM 2012, CLM 2011

Page contents

Initial assessment

Database Tuning is outside of the scope of the Jazz Administrator. Any information contained below is for reference only and should be passed on to your database administrator.

SQL Server 2008 R2 Optimization

  • Your DBA should enable row versioning, if it is not already enabled. Steps to do so can be found here: Enable Row Versioning. In particular, the READ_COMMITTED_SNAPSHOT setting should be turned ON.

  • Database tuning information can be found here: Tuning the Physical Database Design There are subsections that should be reviewed. In particular, there is a section on the Database Engine Tuning Advisor which will help in understanding whether additional indexes need to be added to your databases.

Related topics: None

External links:

  • None

Additional contributors: None

Questions and comments:

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r15 < r14 < r13 < r12 < r11 | More topic actions
Deployment.ConfiguringAndTuningSQLServer moved from Deployment.TuningSQLServer on 2013-11-30 - 17:54 by StevenBeard -
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Ideas, requests, problems regarding the Deployment wiki? Create a new task in the RTC Deployment wiki project