Adam

My feedback

  1. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Adam commented  · 

    Thanks for your suggestion Brett,

    We agree that the existing metric selector is not scaling well to the introduction of more metrics. I've raised an enhancement so we can try to address this soon, and will update this when we have a solution so we can get your early feedback.

  3. 113 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Adam commented  · 

    Thanks Blaž, that makes sense - I'll merge the suggestions and discuss this with the team

  4. 167 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    40 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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...

  5. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Adam commented  · 

    Thanks - we've now merged the duplicate suggestion.

  6. 37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  7. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  8. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Adam commented  · 

    Thanks for the suggestion. We'd be interested to understand a bit more about why this would be useful for you, what you're trying to achieve, so we can consider the context.

    Thanks,
    Adam

  9. 79 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Adam responded

    We were initially a bit sceptical about this, reasoning that if your monitoring solution becomes an active part of the system, it’s no longer a monitoring solution but part of the infrastructure that needs to be monitored.

    However, our thinking in this area has evolved and we can see there are a number of scenarios where it would be useful for alerts to trigger an additional action, and where potential risks are nevertheless manageable.

    If you’d like to help us understand more about the kind of things this might help achieve, please email sqlmonitorfeedback@red-gate.com and we’ll get back to you.

    An error occurred while saving the comment
    Adam commented  · 

    Hi Alex,

    Thanks for your comment. Our thoughts in this area have evolved and we can see there are a number of scenarios where it would be useful for alerts to trigger an additional action, and where potential risks are nevertheless manageable.

    If you'd be willing to help us understand a bit more about the kind of things you might be trying to achieve, please drop an email to sqlmonitorfeedback@red-gate.com and we'll get back to you to discuss it further.

    An error occurred while saving the comment
    Adam commented  · 

    Thanks for your suggestion Tim

  10. 23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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.

  11. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  12. 49 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  13. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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)

  14. 61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  15. 40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  16. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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?

  17. 11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  18. 42 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  19. 88 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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.

  20. 61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    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

← Previous 1

Feedback and Knowledge Base