What procedures do I need to follow to optimize my MS SQL server for use with AeriesCS?
You should perform these modifications on your MS SQL server to maximize performance for AeriesCS. If you have implemented ABI on another server other than the SQL server, these modifications should be performed on the ABI server as well. Note: Modifications to a server and registry should only be handled by a System Administrator or Technician that is proficient with server maintenance and registry modifications. • Install all operating system (O/S) service packs and patches that are available from the Microsoft Updates website. • Make sure that your MS SQL Server has been updated with the latest service pack. There have been issues with both Standard and Enterprise versions of MS SQL Server when the latest service pack has not been applied. • Insert the following registry entries on the MS SQL server. The registry entries shown below have helped to make timeout or dropped connection errors stop on a MS SQL server: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
