Kbase P117368: Is it possible to automatically reconnect the SQL users when the SQL server they are connected to di
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/18/2006 |
|
Status: Unverified
GOAL:
Is it possible to automatically reconnect the SQL users when the SQL server they are connected to dies
GOAL:
Is there a way of having the clients know what server they were connected to and then re-establish the connection automatically when the SQL server process they were connected to died.
FIX:
There is no way to reconnect automatically SQL users when the SQL server (_sqlsrv2 process) they were connected to dies.
One way to limit the number of users affected by a SQL server process dying is to specify only one user per SQL server (-Ma). Thus, when a user generates a crash of the SQL server, such as a memory violation, he will be the only one disconnected.
However, since there is one SQL server per SQL user, the drawback is that the number of SQL server processes spawned can be high if there are many SQL users. Therefore, it consumes more resources on the machine.