Jun 30, 2014

Increase or decrease font size in the query execution plan in Sql server Management Studio (SSMS)

Sometimes we need to increase or decrease font size of text in the query execution for presentation etc purposes in sql server management studio (SSMS) 2014, 2012, 2008 and 2005. We can change it permanently from settings:

How to increase or decrease font size in the query execution plan in Sql server management studio (SSMS):

Step 1: Go to Tools -> Options as shown in following diagram:
 
SSMS Setting Options
Step 2: Go to Environment -> Fonts and Colors

EXECUTION Plan Font Size Change Setting SSMS

Step 3:
a. In Show Settings for drop down choose Execution Plan.
b. In the display items drop down choose Text
c.  In the size drop down choose any size which you want to set.
d.  After setting click on OK button.

Step 4: A warning message will pop up:

Execution Plan Font Size change wraning Message
Click on Ok button.

Step 5: Restart your sql server. If you don't know how to restart sql server go through this link:


Re-generate the graphical execution plan. After this your font size in the graphical query execution plan will increase or decrease permanently:

SSMS Execution Plan With Larger Font Size

No comments:

Post a Comment