SQL disconnections are expected in a SaaS environment, as indicated in the following doc:
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/sysadmin/retryable-batch#retry-the-batch-job-task-when-transient-sql-server-errors-occur
"Currently, if finance and operations apps experience a brief loss of connection to Microsoft SQL Server, all batch jobs that are running fail. This behavior disrupts business processes. Because connection loss is inevitable in a cloud service...."
Sometimes, this kind or disconnections are happening during working hours and the users get different errors, so it should be very interesting if we could send them a message or notification to the administrators indicating that we had a short SQL disconnection and the duration to avoid any misunderstanding regarding the issues.
Comments
This is a highly valuable suggestion. Acknowledging the inevitability of SQL disconnections in a SaaS environment, as outlined in the Dynamics 365 documentation, it's clear that the current behavior of batch jobs failing upon brief connection losses to Microsoft SQL Server significantly disrupts business operations. The introduction of a system that notifies administrators of such disconnections, along with their duration, represents a critical improvement. It would not only enhance transparency but also mitigate confusion and frustration by providing clear explanations for the errors users encounter. Implementing this feature would significantly improve the user experience and operational efficiency, supporting our continuous commitment to service excellence.
Category: System administration