We are planning to host 15k Server under monitoring using CA UIM 8.51 , Which Version of MSSQL server should be used in this kind of big environment. And why?
Is there any IOPS guide which can be used in case of 2TB storage capacity planning, where UMP will read data from DB and Data retention would be one year.
For a 2 TB database support would suggest SQL Server 2014 enterprise addition so that data table partitioning can be enabled.
This generally will help with all performance from data grooming to reports.
Does UIM also support the table compression if used SQL enterprise version?
Best Practice Guide.