The information in this article applies to:
SUMMARYIf 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 |
Last Reviewed: March 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |