Home Forums SQL Server 2012 SQL 2012 - General Stored proc runs slow after upgrade to SQL 2012 RE: Stored proc runs slow after upgrade to SQL 2012
balasach82
SSCrazy Eights
Points: 9653
More actions
August 30, 2015 at 1:09 am
#1823250
Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than what we had in SQL 2008 (win 2003).
Yes, stats are uptodate. There are 1 or 2 indexes only which doesnt have much frag.