Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
execution plan doesn't showing completely

Unanswered execution plan doesn't showing completely

  • Tuesday, May 01, 2012 9:05 AM
     
     
    Sign In to Vote
    0

    hi

    I have SP which is having more than 1100 query's, when ever i am running execution plan for this SP i am getting execution  plan till 200th query. I have tried using profiler too, but no luck.

     

All Replies

  • Tuesday, May 01, 2012 9:18 AM
     
     
    Sign In to Vote
    0

    Try to recompile the stored procedure.It will marked for recompile and then execute the SP to get the new execution plan.

    SP_RECOMPILE  'SP NAME'

    Please click "Propose As Answer" if a post solves your problem. OR "Vote As Helpful" if a post has been useful to you. Thanks, Debasish Mohanty Blog:http://sqlcodebank.blogspot.com

     
  • Tuesday, May 01, 2012 9:19 AM
     
     
    Sign In to Vote
    0

    Try to recompile the stored procedure.It will marked for recompile and then execute the SP to get the new execution plan.

    SP_RECOMPILE  'SP NAME'

    Please click "Propose As Answer" if a post solves your problem. OR "Vote As Helpful" if a post has been useful to you. Thanks, Debasish Mohanty Blog:http://sqlcodebank.blogspot.com

     
  • Tuesday, May 01, 2012 9:27 AM
    Answerer
     
     
    Sign In to Vote
    0
    Use this tool to get all needed info http://www.sqlsentry.net/plan-explorer/sql-server-query-view.asp

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

     
  • Wednesday, May 02, 2012 9:14 AM
     
     
    Sign In to Vote
    0

    hello Debasish Mohanty,

    i tried to recompile the procedure but it is showing same result.

     
  • Wednesday, May 02, 2012 9:18 AM
    Answerer
     
     
    Sign In to Vote
    0
    RECOMPILE will affect execution plan but I think in your case it has nothing to do how to display it... If you have 1100 queries and as you said do not see entire EP that is probably SSMS bug, but have you tried the tool I suggested above?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    • Marked As Answer by thanneru.vasu Wednesday, May 02, 2012 1:40 PM
    • Unmarked As Answer by thanneru.vasu Wednesday, May 02, 2012 1:40 PM
    •