Monitoring Stopped - NOT INFORMED OF THIS
PDinCA
Posts: 642 Silver 1
If Monitoring STOPS, kindly send me a "REALLY OBVIOUS EMAIL" that states this has happened. "All quiet" doesn't mean my servers are OK, they may be subject to the painfully frequently occurring "Invalid Credentials" error, on an account that works for days then Monitor barfs the invalid credentials on an account whose password HAS NOT CHANGED and is set to NEVER CHANGE and has just about every permission in the world and STILL BARFS!
Sadly the Monitor Website isn't externally visible - I must Remote to the machine and don't have the real-estate/time to keep looking to see if Alerts are being generated - which happens to be the only sign on the Alerts page that anything is going on - A BIG FAT "STOPPED MONITORING" would be the most helpful addition to that page!
How about, instead of a "Help page" that says "you need these permissions", give us a tool that lets us plug in the domain account and generates, say, a Powershell script to "do the necessary to ensure that Monitor won't BARF!"
Sorry, I'm really frustrated :x with this Product - it isn't up to the standard I've expected/experienced for over 5 years as a happy Red Gate customer. Roll on v2.2 with the required scads of bug fixes we need...
Sadly the Monitor Website isn't externally visible - I must Remote to the machine and don't have the real-estate/time to keep looking to see if Alerts are being generated - which happens to be the only sign on the Alerts page that anything is going on - A BIG FAT "STOPPED MONITORING" would be the most helpful addition to that page!
How about, instead of a "Help page" that says "you need these permissions", give us a tool that lets us plug in the domain account and generates, say, a Powershell script to "do the necessary to ensure that Monitor won't BARF!"
Sorry, I'm really frustrated :x with this Product - it isn't up to the standard I've expected/experienced for over 5 years as a happy Red Gate customer. Roll on v2.2 with the required scads of bug fixes we need...
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...
Decide wisely...
Comments
Apologies that you've been having some problems with the monitoring stopping unexpectedly.
We've had a few people mention how useful it would be if they were notified when monitoring stops, so we'll be putting out an early release (in the next few weeks) with the very alerts you mention. I.e. something which informs you when monitoring as stopped.
Separately, if you get in touch with support, we can look in to the issue of why the monitoring has stopped in your environment.
Hope this helps.
Ben
Many thanks.
Decide wisely...
-jim
If you have the money, I found Spotlight on SQL Server very useful, except for the deadlocks it caused itself (really!) for 5 years on SS2000 and over a year on 2008+2000 - about 7 servers. Small potatoes to many of you full time DBAs, but for a pressed into DBA-duties SQL Developer, using both Spotlight and SQL Response (former name for SQL Monitor) gave me the graphical and educative along with the Alert-generator mix I needed to keep the servers up 99.9%+ over the 5 years.
If you're willing to help Red Gate move this product on, I'm sure you'll find it a worthwhile effort - I did with SQL Compare, Data Compare, Response, Prompt, Backup... Sometimes you get out what you put in... Anyway, that's my 2-cents...
Decide wisely...