Hi
For some reason, the system in my company have problems in processing production orders: the system freeze while doing this process, taking 30 minutes to end.
Aided with sql server, I found that the transaction had requested an unknown locking mode for each key in this tables ITT1(1618 rows!), CHEN and OWOR, i wonder if this is because the transaction was requesting a table lock.
We checked the network, the performance of the server and the clients, but we found not problem.
Could anyone help me?
Thanks