SQL statements captured in the SQL Collector for Monitor Server modules are displayed with corresponding query plan using the sp_showplan stored procedure. If the query plan is not available, then the Query Plan pane window remains blank and the SQL is classified as SQL without Plan
Note: It is not guarantee that using the sp_showplan stored procedure to retrieve the query plan will obtain a query plan that corresponds to the SQL statement.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center