756 results found

1. Add filtering to the Top 10 Queries/Waits lists

   So first, this is a request for more general filtering than the 2 requests I see already exist for filtering by database (which I believe you can get to by clicking the database name further down the page, but would certainly be more convenient on the top 10 lists directly).

   The primary use case that I was looking to do but couldn't was sort by averages, but set a minimum execution count. The goal being to find my worst queries that are not just one off things that aren't likely to be repeated. I think there would be a LOT of value in also having it filter on the query text, but that is certainly a much more painful query to run and so may not be feasible.

   So first, this is a request for more general filtering than the 2 requests I see already exist for filtering by database (which I believe you can get to by clicking the database name further down the page, but would certainly be more convenient on the top 10 lists directly).

   The primary use case that I was looking to do but couldn't was sort by averages, but set a minimum execution count. The goal being to find my worst queries that are not just one off things that aren't likely to be repeated. I think there would be a LOT… more

   9 votes

   Vote 0 votes 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

   Submit Rating

2. Long-Running Query Alert - Occurrences tab to refer only to instances of that query

   In the long running query alert, the occurrence tab shows a history of occurrences of the long running query alert. These alerts are the history of any long-running query rather than just the query in the alert

   It would be helpful to be able to see a long running query alert and see just the alerts for that query to be able to quickly understand whether this query is a regular problem, or something new.

   I appreciate it is possible by highlighting the time period in the server overview page, finding the query and then viewing the query history but I feel it would be easier to have the history for just the query in question, in the alert itself

   In the long running query alert, the occurrence tab shows a history of occurrences of the long running query alert. These alerts are the history of any long-running query rather than just the query in the alert

   It would be helpful to be able to see a long running query alert and see just the alerts for that query to be able to quickly understand whether this query is a regular problem, or something new.

   I appreciate it is possible by highlighting the time period in the server overview page, finding the query and then viewing the query history but… more

   4 votes

   Vote 0 votes 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

   Submit Rating

3. Create a threshold for how many times a job can fail before raising an alert.

   We have jobs that fire every minute, or every 5 minutes - similar to heartbeat jobs. If the job fails once or twice, we don't care. If it fails 10 times in a row we do care.

   21 votes

   Vote 0 votes 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

   Submit Rating

4. Make it possible to mark a query to be tracked from the database menu

   On the "Top queries" within the database menu, we can only "View estimated plan" and "Copy query text".

   It would be handy to have here the "Track query" option too.

   Nowadays, if I find it here, I need to filter on the top and only then I can "Track query"

   •  

   3 votes

   Vote 0 votes 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

   Submit Rating

5. email and pager alert when redgate status is suspended

   I would like to receive alert email and pager alert when sql instance is in suspended state. Alert should be received periodically till it is resumed. Currently no alert even though instane is in this state for ever. Powershell script is there to check status but to run this script port 8080 to be enabled and we cant run script on sql server to integrate with email/pager through job because port will be blocked on sql. Alternatively if you can provide table to check status of suspended instance on redgate db instance we can also configure alert by checking this table?I would like to receive alert email and pager alert when sql instance is in suspended state. Alert should be received periodically till it is resumed. Currently no alert even though instane is in this state for ever. Powershell script is there to check status but to run this script port 8080 to be enabled and we cant run script on sql server to integrate with email/pager through job because port will be blocked on sql. Alternatively if you can provide table to check status of suspended instance on redgate db instance we can also configure alert by checking this table?

   I would like to receive alert email and pager alert when sql instance is in suspended state. Alert should be received periodically till it is resumed. Currently no alert even though instane is in this state for ever. Powershell script is there to check status but to run this script port 8080 to be enabled and we cant run script on sql server to integrate with email/pager through job because port will be blocked on sql. Alternatively if you can provide table to check status of suspended instance on redgate db instance we can also configure alert by checking this… more

   3 votes

   Vote 0 votes 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  ·  Edit…  ·  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

   Submit Rating

6. Add custom banner to the logon page

   Basic authentication is sufficient for simple installations for few users. But security recommendations require a custom banner be displayed at the logon page. It will be nice if Redgate Monitor can do that without using OpenID or other external authentication methods.

   1 vote

   Vote 0 votes 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  ·  Edit…  ·  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

   Submit Rating

7. Filter out Long Running Query alerts based on wait type

   We have a 3rd party product that has a SQL Database. It has something in it that loads data RBAR (Row-By-Agonising-Row). The query gets all the data in about 3 seconds and then sits waiting on ASYNCNETWORKIO for ages (close to 40 minutes).

   We don't want to exclude the application from all long running query alerts, and the query is different everytime which would make it hard to filter based on regex (and not filter other queries we care about).

   We'd like a way that we can not raise a long running query alert if it's waiting on ASYNCNETWORKIO

   We have a 3rd party product that has a SQL Database. It has something in it that loads data RBAR (Row-By-Agonising-Row). The query gets all the data in about 3 seconds and then sits waiting on ASYNCNETWORKIO for ages (close to 40 minutes).

   We don't want to exclude the application from all long running query alerts, and the query is different everytime which would make it hard to filter based on regex (and not filter other queries we care about).

   We'd like a way that we can not raise a long running query alert if it's waiting on… more

   11 votes

   Vote 0 votes 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

   Submit Rating

8. Show prefered/active node on cluster

   When runnning a database instance on a cluster it would be helpful if you could see on which phusical machine (node) the database instance is active on. It would be very usefull if that information was shown on the global overview page.

   8 votes

   Vote 0 votes 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…)
   7 comments  ·  Delete…  ·  Admin →
   completed  ·  Daniel Rothig responded

   This can be seen on the Cluster overview page, in the instances grid – activeness and preferredness differ per FCI

9. Add the ability to optionally fire a data gathering query if an alert fires

   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
   INTO #SuspiciousErrors
   FROM sys.dmxesessiontargets xet
   JOIN sys.dmxesessions xes ON xes.address=xet.eventsessionaddress
   WHERE xes.name='MonitorSuspiciousErrors'
   AND xet.targetname ='ringbuffer';

   SELECT
   dateadd(mi,datediff(mi,getutcdate(),getdate()),xed.eventdata.value('(@timestamp)[1]','datetime2'))AS EventTime
   , xed.eventdata.value('(data[@name="errornumber"]/value)[1]','int')AS ErrorNum
   , xed.eventdata.value('(data[@name="message"]/value)[1]','varchar(400)')AS ErrorMessage
   , xed.eventdata.value('(action[@name="username"]/value)[1]','varchar(400)')AS UserName
   , xed.eventdata.value('(action[@name="ntusername"]/value)[1]','varchar(400)')AS NTUserName
   , xed.eventdata.value('(action[@name="databasename"]/value)[1]','varchar(400)')AS DatabaseName
   , xed.eventdata.value('(action[@name="sqltext"]/value)[1]','nvarchar(max)')AS sqlText
   , xed.eventdata.value('(action[@name="clientappname"]/value)[1]','nvarchar(125)')AS sqlText
   FROM #SuspiciousErrors
   CROSSAPPLY targetdata.nodes('//RingBufferTarget/event') AS xed(eventdata)
   WHEREDateDiff
   (MINUTE,Convert
   (DATETIME2,
   SwitchOffset(
   Convert(DATETIMEOFFSET,xed.event_data.value('(@timestamp)[1]','datetime2')
   ),
   DateName(TzOffset,SysDateTimeOffset())
   )
   ),
   GetDate()
   )<20;

   DROPTABLE #SuspiciousErrors;

   It would be great if there was a way to capture actual data supporting the alert trigger so that it could be viewed with the alert details. There are a myriad of other alerts (alerts firing off the default trace (e.g. failed logins), alerts that could be triggered from the system_health extended event (e.g. tempdb contention)…).

   With an optional secondary data gathering option, proper details can be included with the alert in instances like the above.

   Even listing examples would be helpful for something like this where users may not be good (like myself) at shredding or able to shred XML.

   You do this for some alerts.

   https://sqlmonitormetrics.red-gate.com/monitor-tempdb-contention/
   &
   https://www.red-gate.com/hub/product-learning/sql-monitor/monitoring-tempdb-contention-using-extended-events-and-sql-monitor

   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
   INTO #SuspiciousErrors
   FROM sys.dmxesessiontargets xet
   JOIN sys.dmxesessions xes ON xes.address=xet.eventsessionaddress
   WHERE xes.name='MonitorSuspiciousErrors'
   AND xet.targetname ='ringbuffer';

   SELECT
   dateadd(mi,datediff(mi,getutcdate(),getdate()),xed.eventdata.value('(@timestamp)[1]','datetime2'))AS EventTime
   , xed.eventdata.value('(data[@name="error… more

   2 votes

   Vote 0 votes 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  ·  Edit…  ·  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

   Submit Rating

10. Webhook notifications need to be configurable at an alert level

    While Webhook notifications is a cute idea, it has no value to me if I can't customize what alerts get it. Please add a Webhooks column to the individual alert settings.

    20 votes

    Vote 0 votes 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

    As of SQL Monitor 11.1.8 Webhook notifications can now be enabled and disabled for alert types.

    This can be done within the alert settings page for each alert type (see screenshot).

11. To have more granular filter options for historical query investigation

    After selecting an instance from the main Overview screen and scrolling down to the bottom to select a specific database, I would like Redgate Monitor to be able to:

    1) Provide the option to filter further to the database schema if desired.
    2) Irrespective of what is selected above, see at least the top 100 Maximum Results in the small drop-down box instead of being limited to 50.
    3) Irrespective of what is selected above, see more information about the originator of the query - i.e. user, login, application, host name etc.

    1 vote

    Vote 0 votes 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  ·  Edit…  ·  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

    Submit Rating

12. Add alias to rest api

    The rest endpoint api/v1/monitored-entities should include the alias field. It would present as an empty string if the monitored entity does not have as an alias and filled in if an alias has assigned to the monitored object.

    7 votes

    Vote 0 votes 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

    Submit Rating

13. Blocking Process Alert to be based on Blocking Time

    This idea has been posted before but marked as closed, so posting again. For blocking process alert, it would be good to have the option to setup the alert in a way where we can report on the duration when the first and last blocking happened and if it exceeds a certain threshold. 

    Let's say, we have set the threshold for 90 seconds and if there are three processes that have wait time of 30 seconds each, that totals to 90 seconds, we receive an alert. However, we don’t want to receive an alert for the 30 second blocked processes. We only want to receive the alert if the max duration of blocking exceeds 90 seconds on any one of the descendants.

    This idea has been posted before but marked as closed, so posting again. For blocking process alert, it would be good to have the option to setup the alert in a way where we can report on the duration when the first and last blocking happened and if it exceeds a certain threshold. 

    Let's say, we have set the threshold for 90 seconds and if there are three processes that have wait time of 30 seconds each, that totals to 90 seconds, we receive an alert. However, we don’t want to receive an alert for the 30 second blocked processes.… more

    24 votes

    Vote 0 votes 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

    Submit Rating

14. Analysis Graph Tab

    This is about the Statistics for the Disk avg. read and write metrics.

    There are times when based on the results for a server the statistics are presented in seconds. More often than not it will be 0.0, 0.2 sec, etc.
    
    This is not very helpful, and I often find myself having to download the Export (csv) and get the average.

    It would be much more beneficial to just show all results in milliseconds, or present an option to the end user of seeing ms or seconds.

    Thank you

    • 

    3 votes

    Vote 0 votes 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…)
    3 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

    Submit Rating

15. Make reports from database extended properties and sort it by database name for CMDB purpose

    Make reports from database extended properties and sort it by database name for CMDB purpose

    1 vote

    Vote 0 votes 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  ·  Edit…  ·  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

    Submit Rating

16. I would like to configure different gMSA accounts as credentials for different servers

    I would like to use the more secure gMSA accounts when configuring credentials for servers that are monitored and use different gMSA accounts for different servers

    1 vote

    Vote 0 votes 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  ·  Edit…  ·  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

    Submit Rating

17. Being able to set alerts based on existing KPIs (Analysis Graph) instead of create a new custom metric

    If I want to create an alert based on some existing KPIs, I need to write the query and can't leverage the existing one.

    Example:
    I want to create an alert when the "Tempdb: Free bytes" is lower than X.
    I can't use the existing "SQL Server metrics" that contain this KPI.
    Instead, I need to create a new custom metric and build the query. (which in the end it will be exactly the same). Only after that I can create an alert.

    2 votes

    Vote 0 votes 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  ·  Edit…  ·  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

    Submit Rating

18. See last backup of each type in Overview page

    Currently the backup section in a database on the overview page shows the backups that happened in the selected range, and it only shows the last backup of each type that happens. We have a database that does full backups once a week and then differentials.

    It would be helpful at a glance to see the status of the last backup of each type regardless of if it happened in the time window or not. Maybe hide the last differential if it happened before the last full.

    6 votes

    Vote 0 votes 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

    We have redesigned the Backups information to more clearly show the selected range it refers to, and also show when the last backups occurred prior to that. This can be seen in the latest version (8.0.25)

    We hope this improvement completes the suggestion and will mark it as completed. Do let us know if you have any further feedback

19. Customise Email Settings For Each Alert Setting

    It would be great if you could have an override on each alert to allow for a customised email setting just for that alert.
    Currently an alert can have a different email address BUT it only uses the default settings, if I wanted to fine tune for that alert I can't.
    Thanks, Steve

    19 votes

    Vote 0 votes 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…)
    5 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

    Submit Rating

20. Slack notification in more detailed

    Slack notifies the alert, would be great to view complete details in slack specific to notified. This helps giving access to development for a slack channel to look into Long Running Query corresponding to database. without giving full access

    9 votes

    Vote 0 votes 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

    Submit Rating