<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"/> Configuring and tuning databases %DKGRAY% Authors: [[Main.DavidToczala][DanToczala]] <br> Build basis: CLM2012, CLM 2011 %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> ---++ General guidance The database server is the portion of most Jazz solutions that is often out of the control of most solution architects and Jazz administrators. Often, the choice of database vendor is a corporate directive and you are told the database technology that you will use. If you decide to support your own database, you can choose the database technology that you want. Keep in mind that Jazz licenses also carry an entitlement for the use of DB2 Workgroup edition as part of the Jazz licensing agreement. There are some general things that you can do to help improve the performance of your Jazz solution. These suggestions are valid for all the database technologies that support Jazz: * Make sure that your database has sufficient physical memory and enough allocated memory to perform a lot of data transfers. All of the REST-based objects will need to be stored and retrieved here, and the rest of the solution architecture depends on the repository. Do not try to cut costs: make sure that the foundation for your solution is solid. * Your database should be on a dedicated server. While it is technically possible to install the database software onto the same machine as other software, the load on the database is heavy (because almost every user action implies multiple database events, like queries, inserts, or modifications). Deploy the database on a dedicated database server. * The storage device for the database is also important. The database storage should be fast storage. The server should have many fast disks combined in a RAID configuration for optimal performance and reliability. See the [[https://jazz.net/][Jazz.net]] article about [[https://jazz.net/library/article/557][Tuning the Rational Team Concert 3.0 Server]] for further details. * Monitor the performance of your database. Do not go overboard with monitoring, because excessive monitoring can lead to performance degradation of the database software. Monitor the amount of data (inbound and outbound), the number of queries over time, and some measure of the amount of time from the receipt of an SQL request to the time a response is generated. ---+++++!! Related topics: None ---+++++!! External links: * None ---+++++!! Additional contributors: None ---+++++!! Questions and comments: %COMMENT{type="below" target="ConfiguringAndTuningDBGeneralComments" button="Submit"}% %INCLUDE{"ConfiguringAndTuningDBGeneralComments"}% <sticky></div></sticky>
This topic: Deployment
>
WebHome
>
DeploymentAdminstering
>
ConfiguringAndTuningDBGeneral
History: r11 - 2015-01-23 - 17:54:23 - Main.sbeard
Copyright © by IBM and non-IBM 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
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.