Just the same by not having the minimum memory setting set on a server that is shared with an application server or has multiple instances of SQL Server install, SQL Server could be starved of needed memory You can view your Minimum server memory and Maximum server memory in Server Properties or by querying sysconfigurations If your SQL Server is not configured with enough RAM, then the older cache will be removed, and new active data will be kept in the buffer memory Each edition and version of SQL server has different criteria for the Memory Allocation (RAM) SQL Server allows configuring the memory by a server property Step 1 Connect to your SQL Server instance in SQL Server Management Studio Right click on your connected SQL Server instance and choose Properties as per the screen shot below Step 2 Click on the Memory page in the left pane Your memory property page will appear like the screenshot below Here you can see our "Index creation memory" option
Little Sql Server Tricks Fix Strange Problems By Reducing The Available Memory Improve Repeat
