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.





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 (1)

  1. Richard Thwaites says:

    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.

Skip to main content