Checking connections under Management -> Process Info

[iaswnidou]

Hello

I have an ASP.NET application that will soon go live in our environment.

When I open the SQL Server Enterprise Manager, under Management -> Current Activity -> Process Info
I see 2-6 connections with the UserID that is used in my applications web.config file.

At the moment I see 3 connections with status "sleeping" and command equal to "awaiting command".

Is this normal? Should I do any further checks?

Thanks

 

[ptheriault]

Yes,
This is normal. It means that a connection has been established but it is not currently processing any commands.

- Paul

- If at first you don't succeed, find out if the loser gets anything.