I was sent a quite an interesting email stating that SQL Server would not shut down. Attempting to stop the service via services or the SQL Server Configuration Manager resulted in a timeout with SQL Server still running. Trying to execute the
shutdownwith and without
NOWAITT-SQL command resulted in the same, the process still running. Seems quite weird that SQL Server just refuses to shutdown!
Click through for Sean’s investigations, what the result was, and how the customer ultimately decided to deal with it.