There are a couple of issues that can occur within SQL that may cause some server-side performance, which can create performance issues within GlobalSearch.
...
Panel |
---|
|
- 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:
Image Added
Problem
SQL Databases are Constantly Opening and Closing, filling up Event Viewer with Notifications
...
Panel |
---|
|
- Open SQL Server Management Studio (SSMS)
- Expand "Databases" in Object Explorer
- For each of your production databases and GlobalSearch System databases, do the following:
- Right click the database and click "Properties"
- Open the "Options: page
- Under the "Other Options" Section locate "Auto Close" under the "Automatic" Section (you may have to scroll upwards to find this section)
- Set "Auto Close" to False
- Hit "OK"
|
The following screenshot demonstrates these steps:
Image Added
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 |
---|
|
...