There is batch job locking exclusively on the table .There are querygrid jobs trying to access the same and table and they get blocked for many hours .
Can anyone suggest how to avoid this situation .
Solved! Go to Solution.
Why does the batch job need an exclusive lock? Perhaps dropping and re-creating secondary or join indexes, or doing ALTER of some sort?
You may need to consider changing the table/index structure and/or the maintenance approach so that exclusive locks will not be required.