We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the information back to ArcGIS for Desktop 10.1 is prohibitively slow.
Connection is direct connect. Data type in SDE is DBO. Machines are VMs with 16Gb RAM.
Are there any tips or tricks or known documents for installs of these on SQL Server clusters where a node instance is presented?