Comments
Sort by recent activity
Opened a ticket with Redgate support. This was their response. This did seem to work for me -- we don't have clustering. And for me, it occurs in a few versions earlier than what they reported. Thank you for contacting Redgate support!
I am sorry that you are having trouble with SQL Monitor.
The development team is aware of this issue that occurs from SQL monitor build
11.2.13 and later. They are working on this and I will let you as soon as there
is an update.
In the meantime, the below workaround seems to stop the errors.
1.
Find the ConfigurationFileEditor.exe tool included under the C:\Program Files\Red Gate\SQL
Monitor\BaseMonitor\Tools directory of
a base monitor installation.
2.
Right-click and run the tool as an Admin
3.
Click on the Load Configuration File option and then select the
"RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config"
which should be residing under the C:\ProgramData\Red Gate\SQL Monitor directory by default
1.
It's recommended that you save a copy of the config file
elsewhere before editing it further
4.
Once you've loaded the config file, scroll to the samplers
mentioned below and change the dropdown box to Disabled (it should already be
checked).
[Cluster].[SqlServer].[Properties].[Registry] [Cluster].[Machine].[Security] <span>[Cluster].[Machine].[Security].[CommunicationProtocol]<br></span> [image] 5.
Then save the configuration file and then restart the SQL Monitor Base Monitor
Windows service. / comments
Opened a ticket with Redgate support. This was their response. This did seem to work for me -- we don't have clustering. And for me, it occurs in a few versions earlier than what they reported...
First install attempt for new version 10.0.10.28314 failed to uninstall the old (Base Monitor service got disabled and could not change properties). After closing everything out, 2nd attempt successful. / comments
First install attempt for new version 10.0.10.28314 failed to uninstall the old (Base Monitor service got disabled and could not change properties). After closing everything out, 2nd attempt succe...
Our Job Duration Unusual alert was turned on again after my last post. I don't get 100's of alert emails anymore. However, I do now have same issue as @DevendraSingh. (Connection failed Internal SQL Monitor error) / comments
Our Job Duration Unusual alert was turned on again after my last post. I don't get 100's of alert emails anymore.However, I do now have same issue as @DevendraSingh. (Connection failed Interna...
Installed SQL Monitor 10.0.10.28314 (released today). This version did work after second install attempt. Many alert emails still generated ( over 300 ), but now say "Not enough data to calculate baseline". Though these seem to all have been from replication jobs that run Continuously... So, don't know if has to now occur 10 times before creating an average??? turned off alert again for now.... / comments
Installed SQL Monitor 10.0.10.28314 (released today). This version did work after second install attempt. Many alert emails still generated ( over 300 ), but now say "Not enough data to calculat...
uninstall and revert back to 10.0.8.27810 as instructed gave us back a working version. Note that the provided script dropped [settings].[ActiveDirectoryDomains] so won't be able to send the results of that query to support as instructed (might want to run these queries BEFORE running the 278-273.sql script) / comments
uninstall and revert back to 10.0.8.27810 as instructed gave us back a working version.Note that the provided script dropped [settings].[ActiveDirectoryDomains] so won't be able to send the results...
But if not using IIS (using RG SQL Monitor web server instead), where do we change the web default path? / comments
But if not using IIS (using RG SQL Monitor web server instead), where do we change the web default path?
404 error detail - this Account folder is missing... Module : IIS Web Core Physical Path : C:\Program Files\Red Gate\SQL Monitor\Web\Website\Account\LogIn " / comments
404 error detail - this Account folder is missing... Module : IIS Web Core Physical Path : C:\Program Files\Red Gate\SQL Monitor\Web\Website\Account\LogIn "
fyi - just tried to install the new version, 3 times. Site no longer functioning at all. Then, saw the Redgate SQL Monitor Base Monitor and SQL Monitor Web Service were not running (doesn't do that normally). I started these up and now get [404 - File or directory not found.] error / comments
fyi - just tried to install the new version, 3 times. Site no longer functioning at all.Then, saw the Redgate SQL Monitor Base Monitor and SQL Monitor Web Service were not running (doesn't do that...
Also experiencing the same issue after upgrade from 9 to 10.0.8.27810. Jobs reporting StartTime from years ago with infinite duration deviation, causing (Ended) alerts to fire 1000's of emails. Also, many (High) alerts being fired for 1 second duration, ignoring the "Don't raise an alert if the job run time is less than" setting. / comments
Also experiencing the same issue after upgrade from 9 to 10.0.8.27810. Jobs reporting StartTime from years ago with infinite duration deviation, causing (Ended) alerts to fire 1000's of emails. ...