Everybody is good, I was developed by using PB 9 + SQL server 2000, is to use the ODBC database, now there is a problem is that all the client can be run normally, but sometimes all of a sudden a client program like crashed in a wait state, great for a little while to normal, I think it is data take up the question, please me how to solve this problem, from which aspects! Thank you,

CodePudding user response:

1. Check whether the resulting from the client issues a deadlock (virus or other programs regularly perform CPU resources);
2. Check whether because the database deadlock caused (on the database server SQL execution status tracking);
3. Suit the remedy to the case to solve the problem;

CodePudding user response:

But sometimes all of a sudden a client program like crashed in a wait state, great for a while to normal
Database lock the possibility of more
Lz, you are in customer reflect slower, look up in the database lock, look have corresponding table, fields, and so on resource usage

CodePudding user response:

I also want to know, is looking for this information ~ ~ ~ ~ ~