Microsoft KB Archive/289290

= BUG: DBCC SHRINKDATABASE Causes Memory Leak and Error 17803 When AUTO_SHRINK Is Set =

Article ID: 289290

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q289290



BUG #: 101279(SQLBUG_70)



SYMPTOMS
When databases have AUTO_SHRINK enabled, a memory leak may occur in Sqlservr.exe. SQL Server may become slow and eventually unresponsive. The following errors may appear in the errorlog:

Error: 802, Severity: 17, State: 1

No more buffers can be stolen.

Error: 17803, Severity: 17, State: 17

Insufficient memory available..



CAUSE
There is a memory leak in the DBCC SHRINKDATABASE function, and setting AUTO_SHRINK to ON runs DBCC SHRINKDATABASE periodically.



WORKAROUND
Set AUTO_SHRINK to OFF.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

