Designing with patterns in the real world
Check out this SlideShare Presentation:
SQL Sentry Plan Explorer
SQL Sentry Plan Explorer is a FREE tool which builds upon the graphical plan view in SSMS to make query plan analysis more efficient. It contains many of the plan analysis features introduced in SQL Sentry v6, however, the lightweight tool does not require a collection service or database. Features There are several ways to load a plan: * In SSMS, right-click a graphical plan and select “Show Execution Plan XML”, then copy and paste the plan XML into the Plan Explorer. It doesn’t matter which pane is active, the clipboard handler is global and will auto-detect the plan XML. * Save an execution plan from SSMS to a .sqlplan file, then open the file using the Open toolbar button, File->Open menu, or Ctrl + O. Raw plan XML files and .QueryAnalysis files (our own proprietary format) are also supported. * Right-click an existing .sqlplan file in Windows Explorer and select “Open with -> SQL Sentry Plan Explorer”. * Drag-and-drop a plan file onto the application. * R
Comments