Database Connection not getting reset after a application timesout

grajee 341 Reputation points
2020-12-03T01:59:45.51+00:00

All,

We have an application that points to our SQLServer 2016 database. Changes were made to the front-end application and since then we are seeing intermittent timeouts.

The application seems to be timing out since the SP called does not complete on time due to CXCONSUMER waittype. While we are addressing the parallelism issue as indicated by CXCONSUMER we dont know why the database connection is not getting reset. Normally, the connection timeout would show up in the Attention alert of Profiler but it is not showing up either.

Another issue is that killing the database connection itself does not address the problem. The SP needs to be recompiled before a new connection can be successfully established.

Has anyone come across similar issue before?

Thanks,
grajee

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
{count} votes