We recently completed a major upgrade and migration. Our SDE went from Windows 2008 with SQL Server 2008R2 and we migrated to Windows 2012 and SQL Server 2012 (all new is 64bit). We have the exact same settings, using a better and newer server even, the data is the same, server and sql and sde configs all the same, direct connect all the way around on all servers.
However, we immediately noticed that the SDE on SQL 2012 is HORRIBLE. The desktop editing process lags and hangs, its like working through Citrix in 1994. The web map application load times went from 1-3 seconds to 10-40 seconds depending on load.
Same RAM, Same CPU.... the only difference is we went to SQL 2012.
There was a similar bug reported for 10.1 here NIM082657 - When working with an SQL Server 2012 geodatabase a..
It appears this isn't actually fixed. If someone has any experience with this scenario please comment and reach out to me. Thanks!!! Aaron