How to handle lost connection or server restart?

Hi,

Do you have any guidance for reacting to a lost connection with the server or restarting the sql server instance?
In my experience, it fails silently, without any feedback, which makes it very difficult to debug disconnection problems.

Regards,
Pedro santos