Verify the database server requirements


The database is an important part of BMC Client Management, especially in highly distributed environments.

Database prerequisites

The BMC Client Management setup offers the possibility to install MS SQL Server Express on the master server for Windows platforms that have no database engine already installed on their network. MS SQL Server Express is installed during master server installation. If you have a version of MS SQL Server, Oracle, or PostgreSQL already installed, you must ensure that the following prerequisites are fulfilled before starting the Client Management setup process:

The following table lists hardware requirements for a dedicated database server used with BMC Client Management.

Hardware type

Recommendation

Disks

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

File system

  • EXT3/EXT4 for Linux
  • NTFS for Windows

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

The following table lists the hardware sizing requirements for the dedicated database server, based on the number of nodes.*

Number of nodes

Memory

CPU/Core/Speed/Cache

Estimated BCM database size (1)

5,000

8 GB

2/4/2 GHz/8.0 MB

5 GB

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

This is the estimated disk size for storing only Client Management generated data. For detailed information on the required database size and best practices.

 

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