BUG: DBCC SHRINKDATABASE Causes Memory Leak and Error 17803 When AUTO_SHRINK Is Set (289290)


The information in this article applies to:

  • Microsoft SQL Server 7.0
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.

REFERENCES

For additional information about DBCC MEMORYSTATUS, click the following article number to view the article in the Microsoft Knowledge Base:

271624 INF: Using DBCC MEMORYSTATUS to monitor SQL Server memory usage

Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbbug kbpending KB289290
©2004 Microsoft Corporation. All rights reserved.