In the SQL Server error log CHECKDB has been adding to the error log that DBCC CHECKDB finished without error for a specific database constantly since the last CHECKDB run.
Why does Foglight for SQL Server program run so many CHECKDB against the monitored instance?
The specified database was set with the autoclose value to "on". AutoClose shut downs the database after the last user process disconnects, then it automatically "reopens" the database when the next user connection attempts to connect. Whenever SQL Server starts a database the Checkdb is run to verify the consistency of the database.
The following query will display the autoclose settings for all of the databases in the instance.
SELECT
name, is_auto_close_on
FROM master.sys.databases
WHERE is_auto_close_on=1
If you find any databases set to allow AutoClose, simply run ALTER DB as follows (or you can make the change from within SSMS if you prefer):
ALTER DATABASE <dbname>
SET AUTO_CLOSE OFF
GO
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center