MSSQL5 - SQL Restart

Yes that is the error it will give, someone was abusing the services utilizing 100% for over 5 minutes, I had killed the process but SQL was still using far too many resources hurting everyone. I am keeping an eye on the user.
 
Can you let us know when it is back up, still cannot connect.


Edit - Seems fine now. Thanks for keeping an eye on things!
 
Yes, it is working perfectly.

BTW, what happens is SQL Server comes back on, then moves each DB into an "online" state, until it is moved online, it will say login failed.
 
Thanks Stephen. Curious how SQL can allow one process to use all resources... doesn't it share cpu time around no matter what each client process is doing?
 
Yes, and it has a query governor, but they had multiple logins processing requests, I believe it was a one time thing though, as it has not happened again.
 
You must log in or register to reply here.
Back
Top