我可以说这是连接泄漏吗？
Web 服务器环境：Windows 2008 R2
数据库服务器环境：SQL Server 2008
背景：我想使用 sql profiler 来跟踪哪个连接导致连接泄漏。
我使用的 SQL Server Profiler 事件：
- 审核登录（列：EventSubClass、EventClass、EventSequence、SPID）
- 审核注销（列：EventSubClass、EventClass、EventSequence、SPID）
- PRC:Complete（列：TextData、EventSequence、SPID）
我发现了一个奇怪的日志记录记录，我猜测是连接泄漏，但不太确定，记录是：
SPID 65,
When Audit Login, EventSubClass is 2-pooled (meaning it is pooled connection) and EventSequence is 69354
When Audit Logout, EventSubClass is 1-non pooled (meaning it is non-pooled connection) and EventSequence is 69848 (from 69354 to 69848 meaning there are some other event logs)
Can I say that this connection isleaking?
先感谢您。
Web Server Environment : Windows 2008 R2
Database Server Environment : SQL Server 2008
Background : I want to use sql profiler to trace which connection cause connection leak.
SQL server Profiler events I used:
- Audit Login (columns : EventSubClass, EventClass, EventSequence, SPID)
- Audit Logout (columns : EventSubClass, EventClass, EventSequence, SPID)
- PRC:Complete (columns : TextData, EventSequence, SPID)
I found a weird logged record, I guess it is connection leak, but not very sure, the records are:
SPID 65,
When Audit Login, EventSubClass is 2-pooled (meaning it is pooled connection) and EventSequence is 69354
When Audit Logout, EventSubClass is 1-non pooled (meaning it is non-pooled connection) and EventSequence is 69848 (from 69354 to 69848 meaning there are some other event logs)
Can I say that this connection is leaking?
Thank you in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
池连接是在应用程序和数据库之间管理的连接。这意味着当您关闭连接时，中间管理器会收回连接，但保持其与数据库的打开状态。这意味着当您请求新连接时，可以比从头开始创建新连接更快、更高效。
A pooled connection is one that is being managed between your application and the database. It means when you close your connection, the intermediate manager takes the connection back, but keeps it open with the database. This means that when you request a new connection, it can be provided much more quickly and efficiently than creating a new one from scratch.