Error: Failure to access the DBMS server

ToddAtkins

We seem to run across this error at seemingly random intervals on our server services. The full text of the error is:

Error: Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An established connection was aborted by the software in your host machine. ]

Reading up on Azure, it looks like Azure is closing the db connections on their own for...reasons? Anyway, is there a solution to this? So far the only thing I've found that works is either restarting the service or waiting for the server to shut down an idle instance and restart a new one. I've even tried putting a small python script on the scheduler that will hit the service with a random query every 10 or 15 minutes to no avail.

Specs:

Arcgis Server 10.3 Enterprise Standard (vanilla install..no extensions, no portal)

Azure A3 VM running 2012 R2 Enterprise Server (4 cores, 7 gigs ram)

Azure S2 Database (50 DTUs)

Our database is ~3.5 gigs with around a million records or so.

Thanks. The Azure platform with server is awesome otherwise.

NikhilShampur

Hi Todd,

I recommend that you use a higher performance Tier for Azure SQL Database.

I would suggest at-least an S2 or higher for anything other than a development environment.

Thanks

-Nik