Database best practices

This section provides general database hardware recommendations and hardware sizing guidelines 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.

This section provides recommendations for the following databases:

This topic also includes:

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

Hardware sizing recommendations

The following table lists sizing recommendations for the dedicated hardware resources required by the server database, depending on the number of nodes.

Number of nodes

Memory

CPU/Core/Speed/Cache

Estimated database size

20,000

16 GB

2/4/2 GHz/8.0 MB

20 GB

50,000

24 GB

2/4/3 GHz/12 MB

50 GB

100,000

48 GB

2/8/3 GHz/20 MB

100 GB

150,000

72 GB

2/8/3 GHz/20 MB

150 GB

200,000

96 GB

2/8/3 GHz/20 MB

200 GB

Was this page helpful? Yes No Submitting... Thank you

Comments