753 results found

1. 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

2. Show job name not job ID value for job related alerts

   When viewing SQL Agent job related alerts the identifier is the Id value stored in SQL Server, it would be more useful if this displayed the actual job name.

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

3. option to Enable AI on selected SQL instances and Logging AI activity

   it would be very useful to control which SQL instances have AI enabled. Perhaps an opt out or opt in under Monitored Servers

   Even if data is said not to be sent from prem to LLM, enabling logging of the AI traffic per SQL instance, would go a long way ifor management buy in

   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…)
   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

   Submit Rating

4. 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

5. 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

6. 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

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

8. 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).

9. 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

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

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

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

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

14. 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

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

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

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

18. 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

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

20. allow analysis graphs to update with realtime data without having to manually refresh them

    We have SQLmonitor analysis graphs running on wallboards to show us data that is useful to us, but we continually need to click the button to "jump to present", as the timeline does not update as more data is collected to show the most recent history. We want the graph to move automatically to match the current time of day.
    Maybe a "play" button that would allow thye display to automatically refresh the graph along the timeline and a pause button should you want to drill deeper into a certain time period when investigating issues. Having the graph update automatically to see new data seems like such an obvious request, I can't understand why it's not there already.

    We have SQLmonitor analysis graphs running on wallboards to show us data that is useful to us, but we continually need to click the button to "jump to present", as the timeline does not update as more data is collected to show the most recent history. We want the graph to move automatically to match the current time of day.
    Maybe a "play" button that would allow thye display to automatically refresh the graph along the timeline and a pause button should you want to drill deeper into a certain time period when investigating issues. Having the graph update… more

    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…)
    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

    Submit Rating