Maintenance Manual

68 Enterprise Chat and Email Deployment and Maintenance Guide
This chapter will assist you in understanding how to configure and maintain the ECE servers.
Best Practices for Configuring Servers
For All Servers
This section describes the best practices for configuring all the ECE servers. For database server, there are some
additional best practices that are listed in the section “Additional Best Practices for Database Servers” on
page 68.
Configuring Anti-virus Protection
 To ensure that virus and malware scanning software on the servers do not interfere with the performance of
the application, certain folders and files must be excluded from continuous virus scanning. Since no files are
downloaded to these locations from the internet, it is safe to exclude these directories from virus scanning.
For details about doing this task, see the “Post-Installation Tasks” chapter in the Enterprise Chat and Email
Installation Guide.
Additional Best Practices for Database Servers
In addition to the best practices that apply to all the ECE servers, there are some special best practices for the
database server that are described in this section.
Installation and Settings
 Check the values set for fill factor and max degree of parallelism . To reduce I/O (disk input
output) on SQL server, the fill factor should be set to 80%. This ensures that 20% free space is available in
the data pages of indexes, and it reduces page splitting. The max degree of parallelism should be set to the
number of physical processors. For example, if there are two processors, set
max degree of
parallelism to 2; and if there are five processors, set max degree of parallelism to 5.
a. On the database server, run the following stored procedure.
EXEC sp_configure 'show advanced option', '1'
Reconfigure
exec sp_configure
b. If the fill factor and max degree of parallelism is not configured correctly, run the following stored
procedure on the database.
exec sp_configure 'fill factor (%)', 80
exec sp_configure 'max degree of parallelism',
Number_Of_Physical_Processors
reconfigure with override