Topic: The session identifier locks itself
Good afternoon, respected !
The trouble came - did not note and as.
Essence in the following:
I have my basis in which many my stored procedures.
One of them address, both to bases on the same server, and to to the server. Thus on the current server the request on all bases becomes quickly enough (3 minutes approximately).
All trouble begins, when he addresses to to the server.
On it it comes under specially created , with all rights.
Till today's Monday all worked for me and collected. Approximately 30 minutes
And now the following began - waited for 5 hours.
Came on the second server and opened the activity monitor. In processes formed a heap of identical processes.
The part from them with state Raning, part Ranable, and is a lot of Suspended. (In the enclosed file a screen)
Thus the last are locked with the same identifier.
CPU time does a saltus and permanently supports great value.
In expectation of resources Buffer I/O a maximum.
Anything in adjustments of the server did not change.
Anybody too does not confess.
From noted changes:
1. Someone delivered Kaspersky the server 10 console (deleted, changed nothing);
2. For some reason in adjustments servers changed under what to come on it (too nobody confesses that made something)
Prompt where to dig please concerning an error...