INF: CHECKALLOC/NEWALLOC & CHECKPOINT/DUMP TRANS Serialized

Last reviewed: April 29, 1997
Article ID: Q115068

The information in this article applies to:

  - Microsoft SQL Server version 4.2 for OS/2
  - Microsoft SQL Server version 4.2

SUMMARY

If a CHECKPOINT or DUMP TRANSACTION (which performs a CHECKPOINT) is executed while CHECKALLOC or NEWALLOC is running in the same database, it will wait on the CHECKALLOC/NEWALLOC to finish before proceeding. This is expected behavior and is caused by the need to serialize CHECKPOINT and certain internal server operations performed by CHECKALLOC/NEWALLOC.

MORE INFORMATION

Since DUMP TRANSACTION/CHECKPOINT is waiting on an internal flag and not on a lock, the stored procedures sp_who and sp_lock will not provide any indication of this behavior. Therefore, if DUMP TRANSACTION or a CHECKPOINT appears to be taking longer than usual, make sure there is no concurrent CHECKALLOC or NEWALLOC in progress. This behavior should have little operational impact. This is because to eliminate spurious errors it is always advisable to run CHECKALLOC or NEWALLOC while there is no activity in the database.


Additional query words: Windows NT
Keywords : kbprg SSrvServer SSrvWinNT
Version : 4.2 | 4.2
Platform : OS/2 WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.