Hi,
I have one machine is accessing MS SQL Server, it submits a SQL statememnt which JOIN 3 tables which may take about 5-10 mins to return resultset.

When this query is running, I found that any query submitted to SQL Server after that from others machines will be blocked. The app will be like "hang", and only continue if the previous process is finished.

Any ideas? It only happen to big tables joining.

Thank you