Microsoft SQL Server 2014 Unleashed

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.

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 ...