本文介绍了什么可能导致左开SQL数据连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您只是想知道什么可能导致左开SQL连接,因为它在上周只发生了2次。它创建的错误是当Web应用程序尝试打开连接时出现错误消息,它已经打开。然后杀死该过程以关闭连接。大约15个工作站的使用率非常低。看代码看起来所有连接都被关闭了,所以认为它不是代码的问题。谢谢Paul。

Hi just wondering what could cause a left open SQL connection as this has only occured 2 times in the last week. The error it creates is when a web app tries to open a connection an error message states, it is already open. The process was then killed to close the connection. The usage is pretty low around 15 workstations. Looking at the code it appears that all connections get closed, so thinking it is not a problem with the code. Thanks Paul.

推荐答案



仅在上周发生了2次。它创建的错误是当一个web

应用程序尝试打开连接时出现错误消息,它已经打开。

然后该进程被终止以关闭连接。大约15个工作站的使用率非常低。看一下代码,看来所有的

连接都关闭了,所以认为这不是代码的问题。

谢谢保罗。


only occured 2 times in the last week. The error it creates is when a web
app tries to open a connection an error message states, it is already open.
The process was then killed to close the connection. The usage is pretty
low around 15 workstations. Looking at the code it appears that all
connections get closed, so thinking it is not a problem with the code.
Thanks Paul.




仅在上周发生了2次。它创建的错误是当一个web

应用程序尝试打开连接时出现错误消息,它已经打开。

然后该进程被终止以关闭连接。大约15个工作站的使用率非常低。看一下代码,看来所有的

连接都关闭了,所以认为这不是代码的问题。

谢谢保罗。


only occured 2 times in the last week. The error it creates is when a web
app tries to open a connection an error message states, it is already open.
The process was then killed to close the connection. The usage is pretty
low around 15 workstations. Looking at the code it appears that all
connections get closed, so thinking it is not a problem with the code.
Thanks Paul.




仅在上周发生了2次。它创建的错误是当一个web

应用程序尝试打开连接时出现错误消息,它已经打开。

然后该进程被终止以关闭连接。大约15个工作站的使用率非常低。看一下代码,看来所有的

连接都关闭了,所以认为这不是代码的问题。

谢谢保罗。


only occured 2 times in the last week. The error it creates is when a web
app tries to open a connection an error message states, it is already open.
The process was then killed to close the connection. The usage is pretty
low around 15 workstations. Looking at the code it appears that all
connections get closed, so thinking it is not a problem with the code.
Thanks Paul.


这篇关于什么可能导致左开SQL数据连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-05 16:05