DX Infrastructure Management

Expand all | Collapse all

MSSQL DB Version

  • 1.  MSSQL DB Version

    Posted 09-08-2017 10:42 AM

    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.

    Thanks



  • 2.  Re: MSSQL DB Version

    Posted 09-08-2017 10:46 AM

    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.



  • 3.  Re: MSSQL DB Version

    Posted 09-13-2017 07:05 AM

    Does UIM also support the table compression if used SQL enterprise version?



  • 4.  Re: MSSQL DB Version

    Posted 09-08-2017 11:00 AM