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 .