No More Locks problem when I have 200,000

[Rob Doyle]

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

[Ray Miao]

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