Skip to content

Adam

← Redgate Monitor

My feedback

17 results found

  1. Force re-check of index fragmentation alert

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Hi Hugo

    If you open the config file in %programdata%\red gate\sql monitor\RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config near the bottom you will see this:

    <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[Table].[Index]">
    <weeklySchedule dayOfWeek="Sunday" hour="1" minute="00" />
    </schedule>

    The second line determines when the index fragmentation check runs and can be changed, the comments above it in the file explain the options.

    Once that has been edited, restart the Base Monitor.

    I hope that helps.

  2. Make alert configuration levels more discoverable

    176 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    42 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Thanks for this suggestion, and for the supporting comments.

    Regarding the comments around excluding alerts using regex, several alerts now allow you to enter regular expressions to match text you want to ignore, to stop alerts being raised in certain situations.

    For example:
    - Deadlock (XE) alerts can be filtered by database, login name & resource (added in version 8.0.22 released November 13th 2018)
    - Blocking Process alert can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions
    - Job Duration Unusual alerts can exclude jobs matching regular expressions
    - Long Running Query alerts can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions

    We will keep this topic open as we are soon hoping to address the main suggestion - making alert configuration levels more discoverable - along with other improvements to alert configuration.

    Thanks

    An error occurred while saving the comment
    Adam commented  · 

    Thanks for your suggestion Robert. We've logged this as SRP-6766

    An error occurred while saving the comment
    Adam commented  · 

    Thanks for the suggestion. You are currently able to exclude, for example, a DB from triggering a Backup Overdue alert (Configuration > Alert settings then select Machine, Server or DB in LH tree and select Configure Alerts) , but improving and extending this configurability as you suggest would be useful. We'll post back when we have any updates...

  3. Analysis Graph Tab

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Thanks - we've now merged the duplicate suggestion.

  4. be able to customize email and Slack notifications

    44 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Hi,

    This is an area we are looking to improve - could you give a bit more detail about the kind of customisation you would find useful?

    Thanks,
    Adam

  5. Is it possible to have long running queries order by Execution time desc ?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Hi Darshan,

    Thanks for your suggestion. I'd really appreciate understanding a bit more about how you might find this useful, what you would be trying to achieve? This will help us understand how we could improve the long running queries feature.

    Thanks,
    Adam

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

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Adding another suggestion relating to this:

    "The wait resource or even better the object_name if applicable would be great to get in the Blocking Processes (Top 10 by Time) visualisation.

  7. Ability to change the width of list of metrics at analysis page

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Hi Blaž - the changing width is a bug, so thanks for bringing it to our attention. The improvement we intended was to increase but fix the column width. We'll take a look at fixing this.

    Thanks,
    Adam

  8. Specify a "details" query for custom metric

    73 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Thanks for your suggestion - I think this is related to another suggestion so am merging the two so votes will be added - I hope that makes sense.

    Thanks
    Adam

  9. 产品建议

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Google translate:

    1. The interface displays the server information indicators can increase the customization feature that allows users to choose the main panel to display the mysterious key performance indicators

    - I think this is a request for something like a customisable dashboard?

    2. Alert messages sent when the increase in different databases can be sent to different administrator mailbox

    - It is possible to configure SQL Monitor to use a different recipient for an alert on a particular server (but not currently for different severities of alert)

  10. Drill-down from Analysis Charts to Back in Time Mode overview for a given data point

    62 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    The new server overviews in v.6 now allow you to focus on spikes in the main graph and see all the other metrics, including queries and processes, at that time. We've also added alerts to the timeline so you can see what alert activity was taking place at that time.

    We welcome any further suggestions for improving the workflow, although this is now slightly off-topic from the original post so it could be useful to break further ideas into separate suggestions.

    As for the ability to drill-down from Analysis charts to server overviews for a given data point, this is something we do think would be useful too and will hope to address.

    Thanks,
    Adam

    An error occurred while saving the comment
    Adam commented  · 

    We're currently making improvements to the Analysis page (e.g. http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/1891823-select-multiple-counters-for-analysis ) and plan further improvements so this is something we will consider.

    Thanks for the suggestion

  11. Select and store a static baseline for future reference

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Hi,

    Thanks for the suggestion. This could be considered as an extension to an existing suggestion - the ability to store a baseline. https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2059115-ability-to-store-a-baseline

    This would allow you to store and manage your baseline, with the ability to include/exclude data from it. If you agree, I will merge your suggestion so that your votes are added to it?

    Thanks again,
    Adam

  12. Monitor an application server

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Thaks for your suggestion. I've logged this as SRP-9224 but would be interested to know a bit more about your requirements, what you would be monitoring and what, other than t-sql, you would like to be able to use to collect the data?

  13. Add other Red Gate tools to SQL Monitor as licensed modules

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Thanks for your suggestion John.

    We are working to integrate our tools along these lines so it's very useful to hear how this could work for you. It would be great to discuss this further - drop me a line at adam.walker@red-gate.com if you'd be happy to continue the conversation.

    Thanks again for your feedback,
    Adam

  14. Add an option to schedule when custom metrics run against a given database.

    54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    12 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Adam commented  · 

    Hi Matt,

    We have considered scheduling for custom metrics, so it's interesting to see your example of how it would be useful for you. We'll keep an eye out for further comments around this.

    Thanks for your suggestion,
    Adam

  15. Use extended events instead of trace when trace initialized due to alert

    98 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Daniel Rothig responded

    Thanks for the suggestion – we’ll monitor how popular it gets

    An error occurred while saving the comment
    Adam commented  · 

    This does sound useful and has been mentioned to us before - it's logged as SRP-17

    Thanks for the suggestion.

  16. Search through (closed) alerts for a string.

    69 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    13 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Daniel Rothig responded

    We’re looking into this – no ETA at the moment

    An error occurred while saving the comment
    Adam commented  · 

    Hi Kenny,

    Thanks for the suggestion. I've raised this enhancement as SRP-5842. We'd like to improve the alert filtering so we'll certainly consider this.

    Thanks
    Adam

  17. Add additional perfmon counters

    65 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    7 comments  ·  Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Daniel Rothig responded

    For SQL Server perf counters, you can create a Custom Metric against sys.dm_os_performance_counters. For Machine perf counters, you have to use CLI at the moment

    An error occurred while saving the comment
    Adam commented  · 

    Hi Joe,

    Thanks for your suggestion. We agree this would be beneficial and it is something we've considered and will take a look at again. For the record, I've added your comment to issue SRP-305.

    Thanks again for the feedback.

Feedback and Knowledge Base

(thinking…)