I met a troublesome problem,
Now the front end of the I use Delphi back-end json data obtained through HTTP, the backend is asp, database MSSQL,
Problem is: about 4 to 5 days, the client will not be able to connect MSSQL computer (this computer to use as a server, IIS), need to restart the MSSQL computer after the client to connect to the database properly,
Analysis: when the client can't connect MSSQL, find MSSQL this computer mouse can move, but can't open the folder, can't do any operation, all can only move, such as display does not have enough resources to open the file, after the restart, the client can direct connection and use, by looking at the resource manager, found that handle several kept rising, down a few days can reach millions and tens of millions of... Handle,
Thought is the back-end asp file, there is no set caused by rs=noting this, but after all added, still not solve the problem,
Excuse me each master, what is causing this handle number increasing? How to solve? Thank you very much!
CodePudding user response:
System in the process of the further found that handle number increase,CodePudding user response:
One, as you describe are too briefSecond, the key code is not listed, calls the format did not say
Three, since the process continuously increase, and that is the server background did not think the end of the program,
May the following problems: A, code has A problem; B. there is something wrong with the database system; C. there is something wrong with the operating system