Implementation > Database Implementation

Database Implementation

Database responsiveness is critical for the CMS application. CMS is a typical online transaction processing (OLTP) application, which requires good read and write performance. It is recommended for the database administrator to identify workloads and plan the DB online maintenance scripts.

Let us assume a scenario where a DB insert query is slow and you would like to understand the DB bottleneck. First, identify if it is an infrastructure issue (bottlenecks in CPU, memory, I/O, and so on). If not, you might need to look at the following DB performance bottleneck issues:

  • tempdb bottlenecks
  • Transaction log bottlenecks deadlocks
  • Indexing issues

Always use the Database Guide and the Support Matrix as validators to check if you have the database server set up properly. Before the UCMDB server goes for production, make sure the DB administrator has enabled monitoring and is capturing all required metrics for effective analysis. If you have products such as Micro Focus Operations Manager agent with Oracle SPI, the agent will have some OOTB policies to capture the DB metrics which can then be visualized via Micro Focus Performance Manager.

If you have Oracle installed on UNIX machine which has Micro Focus OpenView Performance Agent, then you can customize the parm (/var/opt/perf/parm) file to get Oracle related process information.

Database # CI Support

Database Infrastructure Requirements (10.2x)

10.2x # Processors Physical Memory
Minimum RAM Maximum RAM
Small Deployment 1 dual core 4G 8G
Large Deployment Minimum 2 dual core or 1 quad core 8G 16G