We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012.
Here are the things that we tried to fix the issue: - Re-indexed all the tables. - Installed the support patch from ESRI.(http://support.esri.com/en/downloads/patches-servicepacks/view/productid/160/metaid/1954).
But none of those fixed the performance issue. The machine hosting the SQL Server 2012 is a VM but it is running with 24 gb of ram. So it shouldnt be under resourced.
I found a similar problem and one of the post was saying to use the SDE Binary Storage type. I didn't do that yet because he did mention that its not recommended.