Jayant Tripathy

Jayant Tripathy

  • 711
  • 1.1k
  • 274.8k

Database connection sleep awaiting command | open Connection

Sep 19 2019 9:01 AM
 I have a MVC application with high end user running with Web API and ADO .NET as ORM. From past some days I face DB open connection issue and the connection is reach out about 10k and not relase.
 
I checked also my ADO .NET SQL Helper the conncetion is closed on every request and the conncection pooling is set as false as well. 
 
When I search about the issue found SQL Server Mysteries: The Case of the Suspended, Awaiting Command, and Blocked Session in the below link.
 
 https://blogs.msdn.microsoft.com/bobsql/2017/06/09/sql-server-mysteries-the-case-of-the-suspended-awaiting-command-and-blocked-session/
 
 
Someone havae any idea to get rid of this issue it will help me a lot. Thanks !
 
The below are the DB opened connections 
 
SPID Status BlkBy Command CPUTime DiskIO LastBatch ProgramName SPID REQUESTID
720 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:56 .Net SqlClient Data Provider 720 0
721 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:56 .Net SqlClient Data Provider 721 0
722 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:56 .Net SqlClient Data Provider 722 0
723 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:56 .Net SqlClient Data Provider 723 0
724 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:56 .Net SqlClient Data Provider 724 0
725 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:57 .Net SqlClient Data Provider 725 0
729 sleeping . AWAITING COMMAND 15 0 9/19/2019 16:57 .Net SqlClient Data Provider 729 0
731 sleeping . AWAITING COMMAND 0 0 9/19/2019 16:57 .Net SqlClient Data Provider 731 0
697 sleeping . AWAITING COMMAND 15 0 9/19/2019 16:56 .Net SqlClient Data Provider 697 0
 
 
 

Answers (1)