cheshirefox (9/25/2012)
We tried all sorts of fixes, including contacting Microsoft. Microsoft did not provide any feedback.Finally - we executed the following in order...
DBCC FREEPROCCACHE
EXEC sp_recompile 'dbo.StoredProcedureName' (we preformed sp_recompile for over 100 Procedures).
DBCC FREEPROCCACHE
Once the final FreeProcCache finished - the server became operational w/out issue.
We'll be scheduling a daily process to execute the FreeProcCache.
FYI, CU3 for SQL Server 2012 has been released. It is available via:
http://support.microsoft.com/kb/2812412
There are a number of fixes in this particular CU which address a host of performance issues. Most notably:
SQL Server 2012 experiences performance issues in NUMA environments
http://support.microsoft.com/kb/2819662
FIX: CPU spike when there is no load on a server after you install SQL Server 2012 on the server
http://support.microsoft.com/kb/2813214
FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2 or in SQL Server 2012
http://support.microsoft.com/kb/2819662
FIX: Poor performance in SQL Server 2012 when you run a SQL Server trace
http://support.microsoft.com/kb/2803529
FIX: Memory leak when you run queries against a temporary table in a nested stored procedure in SQL Server 2012
http://support.microsoft.com/kb/2803065
Tommy
Follow @sqlscribe