通过

Yellow Icon on the Plan Guides what does it mean?

  • 项目

One of my friend asked me about the “Yellow exclamation icon” on the Plan Guides and was curious to know if this is something to be worried about.

 

 

clip_image002

 

As I wasn’t too sure of what it meant I thought of finding it myself and hence looked through the SQL CODE and figured out that; this is just a bad choice of icon or a point we want to make that you are using a plan guide (which explains the yellow warning sign). This is just an icon for plan guides and the yellow warning sign is nothing but part of the entire icon (“plan_guide_enabled.ico”)

Hence till the time sys.fn_validate_plan_guide does not report any error , there is nothing to worry about .

Comments

  • Anonymous
    November 03, 2015
    Agreed that it's a bad choice of icon, even after I checked sys.fn_validate_plan_guide I can't say I was really satisfied until I found this post. Now it's just a dull annoyance when I check my plan guides via the GUI.