747 results found

1. Current Activity (sp_whoisactive) History

   I would love to see snapshots of current activity (sp_whoisactive) taken on a regular cadence (e.g. every 5 minutes would be very useful for troubleshooting).
   So in the current activity tab I can select a snapshot time from a dropdown of taken snapshot times. Backwards/Forward buttons advancing to the next/previous snapshot would very powerful.

   Having the top queries and waits etc. is super useful, but being able to see a snapshot of the active running queries around an incident would add a lot of value.

   Appreciate that is potentially generating a significant volume of data so appropriate retention/default capture options/server configuration/snapshot frequency would be required.

   I would love to see snapshots of current activity (sp_whoisactive) taken on a regular cadence (e.g. every 5 minutes would be very useful for troubleshooting).
   So in the current activity tab I can select a snapshot time from a dropdown of taken snapshot times. Backwards/Forward buttons advancing to the next/previous snapshot would very powerful.

   Having the top queries and waits etc. is super useful, but being able to see a snapshot of the active running queries around an incident would add a lot of value.

   Appreciate that is potentially generating a significant volume of data so appropriate retention/default capture options/… 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

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

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

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

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

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

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

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

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

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

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

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

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