Comments
Sort by recent activity
Try restarting the SQL Monitor Base Monitor service.
Given the apparent exactness of the the time that the problem occurred, does it coincide with any clock changes? a restart of the affected machine may solve this.
If this does not help, run the "Testing Remote Registry (PerfMon)" test detailed in this document. / comments
Try restarting the SQL Monitor Base Monitor service.
Given the apparent exactness of the the time that the problem occurred, does it coincide with any clock changes? a restart of the affected mach...
Can you take a look at the data repository database? What are the autogrowth settings? Does it have space to grow? What version and edition of SQL Server is it hosted on? / comments
Can you take a look at the data repository database? What are the autogrowth settings? Does it have space to grow? What version and edition of SQL Server is it hosted on?
Thank you for your post
Please can you email support@red-gate.com with the following information and we will log a support ticket for you.
- a link to this forum post
- the SQL Monitor error logs (navigate to Configuration > About and select Retrieve all log files)
- confirmation that you have run through the tests in this document, and a screenshot of any errors you see https://documentation.red-gate.com/page ... d=20743047 / comments
Thank you for your post
Please can you email support@red-gate.com with the following information and we will log a support ticket for you.
- a link to this forum post
- the SQL Monitor error logs (...
Thank you for your post.
This isn't possible at the moment, but I am sure that the development team would love to hear about it. Could I suggest that you post on the SQL Monitor UserVoice forum. The forum is used by the development team to gather these ideas and gauge other users interest in them. https://sqlmonitor.uservoice.com/forums ... uggestions / comments
Thank you for your post.
This isn't possible at the moment, but I am sure that the development team would love to hear about it. Could I suggest that you post on the SQL Monitor UserVoice forum. ...
The custom metrics are stored in the data repository database (RedGateMonitor). So if you are reusing the same database (or restoring a backup of the database to a new location and using that) then the custom metrics will be preserved.
Alternatively you can using SQL Data Compare to deploy the following tables from the old database to the new one.
settings.CustomAlertDefinitions
settings.CustomMetricClusters
settings.CustomMetricGroups
settings.CustomMetrics
settings.CustomMetricSQLServers / comments
The custom metrics are stored in the data repository database (RedGateMonitor). So if you are reusing the same database (or restoring a backup of the database to a new location and using that) the...
Thank you for your post.
Unfortunately, in some cases the prompt about the availability of a new version does not get displayed. This is a problem with the method that this uses and we are planning to fix it.
In the meantime, the 'trial' download that you mention is the download to use. The only difference between trial and licensed, is that the tool has been activated. Simply download, install on the machine you already have the tool on and you should be good to go. You shouldn't need to reactivate either. / comments
Thank you for your post.
Unfortunately, in some cases the prompt about the availability of a new version does not get displayed. This is a problem with the method that this uses and we are plannin...
Thank you for your post.
Usually the installer will detect that the port is already being used by SQL Monitor. However, in cases where this detection fails to work correctly, simply stop the services (SQL Monitor Base Monitor service and SQL Monitor Web Service service) and then re-run the installer.
If you are still having problems, then please email support@red-gate.com and we will attempt to help. / comments
Thank you for your post.
Usually the installer will detect that the port is already being used by SQL Monitor. However, in cases where this detection fails to work correctly, simply stop the servi...
Thank you for your post.
There are a number of things that SQL Monitor uses to monitor entities that require admin rights. For example to remotely query WMI and to access the Performance Counter Library (PerfMon) it is necessary for the monitoring user account to have administrator rights. I realise that this is less than ideal, but unfortunately there is not much we can do about it whilst still allowing SQL Monitor to provide useful information. / comments
Thank you for your post.
There are a number of things that SQL Monitor uses to monitor entities that require admin rights. For example to remotely query WMI and to access the Performance Counter L...
Question was answered on a separate support ticket. In that ticket, I wrote:
Direct reporting from the data repository database isn't something that we are able to easily support. It just hasn't been designed with this in mind and so can be difficult.
The link below is to some blog posts written about the subject. https://www.simple-talk.com/blogs/autho ... s-lambrou/ / comments
Question was answered on a separate support ticket. In that ticket, I wrote:
Direct reporting from the data repository database isn't something that we are able to easily support. It just hasn't b...
We aren't too sure what has gone wrong, but the following run against the RedGateMonitor database, seems to have solved it.
1. Ensure all the alerts are marked as cleared in the Alert Inbox
2. Run this query SELECT a.AlertId, a.AlertType, at.Name, a.[Read], a.SubType
FROM alert.Alert a
JOIN alert.Alert_Type at ON at.AlertType = a.AlertType
WHERE [Read] = 0
ORDER BY a.AlertId
3. This should return the one alert that cannot be cleared. If more than one are returned, then it should be the oldest entry (with the low numerical Alert ID). Substitute the Alert ID from the results into the query below UPDATE [alert].[Alert]
SET [Read] = 1
WHERE AlertId = <alertId> / comments
We aren't too sure what has gone wrong, but the following run against the RedGateMonitor database, seems to have solved it.
1. Ensure all the alerts are marked as cleared in the Alert Inbox
2. Run ...