...
SQL Databases are Constantly Opening and Closing, filling up Event Viewer with Notifications
Often times Oftentimes GlobalSearch databases are set to utilize "Autoclose" which constantly open and close with each connectionwill close the SQL database when it is not in use. This can cause issues with performance both on the SQL side, and needlessly fill up your Event Viewer with verbose data, and in some cases, cause other system issues.
...
The following screenshot demonstrates these steps:
...
The following SQL script is equivalent to the above steps:
Be sure that you update the [SmartSearch]
to reflect the database you want to disable Auto Close on.
Code Block | ||
---|---|---|
| ||
USE [master]
GO
ALTER DATABASE [SmartSearch] SET AUTO_CLOSE OFF WITH NO_WAIT
GO |
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...