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

Database tuning

General database hardware recommendations

Comments