• I have had situations in the past where SQL Serve reported a network problem but the Network people said nothing had gone wrong.

    Eventually we wrote a simple script that did a PING every second and saved the result. This showed intermittent network problems, and the Network people had to accept that something had gone wrong. Eventually they found and fixed the problem, but as with anything that is intermittent it took a while to sort out.

    If you can prove that the problem happens outside of SQL Server, then you have a better chance of the subject matter experts accepting a problem exists and getting it fixed.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara