Clear all recommendations

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Clear all recommendations

Postby toad2898 » Thu Sep 17, 2009 9:30 am

Is there a way to clear all recommendations like you can with alerts?
toad2898
 
Posts: 29
Joined: Mon Sep 14, 2009 2:36 pm

Postby priyasinha » Thu Sep 17, 2009 10:27 am

Hi,

No, you cannot clear a recommendation. It removes itself when the condition which triggered the recommendation no longer exists.

But having said that, do you think you would like to suppress recommendations even when the condition which triggered still exists?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby toad2898 » Thu Sep 17, 2009 10:35 am

Thanks Priya

If they remove themselves then that's ok but I was coming at it from this point of view:- I ran SQL response without configuring it properly for my environment. Now I have configured it properly I now have a lot of unapplicable recommendations still sat around what I'd liked to have wiped clean.

Cheers
toad2898
 
Posts: 29
Joined: Mon Sep 14, 2009 2:36 pm

Postby priyasinha » Thu Sep 17, 2009 11:59 am

Hi,

I get your point.

SQL Response checks for recommendation every few hours. If you have now configured your enviornment and disabled/ changed config parameter for particular recommendation then it should go off when the next time that particular recommendation is checked again. So eventually all the disabled one should clear itself. But if this is not happening in your environment then please do let us know. It might be a bug then.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests