Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 execution plan doesn't showing completely

Author  Topic 

thanneru
Starting Member

1 Post
Posted - 2012-05-02 : 08:16:15
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.

http://social.microsoft.com/Forums/getfile/29447/

robvolk
Most Valuable Yak

15732 Posts
Posted - 2012-05-02 : 09:24:12
Try SQL Sentry Plan Explorer instead, it's a free tool:

http://www.sqlsentry.net/plan-explorer/sql-server-query-view.asp

And you should consider simplifying your stored procedure. 1100 query statements is a lot.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site