sql server hangs with multi queries

[Eli Nurman]

Hi. I have a website (IIS) that clients make queries to the server which could take up to a minute to get the results. With that i have no problem. but when a different user(!) on IIS tries to query even a different table he will hang until the first user is responded. When i enter SSMS i can query and get immediate result. Does anyone have a solution for this? I must mention, that the SQL Connection in the website is not unique per request or per client, it is one connection for all requests, any chance that this is the reason for the wait? Thanks. Eli

[jschell]

Eli Nurman wrote:

any chance that this is the reason for the wait?

yes.

[Eli Nurman]

Hi, Thanks for you reply. So how can i solve this? Why are queries via SSMS not affected?

[jschell]

Eli Nurman wrote:

So how can i solve this

Use more than one connection.

Eli Nurman wrote:

Why are queries via SSMS not affected?

Because it is using a different connection.