r15 - 2015-01-23 - 17:54:24 - Main.sbeardYou are here: TWiki > 
Deployment Web > DeploymentAdminstering > ConfiguringAndTuningSQLServer
Deployment Web > DeploymentAdminstering > ConfiguringAndTuningSQLServerPage 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. |
- Your DBA should review: Optimizing server performance instructions. The subsections offer relevant information as well.
- 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:
Deployment.ConfiguringAndTuningSQLServer moved from Deployment.TuningSQLServer on 2013-11-30 - 17:54 by Main.sbeard -
-
Deployment web
-
Planning and design
- Installing and upgrading
- Migrating and evolving
- Integrating
- Administering
- Monitoring
- Troubleshooting
- ELM SaaS
Community information and contribution guidelines 
Topic list 
Search 
Advanced search 
Notify 
RSS 
Atom 
Changes 
Statistics 
Web preferences 
NOTE: Please use the Sandbox web for testing -
To do
-
Under construction
-
New
-
Updated
-
Constant change
- None - stable page
- Smaller versions of status icons for inline text:
-
Copyright © 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.