Starting up databases after SQL Service restart

Question

Hello,

I have a SQL instance which contains 74 databases.

So I had to restart the SQL Service about 1 hour and 15 minutes ago.
Ever since then the SQL log is flooded with these messages.

Starting up database 'DB1'
Starting up database 'DB1'
Starting up database 'DB2'
Starting up database 'DB3'
Starting up database 'DB1'
Starting up database 'DB1'
Starting up database 'DB2'
Starting up database 'DB3'

etc.....

I see multiple attempts and multiple SPIDs for 1 database.... Why is this happening?

Should the starting up of databases be quick and then the messages should stop flooding the log ?

Answer 1

Hi @Veena Srinivas ,

When I searched for such information, I found that some cases points to the AUTO_CLOSE option of the database, this option is set to True. Please check your database settings.
Also, if this is not the cause, please tell me the specific version of SQL Server so that I can try to reproduce your problem in a test environment to find the possible cause.

Best Regards,
Cris

Answer 2

Hi

SQL Server 2019 (15.x) introduces automatic recommendations for setting the MAXDOP server configuration option during the installation process based on the number of processors available. The setup user interface allows you to either accept the recommended settings or enter your own value. For more information, see Database Engine Configuration - MaxDOP page.
configure-the-max-degree-of-parallelism-server-configuration-option

Best Regards.

Please click the Mark as answer button and vote as helpful if this reply solves your problem.