Forum Discussion
Solved
how to identify what started checkdb
Hi, A few days ago, ERP user complaining that it run slow, so I check the server and found on the event viewer it seems checkdb is run about every 10 minutes for the last several days. on the pr...
03/05/2021 14:54:04,spid70,Unknown,Starting up database 'M1_AH'.Your databases are set to "Auto close"? Not good in terms of performance.
Use SQL Server Profiler to trace the commands/accesses or setup Audit
Create a server audit and database audit specification
Olaf
03/05/2021 14:54:04,spid70,Unknown,Starting up database 'M1_AH'.
Your databases are set to "Auto close"? Not good in terms of performance.
Use SQL Server Profiler to trace the commands/accesses or setup Audit
Create a server audit and database audit specification
Olaf