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 |
|
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 |
|
Network |
|
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 |
Comments
Log in or register to comment.