733 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. Grant more granular report level access

   I can grant report level access to a user by adding them to the Reports User role and I can restrict the servers which they see reports for.

   However, this role gives the user more permissions than I would like to give - they can still view any other page - alerts, server overview etc

   Can we change this so they can see the reports only?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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