Database Lock

[anvardheen_jabarullah]

Hi All,

In Our Prod system We are facing database lock issue frequently while executing background jobs.One active job is blocking another one. How to avoid this issue normally?

[former_member188883]

Hi Dheen,

In DB01 please check which transaction or program is generation database lock. You may need to analyse the program .

Hope this helps.

Regards,

Deepak Kori

[former_member206552]

Hi Dheen

As most of our jobs run A class we had to change some of the job scheduling to avoid this.

please also review the following

Note 806342 - FAQ: Analyzing exclusive database locks on SQL Server

Best Regards

Marius

[Former Member]

Hi Dheen,

Can you check how many A and C Job available in your system and how about the servers one servers or two servers ? What is the average frequecy of each Job ?

Thanks

Simbhu