\u4eca\u5929\u5728 troubleshooting \u5ba2\u6236\u4e3b\u6a5f\u4e0a\u554f\u984c\u7684\u6642\u5019\uff0c\u4e0d\u7d93\u610f\u5f9e Tcpview \u767c\u73fe\u67d0\u500b\u7cfb\u7d71\u5728\u4f7f\u7528\u8005\u4f7f\u7528\u7684\u6642\u5019\u6703\u5c0d SQL Server \u7522\u751f\u5927\u91cf TIME_WAIT session\uff0c\u9019\u5c0d\u65bc\u81ea\u6211\u8981\u6c42\u7684\u7cfb\u7d71\u958b\u767c\u8005\u4f86\u8aaa\uff0c\u662f\u500b\u4e0d\u80fd\u8996\u800c\u4e0d\u898b\u7684\u7455\u75b5\uff0c\u65bc\u662f\u958b\u59cb\u9032\u884c debug...<\/p>\n
\u7d93\u904e\u5169\u500b\u5c0f\u6642\u5206\u6790\u5f8c\uff0c\u767c\u73fe\u4e86\u4e00\u500b\u72c0\u6cc1\uff08\u5148\u770b\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\uff09\uff1a<\/p>\n
\r\n'\/\/ \u9810\u8a2d Conn \u5df2\u7d93\u5efa\u7acb\r\n\r\n'\/\/ \u7b2c\u4e00\u500b adCmdStoreProc\r\nDim rs1 : Set rs1 = Server.CreateObject("ADODB.Recordset")\r\nDim cmd1 : Set cmd1 = Server.CreateObject("ADODB.Command")\r\n\r\ncmd1.ActiveConnection = Conn\r\ncmd1.CommandText = "usp_SPNAME1"\r\ncmd1.CommandType = adCmdStoredProc\r\ncmd1.Parameters.Refresh\r\n\r\ncmd1.Parameters("@Param1").Value = 1\r\n\r\nSet rs1 = cmd1.Execute\r\n\r\n'\/\/ \u7b2c\u4e8c\u500b adCmdStoreProc\r\nDim rs2 : Set rs2 = Server.CreateObject("ADODB.Recordset")\r\nDim cmd2 : Set cmd2 = Server.CreateObject("ADODB.Command")\r\n\r\ncmd2.ActiveConnection = Conn\r\ncmd2.CommandText = "usp_SPNAME2"\r\ncmd2.CommandType = adCmdStoredProc\r\ncmd2.Parameters.Refresh\r\n\r\ncmd2.Parameters("@Param2").Value = 2\r\n\r\nDo While NOT rs1.EOF\r\n\r\n\tcmd2.Execute\r\n\r\n\trs1.MoveNext\r\nLoop\r\n<\/pre>\n\u9019\u662f\u4e00\u500b loop \u4f46\u662f\u70ba\u5de2\u72c0\u67e5\u8a62\uff0c\u4f9d\u64da rs1 \u53d6\u5f97\u7684 recordset \u57f7\u884c cmd2 \u7684\u67e5\u8a62\uff0c\u4ee5\u4e0a\u7a0b\u5f0f\u78bc\u770b\u8d77\u4f86\u6c92\u6709\u554f\u984c\uff0c\u57f7\u884c\u8d77\u4f86\u4e5f\u4e0d\u6703\u767c\u751f\u932f\u8aa4\uff0c\u4f46\u662f\u6703\u7522\u751f\u7b49\u540c\u65bc recordset count \u6578\u91cf\u7684 TCP TIME_WAIT session\uff0c\u95dc\u9375\u5728\u65bc Conn (Connection) \u88ab\u62ff\u4f86\u7528\u4e86\u5169\u6b21 (cmd1.ActiveConnection & cmd2.ActiveConnection)<\/strong>\uff0c\u5373\u4fbf\u5728\u7b2c\u4e8c\u6b21\u8a2d\u5b9a\u7d66 cmd2\u524d Set cmd1 = Nothing \u4e5f\u6c92\u7528\uff0c\u4e00\u6a23\u6703\u9020\u6210 cmd2 \u5728\u4f5c\u52d5\u6642\u7522\u751f TIME_WAIT\u00a0 \u3002 (CommandType = adCmdStoredProc \u6642\u5728\u8a2d\u5b9aParameters \u503c\u7684\u6642\u5019\u5c31\u6703\u7522\u751f TIME_WAIT\uff0cCommandType = adCmdText \u6642\u5728 Execute \u6642\u6703\u7522\u751f TIME_WAIT)<\/p>\n\u800c\u9019\u500b issue \u7684\u89e3\u6c7a\u8fa6\u6cd5\u662f\uff1a<\/p>\n
\u6bcf\u500b ActiveConnection \u90fd\u7d66\u4ed6\u4e00\u500b\u7368\u7acb\u7684 Connection object<\/p>\n
\u5ef6\u4f38\u95b1\u8b80\uff1a<\/p>\n
Nested RecordSet and the port\/socket in TIME_WAIT problem by example.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\u4eca\u5929\u5728 troubleshooting \u5ba2\u6236\u4e3b\u6a5f\u4e0a\u554f\u984c\u7684\u6642\u5019\uff0c\u4e0d\u7d93\u610f\u5f9e Tcpv … \u95b1\u8b80\u5168\u6587