Maqsood Ahmad: A sleeping connection at most cosumes a couple of KB of memory (totally neglible). If your application is not restarted then the connections will linger and save you on future connection costs (connection setups are quite expensive but leaving them open/sleeping is very very cheap).

I.e. sleeping connections are not a problem in SQL Server.

Regards,

Hanslindgren