We have recently upgraded our ArcMap instances to 10.4 and are now having performance issues with our SQL Spatial Views.
Querying on the database side is fine, its when the views are loaded into ArcMap 10.4 when the slowness starts. If I fiddle with the view I can make it perform better but its hit and miss. The 10.4 client is doing something because in 10.3 clients the views perform as expected.
Our SDE Geodatabase has also been upgraded to 10.4 and is running on SQL Server 2012 (64 bit)
One additional note: If I create the exact same view as a "Query Layer" in ArcMap the data performs as expected. Its only when its compiled as a SQLSpatial View when the slowness starts.
Has anyone else had this problem or have a solution?