The event viewer may show Event IDs 2803 and 17137 regarding the DAConfiguration/DAReporting databases several times a day.
Event ID 17137 Source: MSSQL$DESKTOPAUTHORITY Starting up database 'DAConfiguration or DAReporting'.
Event ID 2803 Source: MSSQL$DESKTOPAUTHORITY SQL Server has encountered xx occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
These entries will appear if the Desktop Authority database(s) have the AUTO CLOSE option set to TRUE. When Auto Close is on for a database, SQL closes the database when the last connection closes. This forces a cache flush. The next time the database is accessed, it's reopened, causing the 'starting up database' message. Multiple 2803 and 17137 entries in the Application Event log show the server constantly opening and closing the database which can slow performance of the system.
Follow the steps below to disable auto-close on the Desktop Authority database(s):
1. Open SQL Management Studio and connect to the instance where the databases are stored
2. Expand DATABASES
3. Right-click on DAConfiguration and select PROPERTIES
4. Select OPTIONS from the left pane
5. Change the value of AUTO CLOSE to FALSE
6. Restart the SQL services and monitor
NOTE: Perform the same steps above if the DAReporting or other databases are listed in the event viewer.
