Prerequisites for SQL Server

  • Database User security role: Create a database login dbclient using SQL server authentication with server roles as sysadmin and public
  • Database and schema access: Installer will make use of the above login to create necessary databases and schemas required for the selected Quantum Fabric components.
  • Database Growth sizing: Refer to Quantum Fabric Deployment Guide > Database Growth Sizing
  • Database Transaction log size: Allocate sufficient space for the Transaction log file based on all the transactions activity of all the Quantum Fabric components installed and as per your database backup policy. Because transaction log sizing is linked to database backup. If additional application logging/events are enabled in multiple components of Quantum Fabric, then you may need to consider additional size for the transaction log.
  • Temp Database and temp log: This is based on usage of all the databases on the server instance, by all applications connecting to these databases. In case of Quantum Fabric, for sizing of the temp database, consider auto growth with increment size should be of 100MB and with maximum size to 10GB. But if application logging/events are enabled in multiple components of Quantum Fabric, then the maximum size should be increased upto 20GB. This size will get reclaimed as and when the DB is restarted.
  • Database versions: You can use SQL Server Standard Edition or SQL Server Enterprise Edition database for installing Quantum Fabric. Quantum Fabric is compatible with these editions. There are no prerequisites specific to these editions as Quantum Fabric uses features common to both editions.
  • Backup plan: You must use your organization's defined backup and retention policies for Backup strategies for your database.