This procedure explains how to configure the server to avoid running out of memory.
-
By default, the server is configured to use unlimited memory.
-
As a quick alternative to this procedure, you can stop and then restart the server.
-
To implement this procedure, you must have DBA permissions.
-
Select Start > Programs > Microsoft SQL Server > SQL Server Management Studio.
-
On the Connect to Server dialog, beside Server type, select Database Engine.
-
Beside Server name, select the name of your server or instance.
-
Beside Authentication, select SQL Server Authentication.
-
Type a login name.
-
Type a strong password of at least 6 characters; this is a password that must include upper- and lower-case characters, numeric and non-alphanumeric characters. Passwords are case-sensitive.
-
Select Connect.
-
In the Microsoft SQL Server Management Studio window, under the Object Explorer, select the server (top-level node), right-click, and on the shortcut menu, select Properties.
If it is likely that a large number of users will connect to the database concurrently,
select the Memory page and under Maximum server memory (in MB), set a higher value to avoid poor performance.
-
Select the Database Settings page and change the value of Default index fill factor to 80.
