SQL Server Memory Configuration

If you are using a single-tier configuration (App Control Server and SQL Server on the same system), you should configure the SQL Server to use shared memory for the connection to gain the maximum performance benefit of the single-tier archictecture.

Use of TCP introduces unnecessary latency into the system.

Follow these configuration guidelines to make the SQL Server use shared memory for its connection to the App Control Server when they are on the same machine:

• Do not use a FQDN to specify the SQL Server name – it causes the server to use TCP for the connection. To make the SQL Server connection use shared memory instead, use a local server name.
• Make sure that Shared Memory protocols are enabled for both network and client configuration in the SQL Configuration Manager.