未连接的连接 - 连接池调试SQL Server [英] Unclosed connection - Connection Pool debugging SQL Server

问题描述

我们有一个可疑应用程序使连接断开。只是想知道这个的调试工具，关于是否有任何人有任何好的工具隔离这，商业或其他。

We have a suspect application leaving a connection open. Just wondering on the debugging tools for this, as to whether anyone has any good tools for isolating this, commercial or otherwise.

我使用Google，但似乎只是提出描述问题的文章，而不是解决方案的步骤。

I've Googled but only seem to bring up articles that describe the problem - not the steps for a solution.

这是我见过的最好的文章到目前为止。 - 其他欢迎。

This is the best article I've seen so far. - Others welcome.

任何人有任何产品隔离有问题的代码？

Anyone have any products that isolate the problematic code? Profilers which perform this sort of thing, or any other advice to add?

推荐答案

您可以随时查看SQL Server上的活动监视器以查看应用程序是否保持连接打开。

You can always check the Activity Monitor on SQL Server to see if the application is keeping the connection open.

它在SQL Server Management Studio中的管理节点下。它将显示连接到数据库的任何应用程序的主机，应用程序，用户，打开的事务数量等。

It's under the Management node in SQL Server Management Studio. It will show you the host, application, user, number of open transactions, etc. for any applications that are connected to the database.

这篇关于未连接的连接 - 连接池调试SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！