Maintenance Manual

Managing and Maintaining Servers 69
 In order to ensure that select queries from the application execute optimally, and with the least possibility of
encountering SQL deadlocks with other modification queries, it is required that the Read commit snapshot
property is enabled for the Active database. To enable this property:
a. Ensure that ECE is stopped completely. All distributed components such as the services server, all
application servers and messaging server should be stopped. For these commands to succeed, there
must not be any database connections to the
ActiveDB .
b. Verify the current value of the Read commit snapshot property for the Active database by running the
following select query:
select name,snapshot_isolation_state_desc,is_read_committed_snapshot_on from
sys.databases
c. If the Read commit snapshot property is disabled, run the following query to enable it:
alter database Active_Database_Name set single_user with rollback immediate;
alter database
Active_Database_Name set read_committed_snapshot on;
alter database
Active_Database_Name set multi_user;
d. Verify that the Read commit snapshot property has been enabled successfully by running the
following query.
select name,snapshot_isolation_state_desc,is_read_committed_snapshot_on from
sys.databases
Temp Database
 Set the temp database properties as follows:
 Data file size should be set to 1.5 GB. Autogrowth should be set to 1 GB.
 Transaction log file size should be set to 1 GB. Autogrowth should be set to 1 GB.
 Number of data files for temp database should be 4 (it is same as number of cores on the VM but not
exceeding 8). All files should be around same size with autogrowth on.
Master Database
 Set the master database properties as follows:
 Data file size should be set to minimum 50 MB. Autogrowth should be set to 50 MB.
 Transaction log file size should be set to 50 MB. Autogrowth should be set to 50 MB.
Active Database
 While installing the application, ensure that data and log files of the active database reside on a disk volume
with a good amount of free disk space. To calculate the required free disk space, see the Enterprise Chat and
Email Design Guide.
 Set the active database properties as follows:
 Data file size should be set to 20 GB. Autogrowth should be set to 1 GB.
 Transaction log file size should be set to 2 GB. Autogrowth should be set to 1 GB.