Most likely you've a blocking problem. See mskb #
224453 for details.
>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.
>
--sb--