Memory tuning in SQL Server

License:

Applies to geodatabases created with an ArcGIS Server Enterprise license only

By default, SQL Server uses as much memory as it requires. On busy systems, SQL Server can force other applications, including ArcSDE, to page, compromising their response time and scalability. Consider limiting SQL Server's memory consumption by using a fixed memory size or setting a maximum memory size. To do this, right-click the server in Management Studio and click Properties. Click the Memory page and type an amount for the Maximum server memory.

You can also boost SharedSection in the registry. This setting controls the heap size for noninteractive desktop applications—the amount of memory available to spawn and support Windows services such as ArcSDE client connections. Adjust this setting if you anticipate having more than 50 concurrent ArcSDE connections. Locate this setting in the registry under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems under the Windows entry. This entry contains a string, contained in which is SharedSection=1024,3072,512. Increase the last entry to 1024. For more information on the noninteractive heap, see article 23953 on the ESRI support site.