I am using Service broker to execute a stored procedure. In the stored procedure 3 tables are frequently used to insert/update and delete. The problem I am facing is when I use service broker to run the procedure there are too many locks on these tables.
Has anyone faced a similar issue ? How should I go about troubleshooting it ?
Sanz