I have a couple of new server machines that I'm setting up with ArcGIS Server and SQL Server for our enterprise geodatabases. I'll be migrating our map services and geodatabases to the new servers but I have been doing a bit of testing first. In testing the time it takes to render a few different layers from a dynamic map service, I'm surprised to find that my simple feature classes stored in SDEBINARY still have a performance advantage over using the GEOMETRY spatial type. Same finding as when I went through all this years ago with older hardware and software. In some circumstances the difference is still dramatic.
The servers are running Windows Server 2012 R2, SQL Server 2014, and ArcGIS Server 10.5.1. The geodatabase is 10.5.1.
Anybody coming to the same conclusions? Or have you found the other spatial types to be better?