Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Panel

bgColor	#fff

Open SQL Server Management Studio (SSMS)
Right click the database object in the object explorer and click "Properties"
Select the "Memory" page and set "Maximum server memory (in MB):" to your maximum desired usage
Hit "OK" and restart your SQL Server

The following screenshot demonstrates these steps:

Problem

SQL Databases are Constantly Opening and Closing, filling up Event Viewer with Notifications

...

Panel

bgColor	#fff

Open SQL Server Management Studio (SSMS)
Expand "Databases" in Object Explorer
For each of your production databases and GlobalSearch System databases, do the following:
1. Right click the database and click "Properties"
2. Open the "Options: page
3. Under the "Other Options" Section locate "Auto Close" under the "Automatic" Section (you may have to scroll upwards to find this section)
4. Set "Auto Close" to False
5. Hit "OK"

The following screenshot demonstrates these steps:

Related articles

Filter by label (Content by label)

showLabels	false
max	5
spaces	S9SKB
showSpace	false
sort	modified
reverse	true
type	page
cql	label = "sql" and type = "page" and space = "S9SKB"
labels	sql

...