Matthew Flatt
My feedback
4 results found
-
13 votes
An error occurred while saving the comment -
4 votes
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
-
4 votes
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/
-
30 votes
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!
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