721 results found

1. Be able to schedule a maintenance window with the possibility to use an offset.

   Be able to schedule a maintenance window with the possibility to use an offset. Say every 3rd tuesday of the month + 12 days.

   5 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

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

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

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Summary alert page ordered by active alert type with drill down to detail

   In the previous red gate alert program it had a summary by each alert giving a quantity for the selected monitor period and one could then drill down to the detail for that specific alert in chronological order starting with the most recent - found this most useful - also gave a simple measure of occurrences over time which one could use to track the effectiveness of efficiency projects

   2 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 the suggestion – we believe this has been addressed with the Grouped Alerts released in Version 7.1.18.

   We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.

   Kind regards,
   Adam
   SQL Monitor Development Team

3. Re-fire alert notification if alert stays active

   My initial problem was that an alert that was still active was marked as cleared, but I wanted the alert to 're-appear' as essentially it hadn't been fixed.

   This then led me to thinking about any alerts that can move from Active to Ended. It would be useful to configure these is such a way that if they stay Active for a given period, then they re-fire. I understand that is what the multiple thresholds can be used for (especially if the thresholds define time periods) but in this case I may already be at High, there is no further threshold to hit, and I still want to be notified.

   My initial problem was that an alert that was still active was marked as cleared, but I wanted the alert to 're-appear' as essentially it hadn't been fixed.

   This then led me to thinking about any alerts that can move from Active to Ended. It would be useful to configure these is such a way that if they stay Active for a given period, then they re-fire. I understand that is what the multiple thresholds can be used for (especially if the thresholds define time periods) but in this case I may already be at High, there is no further… more

   34 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

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

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

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

4. is there fix in the works for IE10?

   In order to see almost anything, need to put browser into IE9 compatibility and some features still not showing like current server stats

   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

   The update has now been released. SQL Monitor will display a message above the product name banner when it next checks for updates.

   Alternatively, you can get it direct from http://www.red-gate.com/dynamic/products/dba/sql-monitor/download then click the ‘Returning customer installer download’ link on right.

   Please let us know if this doesn’t fix the issue for you.

   Thanks
   SQL Monitor Development Team

5. Reduce the suggestions on how to fix queries when viewing Top 10 Queries

   SQL Monitor pops up the text "x issues with this query". Addressing them could improve performance. It then lists some things that might have an impact (e.g. select * instead of listing just the columns that are required) but also lists other things that won't change performance (e.g. not specifying a schema name).

   Can this list be reduced to just what is potentially performance related? Maybe have a 2nd field for best practices if that's considered improtant.

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

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

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

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. deadlock Detailed Report

   Please create a detailed deadlock report.
   In addition to the existing DeadLock summary report, can you please create a DeadLock Detailed report for all deadlocks for a given time range.
   Looking for a DETAILED report of deadlocks (all deadlocks for the time range) that will include:
   1. Date / Time of the event
   2. Blocking SPID and full query text
   3. Duration of the block
   3. All Child or deadlock victim SPID and full query text of the victim
   Similar to the summary report, will need to be able to select the SQL server instance and / or database to report on.
   Please consider creating as a CSV or Excel output with columns:
   Date/Time,SQL Instance,Blocker/Victim flag,Duration,SPID,Query Text

   Please create a detailed deadlock report.
   In addition to the existing DeadLock summary report, can you please create a DeadLock Detailed report for all deadlocks for a given time range.
   Looking for a DETAILED report of deadlocks (all deadlocks for the time range) that will include:
   1. Date / Time of the event
   2. Blocking SPID and full query text
   3. Duration of the block
   3. All Child or deadlock victim SPID and full query text of the victim
   Similar to the summary report, will need to be able to select the SQL server instance and / or database to… 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…)
   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. Ability to filter "TOP Queries" by login

   Often we want to filter queries not only per existing options (database, parent or query) but it's useful to be able to search for a specific login.

   Could you allow searching by login using "l:" or "login:"?

   11 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

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

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

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

8. I wish the blocking Process report included the resource the Blocked processes are waiting on.

   My Dev write 500+ line procedures and functions so the SQL "Fragment" is seldom very helpful.
   It would be much more helpful to identify the resources the processes are blocked on. Even just the waitresource and waittype columns from sys.dmexecrequests would help.

   I know some of the resource types are tough to parse in T-SQL.

   27 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…)
   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. 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 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. Add "not started within X minutes" delay before SQL Agent status alert raised

    In an unpredictable maintenance window environment, as in, SQL Monitor's abilities in the window setting arena are inadequate, there are a reasonable number of times when SQL Agent is restarted with good reason.

    As alerts are tied to pagerduty, it's a one size fits all Alert at present, which isn't helpful.

    If a "delay emitting Alert for X time periods" could be added to this Alert, the short-duration bounces will go un-alerted, which really helps on call personnel to avoid unnecessary awakenings for "it is of no matter" Alerts.

    In my case, there are 24 recorded incidents of this Alert, absolutely none of which required DBA intervention. Most of these ended in under 10 minutes. All ended under 30 minutes.

    A 3-stage low, medium, high, with override email address allocation AT EACH LEVEL, would be ideal. For low, I can nudge just the DBA Team, for Medium, if 10 minutes, I can nudge again, but for > 30 minutes, PagerDuty.

    In an unpredictable maintenance window environment, as in, SQL Monitor's abilities in the window setting arena are inadequate, there are a reasonable number of times when SQL Agent is restarted with good reason.

    As alerts are tied to pagerduty, it's a one size fits all Alert at present, which isn't helpful.

    If a "delay emitting Alert for X time periods" could be added to this Alert, the short-duration bounces will go un-alerted, which really helps on call personnel to avoid unnecessary awakenings for "it is of no matter" Alerts.

    In my case, there are 24 recorded incidents of this… more

    9 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

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

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

11. Search for SPID for specific Date and Time

    I would be a good idea to have a functionality in SQL Monitor to search for SPID for specific Date and time. This will help us to review what query run by who on given date and time.

    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…)
    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. on the overview, monitored instances be able to choose which groups to show

    It is possible to choose one or all groups on the monitored instances overview. I would like to be able to select more than one group to show or deselect some groups that I do not want to see.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  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. Allow nested groups on the Overview screen

    I have a structure of groups where the first level is environment (Production, Test, Development, etc) but then I have component as a second level (ETL, Application, Data QA, Sandbox). On the Overview screen, only the first level of the grouping is used, and therefore I have servers under 'Production' all bundled together and ordered by name across all the secondary groups. Would be good if the overview screen could show multiple groups somehow ... I understand there might be servers under the first level and the second level, and it might be weird for some customers ... but for us, grouping them by that second level would be really to get an understanding of the overall health of an area of our system.

    I have a structure of groups where the first level is environment (Production, Test, Development, etc) but then I have component as a second level (ETL, Application, Data QA, Sandbox). On the Overview screen, only the first level of the grouping is used, and therefore I have servers under 'Production' all bundled together and ordered by name across all the secondary groups. Would be good if the overview screen could show multiple groups somehow ... I understand there might be servers under the first level and the second level, and it might be weird for some customers ...… more

    13 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

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

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

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

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

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

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

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