Stored Proc Execution plan | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Stored Proc Execution plan

Hi, <br /><br />I have a technical question. Can you please advise me in this regard …<br /><br />Question<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /> Is there any difference in Execution plan of SQL Server 2000 and SQL Server 2005?<br /><br />We are currently facing a problem, while running a Stored Proc in SQL2000 (EE) on windows 2000 + sp4 it is taking 25 min. <br />where as same stored proc on SQL 2005 (EE) on windows 2003 + sp1 it is taking 1 hour 35 min.<br /><br />I have verified, All the Tables used in SP, design and Indexes are same. Rowcount may differ a bit.<br /><br />Is there any way to find out why sql2005 is taking more time than sql2000?<br /><br />If you know the solution, please mail me.<br /><br /><br /><br />Thanks<br />Sreenivas<br /><br /><br /><br /><br /><br />With Regards<br />Sreenivas Reddy B
provide the details of the execution plan,
preferably the output of SET STATISTICS PROFILE ON for SQL 2000,
or SQL Profiler tracing the Performance -> ShowPlan Statistics, adding the BinaryData and IntegerData columns in 2005, run the query with Query->Include Actual Execution Plan, saved as XML
]]>