未关闭的连接 - 连接池调试 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 上的 Activity Monitor 以查看应用程序是否保持连接打开.

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屋！