Deleting Computers Fails With Out Of Locks Errors

Last reviewed: September 22, 1997
Article ID: Q153368

The information in this article applies to:
  • Microsoft Systems Management Server versions 1.0, 1.1 and 1.2

SYMPTOMS

Deleting a large number of computers from the SMS Administrator fails with "out of locks" errors. No computers are deleted, and the following error is displayed in a popup:

   Couldn't delete all the items.

   Error attempting to delete the requested items. Items have been removed
   from the query result list but not necessarily from the database.
   Refresh the data to ensure the result is correct.

The following error is displayed in the SQL messages window:

   >>Msg>> SQL Server has run out of LOCKS. Re-run your command when there
   are fewer active users, or ask your System Administrator reconfigure SQL
    Server with more LOCKS.
   >>Msg>> The rollback transaction request has no corresponding BEGIN
   TRANSACTION.

CAUSE

All the computers in the query window get locked during a delete. Each lock uses 32 bytes, which at 10,000 locks will use up 320,000 bytes, which are then unavailable for caching the database.

WORKAROUND

The workaround for this problem with SMS 1.1 is adding more locks in SQL Server. If there is a one-time delete of a large number of computers, locks can be increased for the delete and reduced later.

STATUS

Microsoft has confirmed this to be a problem in Systems Management Server version 1.0 and 1.1. This problem has been improved with Systems Management Server version 1.2.


Additional query words: prodsms
Keywords : smsadmin smsconfig smsdatabase smsgeneral kbfixlist
Version : 1.0 1.1 1.2
Platform : 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: September 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.