Lock Error

[patelaashish]

Hi,

I get the following error when I try to run an update statement which updates around 200000 rows:

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.


Can someone please help me on this.

Thanks.

[siva538]

Hi,

I get the following error when I try to run an update statement which updates around 200000 rows:

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.


Can someone please help me on this.

Thanks.

This looks like another transaction is also updating the same tables or probably same result set ...

run sp_who2 in sql query analyser to identify which other transactions are running at the same time ..

you can also identify the opetransactions with

 dbcc opentran

Alternatively you can run the sql profiler to check what are the other processes running on the server ...


HTH...

[Motoma]

Thanks for the information siva538.