I disabled a query for analysis advisor for it is a batch job.
But I wonder if there is a way to re-enable it.
Thanks
select name, id from cond; -- this will give the id for the db you are tracking down the disabled query analysis for
select * from con_problem_silence_<Id from above>
this will show if there are any sql ids that are silenced and the date of the silencing
You can delete the row from con_problem_silence_<id> to get the analysis to start again on that statement.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.