SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Thu, 18 Feb 2010 01:30:05 +0000 Indexed on 2010/03/12 1:37 UTC
Read the original article Hit count: 1209

Recompilation process is same as compilation and degrades server performance. In SQL Server 2000 and earlier versions, this was a serious issue but in SQL server 2005, the severity of this issue has been significantly reduced by introducing a new feature called Statement-level recompilation. When SQL Server 2005 recompiles stored procedures, only the statement that [...]

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about sql