-
No More Locks problem when I have 200,000
We are trying to add a about 100,000 transactions to a table with one non-clustered index and 31 million rows in one transaction. We have 200,000 locks and 64 meg ram for SQL Server. We get a No More locks error.
When we try to insert this 100,000 transactions into a table with no rows in it. It works fine using about 7934 locks.
How can this be ? what are we doing wrong.?
Thanks for any help in advance.
Rob Doyle
-
No More Locks problem when I have 200,000 (reply)
It's possible with large table, you should increase lock again. By the way, you need more than 64mg ram because of your db size.
------------
Rob Doyle at 7/19/00 10:09:30 AM
We are trying to add a about 100,000 transactions to a table with one non-clustered index and 31 million rows in one transaction. We have 200,000 locks and 64 meg ram for SQL Server. We get a No More locks error.
When we try to insert this 100,000 transactions into a table with no rows in it. It works fine using about 7934 locks.
How can this be ? what are we doing wrong.?
Thanks for any help in advance.
Rob Doyle
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|