Tagging Changes in SQL Monitor

• 
  It's certainly a nice idea, could you post it over on the Uservoice here https://sqlmonitor.uservoice.com/forums/91743-suggestions? We use this to help prioritise future work.
  

  Russell D February 13, 2020 10:27

  - 0 +
• 
  Thanks.  While doing so I saw somebody already posted something about dropping pins on the graphs and adding notes for what changes where made at that time.  I didn't post mine, I just gave that one 3 votes.

  lmacdonald February 13, 2020 16:09

  - 0 +
• 
  I think I've found it, it's pretty popular. Thank you, I'll raise it internally as well.

  Russell D February 14, 2020 09:20

  - 0 +
• 
  In case it's of any use @lmacdonald we've recently extended the self-annotation API and whilst this isn't quite the same as being able to drop pins on the fly, you may find this helpful in going some way to achieve what it is you want: https://documentation.red-gate.com/sm/api/annotations.
  

  Russell D February 14, 2020 09:28

  - 0 +
• 
  You can add notes like this:
  
  for example.

  Russell D February 14, 2020 11:02

  - 0 +
• 
  Hi @lmacdonald. We just published an article on our Product learning website that may well suit your requirements. The idea, in brief, is that you include a simple RAISERROR() statement in the SQL batch that makes the change. A SQL Agent alerts detects it, and runs a job that uses the new API to send a message to SQL Monitor and annotate the Overview graph for the server affected by the change.
  
  Here's the link to the article: https://www.red-gate.com/hub/product-learning/sql-monitor/tagging-sql-server-changes-in-sql-monitor.
  
  Yes, I confess, I 'borrowed' your forum post title and used it for the article! It would be great to know if this works for you, or what you'd need instead. 
  
  Best, Tony.

  TonyD March 03, 2020 11:31

  - 0 +
• 
  Cool.  A little more configuring then I was picturing.  I meant you could click on the graph and add the note within SQL Monitor but this is an interesting work around.  I'll take a read.

  lmacdonald March 03, 2020 14:14

  - 0 +
• 
  Yes, true. This is more designed as a way to help you catch the changes you didn't know were coming. Setting up the Agent alert and job step is a little tricky, but it's (hopefully) plain sailing after that.

  TonyD March 03, 2020 14:26

  - 0 +

Add comment

Please sign in to leave a comment.