I just want need opinion regarding the UIM implementation, we have plan to setup our production UIM servers with 3 primary hubs running in a High Availability, 5 servers on secondary hubs and mssql server in a cluster environment. This UIM will monitor almost 1600 servers.
In the CA docops documentation have advise to use Mssql Server Enterprise Edition for the database system because it is supports table and index partitioning. Please refer to the link “https://docops.ca.com/ca-unified-infrastructure-management/8-4/en/installing-ca-uim/pre-installation-planning/install-and-configure-your-database-software#InstallandConfigureYourDatabaseSoftware-MicrosoftSQLServer”
In this case, based on the size of the implementation, do I need the table and index partition to support for this implementation? Can I use Mssql Server Standard Edition?