Skip to content

Matthew Flatt

← Redgate Monitor

My feedback

4 results found

  1. Force re-check of index fragmentation alert

    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…)
    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
    Matthew Flatt commented  · 

    Hi Hugo,

    Not a solution but it is possible to configure when the index fragmentation check occurs, so it could be moved to after when your weekly maintenance if that might make the alert more useful for the time being?

    Matt

  2. Click to open analysis from alert window

    4 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…)
    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
    Matthew Flatt commented  · 

    Hi Hugo,

    Great suggestion, while it doesn't resolve your exact issue there is a little trick you can use to cut down on the number of steps to get to what you want to see. When in an alert, if you click on the SQL Server tab under Performance data and click one of the metrics there it will take you to the Analysis graph for that metric on the correct server/instance. You can then change to the correct metric and choose the database as well as specifying the time range to look at.

    Matt

  3. Alerts for high virtual log file count

    4 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…)
    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
    Matthew Flatt commented  · 

    Hi, thanks for the suggestion. While this isn't available out of the box, it can be achieved by using a custom metric - I think this one should suit your needs:

    http://sqlmonitormetrics.red-gate.com/excessive-virtual-log-files-in-transaction-log/

  4. Filter Top 10 queries/waits by database

    30 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
    Matthew Flatt commented  · 

    Hi Jeff,

    If you go down to the bottom of the Server Overview in SQL Monitor and click on the database you are interested in, you should get some more database specific information as well as the same Top 10 queries grid from above but filtered by that database.

    Hope that helps!

Feedback and Knowledge Base

(thinking…)