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
- Hi Olaf,
Thank you,
For some reason the auto close is set to true, the ERP vendor also puzzle why it set to true, their explanation it could be from way back when they use vb 6 to develop their ERP system and get carried over.
I set auto_close to false now for all database.
Thanks again.
Regards
- Haris -
