219 results found

1. Allow option to exclude Integrity Check Overdue Alert for read only databases

   An alert configuration option should allow
   a database status to be checked when querying for last good integrity checks and read_only databases could be excluded from the alert. Even when integrity checks are performed on read only databases, the last checked date is not updated resulting in unnecessary alerts in most cases.

   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…)
   0 comments  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   Thanks for this suggestion.

   Version 9.0.7 has now been released and adds the ability to exclude read only databases from Integrity Check Overdue and Fragmented indexes alerts.

   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,
   SQL Monitor Development Team

2. Disable Chat functionality

   It would be nice to have an Option to disable the built in chat functionality. I understand this is a quick easy method for obtaining feedback from the user community. The issue I have is that this is not an "Approved Chat Client" according to my info sec unit.

   Having the ability to turn it off allows me to satisfy their requirements while still allowing this to be enabled for other users to quickly interact and provide feedback to RedGate.

   6 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 →
   completed  ·  Adam responded

   After upgrading to SQL Monitor 6.0.8 or later you can now disable the intercom chat feature.

   After upgrading navigate to the following file C:\Program Files\Red Gate\SQL Monitor\Web\Website\web.config

   and amend the line

   intercom enabled=“true”

   to be false, then restart the website.

   Further details can be found here:
   https://forums.red-gate.com/viewtopic.php?f=205&t=80218&sid=76afdd87b11da381fcb31901d658270a#p143776

   Thanks for your patience with this issue,
   SQL Monitor Development Team

3. Block Specific Deadlocks by Lock Details

   We've just updated to SQL Monitor 6. We was hoping there was a feature in this to change alert settings for Deadlocks with specific lock details rather than just all Deadklocks.

   For example
   we don't want email alerts on: Deadlock 'object: ReportServerTempDB.dbo.SessionLock, lock mode: Exclusive (X), index: IDX_SessionLock

   However we wish to receive emails when: Deadlock 'dbid: 6, object id: 72057594038845440, index id: (9bf78693a4b4)'

   However this feature doesn't exist. Would be great to have added to an update in the near future!

   42 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 →
   completed  ·  Adam responded

   Thanks for this suggestion and the comments.

   As previously announced, since version 8.0.22 (released November 13th, 2018) Deadlock (XE) alerts can now be filtered by database, login name & resource, and victimless (eg Exchange Event) deadlocks are excluded by default.

   We are marking this as complete, but please do let us know if you have any further feedback.

   Thanks,
   SQL Monitor Development Team

4. Relative-day maintenance windows

   Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".

   Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".

   Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out unwanted alerts.

   As Red Gate uses, or at least used to use, RS, would this be in our mutual interest to support this kind of window scheduling?

   And then there is OUR maintenance day, which falls on a NON-RS week, at a different time! So we need TWO maintenance windows PER SERVER, that are BOTH relative-week-and-day centric.

   I've up-voted the "need two windows" suggestion, but this goes beyond that need.

   Rackspace maintenance days revolve around, for example, "Default week - Wednesday - 02:00 to 04:00", where "default week" is established in the service contract. That can change to early-week or (I forget the name) "late-week".

   Current SQL Monitor Maintenance Windows are wholly inadequate to record a "Default week is 2nd week of each month, maintenance on that week's Wednesday, at (the time period)".

   Without this, my PagerDuty Alerts go berserk during maintenance windows, and shy of having someone go and suspend monitoring at 2 in the morning and remember to turn it back on, it just keeps on sending out… more

   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…)
   1 comment  ·  Delete…  ·  Admin →
   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

5. Don't bloat plan cache

   Fix this query so the nvarchar() parm is of a fixed size (or MAX). As is, each invocation is generating its own execution plan and bloating the plan cache.

   (@p0 bigint,@p1 bigint,@p2 nvarchar(560))INSERT INTO [data].[ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)

   (@p0 bigint,@p1 bigint,@p2 nvarchar(159))INSERT INTO [data].
   [ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)

   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…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   Completed in v6.0.3
   Thanks again for the suggestion, we appreciate your input.
   SQL Monitor Development Team

6. "CLEARED" alerts button should be renamed to "CLEAR".

   On the alerts screen, there is an option to select alerts. If you want to clear the alerts selected you hit the button labeled "CLEARED".
   
   Having the button marked "CLEARED" is confusing because it implies that the button is a filter rather than an action. It should be labeled "CLEAR" so you know you are performing an action.

   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…)
   0 comments  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   Thanks for this suggestion.

   We agree the labels were confusing so this was fixed in version 8.0.2 in March (apologies for delay in updating) when the new inbox was released. The button now reads ‘Clear’ as you suggested.

   Thanks again,
   SQL Monitor Development Team

7. SQL Monitor 5.2.5 upgrade dashboard server/SQL Server memory

   Upon upgrading from 5,1 to 5.2.5 the new Global Dashboard no longer shows machine memory vs. memory being consumed by SQL Server. Why was this removed? This can be critical to see if SQL Server or any other process is using up all of the servers memory.

   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 →
   completed  ·  Adam responded

   Thanks for this suggestion. Apologies for not closing this sooner as it was completed a long time ago; we did agree that we should show machine memory vs. SQL Server memory and this is shown on the Server Overview memory chart.

   Thanks,
   SQL Monitor Development Team

8. Navigation for "rewind time" shouldn't hide navigation buttons

   The navigation controls for "rewind time" autohide when actively using this feature. Please consider enabling until "live" is chosen again to simplify operation to move back and forth in time increments.

   Issue submitting first time. if duplicate please close.

   •  

   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 →
   completed  ·  Adam responded

   Closing this because the v6 server overviews no longer have this particular time control so hopefully this bug is no longer relevant.

9. On the main dashboard please maintain a consistent ordering.

   Dashboard element sorting should be fixed preferably in alphabetical order. The whole idea of a dashboard should be to provide an at a glance view of the state of your server set. When you change the order from servername when all is green to some other order because something has triggered an alert on a server I have to spend extra time figuring out which server has an issue because the sort order has changed.

   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…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   Version 6.0.11 has now been released and amongst the enhancements is the ability to fix the servers in alphabetical order (Oder by: Name).

   If you have any feedback, email sqlmonitorfeedback@red-gate.com

   Thanks,
   SQL Monitor Development Team

10. 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 →
    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.

11. 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 →
    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

12. 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 →

13. 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 →
    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

14. 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 →
    completed  ·  Neil Turner responded

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

15. 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 →
    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

16. 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 →
    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

17. 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 →

18. Make comments apply to alert types, rather than individual incidents

    CONTEXT: We use comments to document the root cause of alerts we encounter

    PROBLEM: When alerts repeat, recovering the comments is a pain - they only apply to individual occurences, so don't get surfaced when they issues re-occur.

    EXAMPLE SOLUIONS:
    - Show historical comments in alerts
    - When creating alerts, allow us to choose whether this applies to the whole alert type

    ADDITIONAL CONSIDERATIONS:
    Comments should also show when configuring alerts

    32 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 →
    completed  ·  AdminCarlos Eriksson (Admin, Red Gate Software) responded

    As of v14.0.23 (September 4th)

    
    

    We have Redesigned of the 'Alert History' and 'Occurrences' tab in the alert details page. This combines them into one tab and allows for easier access to previous comments.

19. 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 →
    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

20. 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 →
    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