Database tuning

This section provides general database hardware recommendations for your configuration.

Optimal database performance requires regular monitoring and health checks. BMC recommends analyzing the longest running queries and modifying indexes to improve the overall performance.

Related topics

System-requirements

Supported-configurations

License-entitlements

High-availability-deployment-and-best-practices

Best-practices-for-mobile-device-manager

Supported-languages

General database hardware recommendations

The following table lists hardware recommendations for any database server used with BMC Client Management .

Hardware type

Recommendation

Disks

  • SAS disks
  • 10,000 - 15,000 RPM or higher

RAID

RAID 10 or 1+0, RAID 10 for write-heavy environments and high-performance database systems

Disk controllers

Separate disk controller, to free the CPU to perform other tasks. A separate disk controller also manages the movement of the disk head and reading or writing of data on the disk.

Memory

ECC RAM

CPUs

  • High speed
  • Large L2 cache for dealing with large amounts of data
  • 64-bit performance

Network

  • Gigabyte
  • Dedicated connections between application and database server

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*