208 results found

1. Alert History on new Overview - Don't show Cleared Alerts

   The slide-out Alert pane is useful on the Overview IF, and ONLY IF, under normal circumstances we want to see NON-cleared Alerts, like the default filter on the Alerts page itself.

   Please make this pane behave like the Alert page's filter, and allow us to re-filter, to include cleared if we want to. But at the very least allow us to set a default filter (in my case NON-cleared).

   Thanks.

   7 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Adam responded

   Hi, thanks for the suggestion. The version 6.0.10 release added the ability to show/hide cleared and ended alerts from the timeline and alert sidebar on server overviews. We intend to add this to the global dashboard soon. Hopefully this solves the issue.

2. Push 5.2 Alias down to Analysis and beyond

   The write-up about the 5.2 Alias feature waxes almost lyrical about how much we would like it...

   Until you open the Analysis page and see the old names - in my case unintelligible I.P. addresses. Sad, very sad...

   Please make Aliases utterly pervasive, as in Analysis, Configuration => Monitored Servers (I.P. list), emails (just to make sure they're not overlooked).

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Adam responded

   I’m closing this suggestion because the server aliases were fixed in v5.2.2.

   However, there is currently no way to alias cluster/machine names, so if this is important, please do raise this as a suggestion as we could look to address that if there is demand

3. Multiple group select on new Global Dashboard version 5.2

   As an administrator, I want to be able to select one or more groups for displaying on the new global dashboard (added in version 5.2). Now you see all groups or one group.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Show deadlock alerts using the deadlock graph

   Display deadlocks alerts in a more graphical and easier to understand way.

   35 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   6 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Adam responded

   Thanks for this suggestion. Version 8.0.2 uses extended events to display graphs for the deadlocks.

   We will close this suggestion, but please do add another suggestion if there are further improvements you would like to see.

   Kind regards,
   SQL Monitor Development Team

5. Receive an alert for the process that is blocking not the process being blocked.

   We recently upgraded our SQL Monitor to version 5.1 and it appears there has been a change in the Blocking process metric. Before the upgrade we received an alert about a process that was blocking and after the upgrade it appears we receive an alert for each of the processes being blocked. We have set the threshold for 90 seconds and if there are three processes that are 30 seconds that total the 90 seconds, we receive an alert. However we don’t want to receive an alert for the 30 second blocked processes. Is there a way we can understand this change or configure it so we don’t get alerts that are blocked for less than 90 seconds?

   We recently upgraded our SQL Monitor to version 5.1 and it appears there has been a change in the Blocking process metric. Before the upgrade we received an alert about a process that was blocking and after the upgrade it appears we receive an alert for each of the processes being blocked. We have set the threshold for 90 seconds and if there are three processes that are 30 seconds that total the 90 seconds, we receive an alert. However we don’t want to receive an alert for the 30 second blocked processes. Is there a way we can understand… more

   10 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Neil Turner responded

   See https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/metrics-and-alerts-reference/list-of-alerts#Listofalerts-BlockingProcess

6. Bring back the ability to list fragments of T-SQL to reduce Blocking Process alerts, please

   By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).

   Looks like this:

   use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else begin select @indexId=indexid from sys.indexes where objectid=@tblId and name='PKtblForecast' if @tblId=-1 OR @indexId IS NULL RAISERROR( N'Index does not exist or permission denied: %s', 16, 1, '[PKtblForecast]' ) else begin select avgrecordsizeinbytes, avgpagespaceusedinpercent, pagecount, avgfragmentationinpercent from sys.dmdbindexphysicalstats(@dbId, @tblId, @indexId,@partitionId,'LIMITED') WHERE ([allocunittypedesc] = 'INROWDATA') END END END

   Back in the days of SQL Monitor 3x, and maybe 4x, we could list fragments-to-ignore, and that reduced HUGE volumes of false-positive Alerts.

   Either my abilities to find the equivalent are sadly lacking, or RG has removed this feature.

   Please, please, either tell me where it's buried, or restore it!

   I honestly don't care if this type of monitoring query is being blocked. Neither, actually do I care if it is the victim of a Deadlock - "it will run at the next scheduled slot".

   Thanks, either way.

   By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).

   Looks like this:

   use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else begin… more

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Adam responded

   Version 6.0.16 has now been released and this includes the ability to add regular expression filters to blocking process alerts. We hope this completes your suggestion.

   Thanks, SQL Monitor Team

7. Add "Re-send Email" for an Alert

   Some emails find black holes. Need option in the "Actions" dropdown to re-send an Alert email. Please pop-up the addressee dialog so we can direct/redirect to recipient list and add a custom subject to help us segregate the email into an email thread for discussion/attention.

   15 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   4 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Adam responded

   Version 9.0.7 has now been released and adds the ability to manually send an alert as an email notification to any addressee.

   https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notes

   We will mark this as completed, but please do raise a suggestion if you would like to see further improvements.

   Thanks for your patience,
   SQL Monitor Development Team

8. Custom reports against alerts, queries and metrics

   CONTEXT: We want to see the bigger picture arising from the data presented in SQL Monitor.

   PROBLEM: Currently you can't pull together a report in the SQL Monitor UI, and the monitoring database is not particularly accessible. We need reports against:
   - The metrics shown in the analysis graph
   - The top queries and waits
   - The alerts raised over time
   - Server configuration and SLA

   EXAMPLE SOLUTIONS:
   - Provide reporting scripts against the monitoring database
   - Privide a BI interface against the monitoring database
   - Priovide richer data-export functionality in the UI
   - Provide a report designer in the UI (perhaps allowing for regular reports to be sent)

   CONTEXT: We want to see the bigger picture arising from the data presented in SQL Monitor.

   PROBLEM: Currently you can't pull together a report in the SQL Monitor UI, and the monitoring database is not particularly accessible. We need reports against:
   - The metrics shown in the analysis graph
   - The top queries and waits
   - The alerts raised over time
   - Server configuration and SLA

   EXAMPLE SOLUTIONS:
   - Provide reporting scripts against the monitoring database
   - Privide a BI interface against the monitoring database
   - Priovide richer data-export functionality in the UI
   - Provide a report designer in the… more

   263 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  56 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. When using Windows authentication I want the read-only account/group option.

   I like the windows authentication but it doesn't have the read-only option. I would like to be able to add users and AD groups where I can limit the servers, but also make the data read-only, just like the options when not using Windows Authentication.

   8 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   6 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Adam responded

   Apologies for not updating the status of this suggestion. We have supported this since version 6.0.17. When adding an AD user or group, you can now choose whether that user should be a standard or read only user (or an administrator). So you can do this, and can also choose the permission level for each individual user, rather than having to define it for the system as a whole.

   Thanks for your patience,
   SQL Monitor Development Team

10. Use the Base Monitor Service account to query Active Directory when using AD Credentials

    We are using a Managed Service Account to run SQL Monitor so we don't have to manage passwords. However we still need to have a regular domain account to query AD because there is no option other than to specify a username and password.

    What would be great is to have an option to use the base monitor service account to query AD instead of having to specify a username and password.

    This would work in a similar way to what already exists when setting up credentials for the server you monitor, where you can choose to connect to the host machine using the Base Monitor Service Account. It doesn't replace the current username/password fields that are there for environments that need to use a different user.

    We are using a Managed Service Account to run SQL Monitor so we don't have to manage passwords. However we still need to have a regular domain account to query AD because there is no option other than to specify a username and password.

    What would be great is to have an option to use the base monitor service account to query AD instead of having to specify a username and password.

    This would work in a similar way to what already exists when setting up credentials for the server you monitor, where you can choose to connect to the… more

    12 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Neil Turner responded

    AD (LDAP) Auth can now be configured using the base monitor service account, this includes GMSA accounts. See https://documentation.red-gate.com/sm12/adding-sql-monitor-users/authenticating-with-active-directory

11. Monitor SQL Server 2014 failover clusters with Cluster Shared Volumes

    There is currently some trouble with monitoring a windows failover cluster with CSV - specifically, the error log is unreachable because base monitor apparently connects to the wrong network name to access files.

    7 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Adam responded

    As mentioned in the comments, this was completed in v5.2.7
    (relevant issue was SRP-10451: Cannot retrieve log files for users who monitor SQL Server installed on a clustered shared volume).

    Apologies for not updating this at the time.

    Thanks
    SQL Monitor Development Team

12. See how alerts correlate in time

    CONTEXT: When investigating an alert, it is useful to see what else has happened at the time. SQL Monitor gives detailed performance and query data with every alert details report, but doesn't show what other alerts have been raised at the time

    PROBLEM: Sometimes alerts inform one another. E.g. a Long-running query can be caused by a blocked process, or a deadlock can cause a job failure. Alerts coinciding with the current one potentially help us to determine the root cause

    EXAMPLE SOLUTIONS:
    • List time-correlated alerts when viewing alert details
    • See alerts over time on a graph
    • Export alerts to an outlook calendar

    What do you think about these solutions? Got another idea? Let us know in the comments!

    CONTEXT: When investigating an alert, it is useful to see what else has happened at the time. SQL Monitor gives detailed performance and query data with every alert details report, but doesn't show what other alerts have been raised at the time

    PROBLEM: Sometimes alerts inform one another. E.g. a Long-running query can be caused by a blocked process, or a deadlock can cause a job failure. Alerts coinciding with the current one potentially help us to determine the root cause

    EXAMPLE SOLUTIONS:
    • List time-correlated alerts when viewing alert details
    • See alerts over time on a graph
    •… more

    38 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    10 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Adam responded

    Version 6.0 was released on August 30th, 2016 and contained a new Server Overview which shows alerts over time.

    I am closing this as there have been no new comments since it was released. If you would like to see specific improvements to this feature, please raise a new suggestion.

    Thanks,
    SQL Monitor Development Team

13. Reduce the number of false-positive status alerts (e.g. Machine unreachable)

    CONTEXT: Many status alerts (eg. Machine unreachable) have a simple configuration model, meaning that these alerts will trigger as soon as a ping to the Machine fails.

    PROBLEM: VPN connection resets, scheduled restarts, etc. all may be acceptable causes for a ping to fail in our system, but these currently lead to a lot of false positives... provided they are brief, and the system recovers in time.

    EXAMPLE SOLUTIONS:
    • Add configuration to the machine unreachable alerts to set a time threshold
    • Require two consecutive pings to fail before raising the alert

    92 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    15 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Adam responded

    Version 5.0.5 introduced the ability to configure machine unreachable, and SQL Server instance unreachable, by multiple time thresholds. We left this open for a while to see if there were any further requests. Thanks for the suggestion.

14. Triage and configure repeating alerts more efficiently

    CONTEXT: Some alert types such as Long-running queries, Job Failure or Error Log Entries can trigger very frequently under certain circumstances.

    PROBLEM: This causes a large number of alert emails to be sent, and the only way to ascetain that all these alerts are the same is to view the details screen for all of them.

    EXAMPLE SOLUTIONS
    • Group similar alerts in the alert inbox
    • Raise alerts not on individual events, but on these events happening a specified number of times
    • Mention identifying information sooner: e.g. directly in the alert inbox
    • Suppress query-based alerts for specific databases (e.g. deadlocking 3rd party vendor databases)
    • Have a "quick config" workflow that exludes the current lot of similar alerts without us having to write any regular expressions or other complicated config mechanisms
    • When an alert configuration is applied, provide the option to close affected alerts.

    CONTEXT: Some alert types such as Long-running queries, Job Failure or Error Log Entries can trigger very frequently under certain circumstances.

    PROBLEM: This causes a large number of alert emails to be sent, and the only way to ascetain that all these alerts are the same is to view the details screen for all of them.

    EXAMPLE SOLUTIONS
    • Group similar alerts in the alert inbox
    • Raise alerts not on individual events, but on these events happening a specified number of times
    • Mention identifying information sooner: e.g. directly in the alert inbox
    • Suppress query-based alerts for specific… more

    462 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  61 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Make SQL Monitor scale to more machines and networks

    CONTEXT: We want to monitor many different servers in different domains and locations

    PROBLEM: Network configuration for cross-domain monitoring can be challenging, and SQL Monior can slow down if many servers are being mointored

    EXAMPLE SOLUTIONS:
    • Create a central web interface that can access multiple Base monitors
    • Provide an optional agent that can be deployed for easier network configuration
    • Make a single installation of SQL Monitor scale to a larger number of servers, and make network configuration easier

    126 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  21 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Forecast and plan disk/database capacity

    CONTEXT: When looking after a large number of databases, we have to make sure that none of them run out of space or I/O capacity.

    PROBLEM: SQL Monitor needs to show us:
    • The current size of Database files (and which disks they are on) and how full they are, ideally with a forecast
    • Autogrowth configuration
    • Space remaining on disk, ideally with a forecast
    • File and disk-level IO metrics, ideally with a forecast

    EXAMPLE SOLUTIONS:
    • Provide this data as metrics in the Analysis Graph
    • Create a Disk Overview report with this data
    • Enhance the "Disk space" alert with this data

    What do you think about these solutions? Got another idea? Let us know in the comments!

    CONTEXT: When looking after a large number of databases, we have to make sure that none of them run out of space or I/O capacity.

    PROBLEM: SQL Monitor needs to show us:
    • The current size of Database files (and which disks they are on) and how full they are, ideally with a forecast
    • Autogrowth configuration
    • Space remaining on disk, ideally with a forecast
    • File and disk-level IO metrics, ideally with a forecast

    EXAMPLE SOLUTIONS:
    • Provide this data as metrics in the Analysis Graph
    • Create a Disk Overview report with this data
    • Enhance the… more

    217 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    11 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Adam responded

    Thank you for this suggestion. Version 8.0.10 released July 10th, 2018 includes a new Estate tab containing the new “Disk Capacity Planning” feature.

    We hope this meets the requirements and will close this suggestion, but please do raise another suggestion if you have specific improvements you’d like to see.

    Kind regards,
    Adam
    SQL Monitor Development Team

17. Suppress performance-related alerts during maintenance periods

    CONTEXT: I expect my system to slow down during routine maintenance tasks, which often leads to false postitives for performance-related alerts (long-running queries, High CPU...) in SQL Monitor.

    PROBLEM: While I could configure a maintenance window where alerts don't get raised, this would also suppress operational alerts (e.g. Machine unreachable, Job failed) - these are still relevant while maintenance is in progress

    EXAMPLE SOLUTIONS:
    • Allow to configure maintenance times for individual alerts
    • Change maintenance window behaviour so that operational alerts are still active during maintenance

    What do you think about these solutions? Got another idea? Let us know in the comments!

    CONTEXT: I expect my system to slow down during routine maintenance tasks, which often leads to false postitives for performance-related alerts (long-running queries, High CPU...) in SQL Monitor.

    PROBLEM: While I could configure a maintenance window where alerts don't get raised, this would also suppress operational alerts (e.g. Machine unreachable, Job failed) - these are still relevant while maintenance is in progress

    EXAMPLE SOLUTIONS:
    • Allow to configure maintenance times for individual alerts
    • Change maintenance window behaviour so that operational alerts are still active during maintenance

    What do you think about these solutions? Got another idea? Let us know… more

    233 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    24 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Neil Turner responded

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

18. Only receive emails for the most important alerts

    CONTEXT: I review alerts raised by SQL Monitor in order to stay on top of my server activity, and I also have alert emails enabled in order to respond quickly to issues.

    PROBLEM: I only want to receive emails for issues that require immedate action or are otherwise noteworthy. I don't want to change the alert thresholds because for my triage, the "lower-priority" alerts are still interesting - but they shouldn't be sent as emails.

    EXAMPLE SOLUTIONS:
    • Send emails by alert priority - e.g. medium and high only
    • Alter the default alert behaviour to only send emails for high-priority alert types
    • Send emails for "new" alerts - such as a long-running query that hasn't been encountered before - but don't email about repeat offenders
    • implement an alternative triage view that lists significant events that happened on my servers independently of alerts getting raised - this way we can set higher alert thresholds without losing information.

    What do you think about these solutions? Got another idea? Let us know in the comments!

    CONTEXT: I review alerts raised by SQL Monitor in order to stay on top of my server activity, and I also have alert emails enabled in order to respond quickly to issues.

    PROBLEM: I only want to receive emails for issues that require immedate action or are otherwise noteworthy. I don't want to change the alert thresholds because for my triage, the "lower-priority" alerts are still interesting - but they shouldn't be sent as emails.

    EXAMPLE SOLUTIONS:
    • Send emails by alert priority - e.g. medium and high only
    • Alter the default alert behaviour to only send emails for… more

    240 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    21 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Adam responded

    We have released version 9.0.10 of SQL Monitor which includes the ability to choose to receive notifications for only high level alerts, or only high and medium alerts (or the default of all severities) globally.
    https://documentation.red-gate.com/sm9/release-notes-and-other-versions/sql-monitor-9-0-release-notes

    We realise this is long overdue, as we’ve struggled to provide one solution to the different problems contained in this suggestion. As such, we’ve decided to break this down into different problems we can look to address.

    We believe this release delivers the solution to the problem originally suggested, to be able to send email notifications for alerts with a Medium or High priority, so will mark this as completed. However, please do raise new suggestions for anything you feel hasn’t been addressed by this release, so we are able to consider each one as we continue to improve SQL Monitor.

    Thank you for your patience,
    SQL Monitor Development Team

19. Single sign on

    Make it so that I can add an AD group to the settings, then enable AD Auth in IIS and not be prompted for username and password.
    LDAP settings should not be needed.

    15 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    8 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Daniel Rothig responded

    Support (at) red-gate.com can provide you with instructions how to disable SQL Monitor authentication in order to fall back on IIS authentication, which supports Single Sign On.

20. Raise Alert level based on time

    Currently all alert levels are based on the numbers allocated and the alert is simply triggered at that level,

    Some of the values I'm tracking sit at 0 quite often, the problem is less the number but the length of time that it remains at that number

    So after 5 collections i would like to raise a low alert, after 10 collections a medium and after 20 a high alert

    Thanks for your time and concideration

    Ste

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Daniel Rothig responded

    Hi this is planned for status alerts: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123793-reduce-the-number-of-false-positive-status-alerts

    For custom metrics that’s already possible via the custom metric wizard

    Thanks
    Daniel