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 |