sql server runtime error on shutdown
October 24, 2005 02:04 PM
when enterprise manager is not responding, or when you request sql server to shutdown -- and the system kills the process causing a c++ runtime error...
the issue may be related memory paging.
when using a dynamic memory model, the OS may be in the middle of a paging operation when you request a shutdown. sql server will not respond during the paging operation, and the service will be terminated which causes the c++ runtime error.
in general the is not a problem, as during startup the server will recover (roll back uncommitted transactions).
the solution is to assign a *fixed* amount of memory for sql server, so the server never issues the memory paging operation.