jeudi 4 décembre 2014

60 minutes to shut down sql server service?


We recently merged with a new company and they have a server that has 265 DBs on it (6.6tb of mdfs). Shortly after we merged the other DBA said it takes 60 minutes to shut down the services which I thought was incredibly high. Last night they stopped and started the services and sure enough it took 60 minutes. I looked at the log this morning and found the following error messages in the sql log file while it was in the process of trying to stop the service. I know SQL takes a longer time to start back up if you have a lot of VLFs, but it only took 1 minute from the time it started up until the Recovery Complete message appeared in the log. Any idea if 60 mins is normal? Or if not, what can I do to investigate speeding this up. Thanks! Error: 17142, Severity: 14, State: 0. SQL Server service has been paused. No new connections will be allowed. To resume the service, use SQL Computer Manager or the Services application in Control Panel.


Error: 18456, Severity: 14, State: 13. Login failed for user ''. Reason: SQL Server service is paused. No new connections can be accepted at this time. [CLIENT: xx.xxx.xx.xx]





Aucun commentaire:

Enregistrer un commentaire