I am maintaining a queue in a database table. An SSIS package checks the queue every two minutes. If it finds anything then it runs a job. I am experiencing some sort of table level locking.
The query that checks the queue is not a simple
SELECT statement; it has an
INNER JOIN too. How can I avoid the table level locking? Would it help to create a view from my query and then configure the SSIS package to check the view instead of querying the queue table inner joined with another table?
All suggestions are welcome.