How do you use cloud databases? Take the survey.
Options

Remove a single instance from monitor

mrothwellmrothwell Posts: 3 New member
in Redgate Monitor
I'm new to using Sql Monitor, I just started this job where they already had it configured.  We have a server with 2 instances being monitored, but I need to remove one of the instances from the monitor, as I have removed the instance from the server.  I cannot find a way to remove the instance from SQL Monitor.
Tagged:
· Share on Twitter

Answers

  • Options
    MarkusMarkus Posts: 26 Bronze 2
    I haven't monitored multiple instances on the same server.  But here is a thought.  Stop monitoring it all but don't delete the old data.  Then re-add it only checking the instance you want to monitor.
    · Share on Twitter
  • Options
    mrothwellmrothwell Posts: 3 New member
    I tried that.  As soon as I added the server and default instance, the named instance that I removed showed back up on the monitor and started alerting.
    · Share on Twitter
  • Options
    mrothwellmrothwell Posts: 3 New member
    as a follow-up...  The removed instance finally did disappear.  Not sure why or how.
    · Share on Twitter
  • Options
    Russell DRussell D Posts: 1,324 Diamond 5
    edited March 11, 2019 8:10AM
    One possible explanation is if there was any data recorded for the instance, even after removing it from the server, it would live on in many views until the underlying data was purged.
    Have you visited our Help Centre?
    · Share on Twitter
Sign In or Register to comment.