We're experiencing network issues with connections to our SQL box unexpectedly being closed. These are occurring a few times a day. Errors are being logged by the SharePoint WFEs but users haven't reported any problems yet.
This is not a fault in SharePoint but rather the machine hardware or VMWare. It's being looked into by the infrastructure team who might find a solution (one day)...
Ignoring the specifics of this particular problem:
How does SharePoint in general handle unreliable database connectivity?
Does it retry transactions? At what point does it give up? Can it cause data consistency problems?
Update 8 Dec: Clarified question and added bounty.