679 results found
Can you Add Database Filtered in Top 10 Queries\ Wait Section.
We have more than 500 databases in instance . If you add Databases filtered than we will very helpful.5 votes
We have perhaps a unique use case where one of our Base Monitors is at a remote site with a very high latency (700+ ms). Monitoring works surprisingly well since one of the later updates but unfortunately we are getting regular “Error on Base Monitor” emails (10+ per day) even though the connection itself is stable (just very slow).
We would like to be able to control the delay before that error is raised, I’m guessing that slightly increasing this "timeout" would fix all our issues.3 votes
Could the new "Trace" feature have a schedule as well as an on/off? If not this then how about a third option "Trace until date/time"?
In a multi-base monitor configuration it is a bit cumbersome to identify which base monitor is hosting a given entry on the overview page. Yes, one can search all the SQL Server host machines on each base host, but that takes time. It would be better to have an entry in overviews that identifies where it is hosted.5 votes
It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.1 vote
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS
I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS package that is automated via SQL Agent I have to leave SQL Monitor and go to SSMS. It would be really handy if SQL Monitor could read the SSIS errors. Is this something that is in the road map or could be put in please? Thanks.13 votes
Allow for customization of emails for alerts at each alert level, so that I can send to different emails for each alert level.
So that I can send High alerts to one email address, medium alerts to another email address, etc…57 votes
For example, https://sqlmonitormetrics.red-gate.com/suspiciouserrors/ (Detect Suspicious Errors Typical of a SQL Injection Attack)...
If suspicious activity crosses a threshold, it throws an alert. Great. Now what? I have an alert but no data to investigate without opening SSMS (or tool of choice) and running a query like this (I’m sure there are better ways but this works for an example)
SELECT CAST(targetdata asxml) AS targetdata
FROM sys.dmxesessiontargets xet
JOIN sys.dmxesessions xes ON xes.address=xet.eventsessionaddress
AND xet.targetname ='ringbuffer';
, xed.eventdata.value('(data[@name="errornumber"]/value)','int')AS ErrorNum
, xed.event…2 votes
It would be great if you could set up an email routine to email out reports from the Estate tab. E.g. the backups tab would be useful to email out an export of the screen.2 votes
Although you can specify different thresholds for High, Medium and Low alerts, they all end up at the same email address or slack channel. It would be useful to be able to change this so highs went to one address, mediums to another etc.31 votes
If the user mistypes their password when trying to log into the SQL Monitor dashboard, their Windows account gets locked out in Active Directory. This happens on the first failed attempt, so presumably there's an automatic retry happening.
(This ticket is similar to https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/16845169-keep-from-locking-account-when-registering-server, but that one is for the server monitor login and this is for the dashboard user's personal login)7 votes
Thanks for flagging this. Can you please raise the issue with support so that we can investigate further? You can do so via by going to: https://productsupport.red-gate.com/hc/en-us
Design lead – SQL Monitor
in blocking tree, it shows old date/times for queries that are running. We found that it is using the login time of the spids (which could be held and sleeping for extended amount of time) instead of the start time of the executing process of that spid.
instead of using the login time, I recommend it uses the start time of the last execution of the query found in sys.dmexecrequest1 vote
We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…15 votes
There are some alerts that get triggered at odd hours and I would like to be able to suppress just those specific alerts for a certain time frame. I'm afraid to suppress ALL alerts because something could get missed.1 vote
Within the estate section under backups, it would be great to be able to exclude the expectation of backups on databases that are SQL Clones1 vote
see the full SQL in deadlock Area. Today with long querries you can see only part of it1 vote
I would like to edit the Failed SQL Server logins alert to exclude failed logins from a value like a host/IP address. We have our security guys trying to break in our SQL servers daily and it trips the failed SQL Server logins alert all the time and over alerts us.1 vote
MFA is rapidly becoming a security standard. Redgate provides a map of the entire companies estate - which would be interesting to an attacker, it would be good if security could be tightened on that login process.23 votes
I have multiple alerts (including custom alerts) on serves. I would like to configure alerts to have different thresholds for diffident periods (weekday/ weekend) OR (mornings / evenings ) OR other periods.
Like log sizes on weekends (mostly due to index maintenance) can be much higher than weekdays.
Current "alert suppression windows " applies to a host and to all alerts on it and not to specific list of alerts.1 vote
- Don't see your idea?