April 28, 2016 at 7:59 am
We upgraded SQL Server from 2008R2 to 2014 and we've seen severe performance degradation of stored procedures that user table variables (@). Performance greatly improves by reverting to temp (#) tables. The system has hundreds of stored procedures and it is very time consuming and expensive to revert all stored procedures from table variables to temp tables.
Is this a known issue? Is there a way to prevent that?
Thanks
April 28, 2016 at 9:27 am
The first thing that comes to my mind is after the migration have you updated your statistics and rebuild indices?
April 28, 2016 at 10:18 am
Please don't cross post between forums. Most of us read all of them. Having the same question in more than one location leads to confused answers and repetition.
No more answers on this thread please. Instead, post here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply