Increasing Services performance for Mailsite SQL Connector
Document ID: 10184
Synopsis
How to increasing the performance of the MailSite Services. This applies only to MailSite SP-C installations that use the SQL Connector. For customers running MailSite in Registry mode, se
More Information
Increasing Services performance for Mailsite SQL Connector
How to increasing the performance of the MailSite Services. This applies only to MailSite SP-C installations that use the SQL Connector. For customers running MailSite in Registry mode, see KB 10157
For a full explanation of what these parameters are provided in Document 10157.
In order to increase SMTPRA performance, follow the steps below:
WARNING!!
Incorrectly editing the Database can damage the server, please be sure you know what you are doing.
- Open MS SQL Server Manager
- Open the Tree from Microsoft SQL Servers\SQL Servers Group\ Local\Databases\MailSite\Tables
- Right Click on 'MailServerProperties' in the left pane and select 'Open Table' then 'Return All rows'.
- At the very bottom of the returned results put these entries into the fields that are represented in the first row -
|
ServiceName |
PropertyName |
PropType |
PropIntValue |
PropStringValue |
|
SMTPRA |
NoKeepalives |
4 |
1 |
|
|
SMTPRA |
WorkerThreads |
4 |
20 |
|
|
SMTPRA |
MaxWorkerThreads |
4 |
80 |
|
- For all the other services perform the same entries but replace the ServiceName with the service that you want to increase the performance of.