SQL Server Performance Forum – Threads Archive
Execution plan & optimize the performance
I want to know how look at the execution plan of a stored procedure and see if there is anything I can do to optimize the performance in SQL Server 2005 <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br /> <br /><br />
Check the following…
http://www.sql-server-performance.com/query_execution_plan_analysis.asp
http://weblogs.sqlteam.com/billg/archive/2006/03/22/9388.aspx
MohammedU.
Moderator
SQL-Server-Performance.com
After looking at the execution plan, how would i get an idea of optimising the performance<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Thanks
Also check: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19594
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19595
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by i.netdeveloper</i><br /><br />After looking at the execution plan, how would i get an idea of optimising the performance<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Thanks<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br />Looks like you are not reading the articles provided here instead you are just second guessing. These articles clearly mention what to look for.[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />Thanks,<br /><br />Name<br />——— <br />Dilli Grg <br /><br />(1 row(s) affected)<br /></font id="code"></pre id="code">
I followed the articles and they worked fine for me:0
]]>