Creating and Managing Plan Guides in SSMS

SQL Server 2014 enables you to create, delete, enable, disable, or script plan guides within SSMS. The plan guides options are available in the Programmability folder in Object Explorer. To create a new plan guide in SSMS, right-click on Plan Guides and select the New Plan Guide option. This brings up the dialog shown in Figure 35.1.

Image

FIGURE 35.1 Creating a plan guide in SSMS.

To manage existing plan guides in SSMS, you can right-click on the plan guide name to bring up the context menu that allows you to enable, disable, delete, script, or view the properties of the plan guide, as shown in Figure 35.2 ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.