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