Several months ago we upgraded SQL Server to 2014 on Win2012. Geodb is at 10.2.2 still.
Since the upgrade, we see performance degrade over about a 2 week period to the point of having to restart the DB server.
The SQL logs show an increasing number of error statements as shown in the title. Example: on day 10 after a restart I get one unloaded error and it repeats over 5 days, then I get 3 errors on day 16, then 40 on day 17 and finally 3500 on roughly the 18-21st day. At this point the server is paralyzed across the whole instance and needs to be restarted.
This ESRI tech article refers to a Microsoft memory error but gives no details.
Before we drop $$ on Microsoft, does anyone have a similar experience?
Best I can tell it seems to deal with spatial data types, CLR and memory.
ESRI confirmed that CLR is not required for ArcGIS to work with SQL Server.
Any help is appreciated