Activity overview
Latest activity by JohanN
The Exlude processes option has been very helpful in many cases but not in all. Some of the jobs have process names like "Microsoft SQL Server Management Studio" which would filter out too many long running queries.
The maintenance window option can help me filter out jobs that i know will be run under certain timepriods.
/Johan / comments
The Exlude processes option has been very helpful in many cases but not in all. Some of the jobs have process names like "Microsoft SQL Server Management Studio" which would filter out too many lon...
Suggestion - Read Only User
Hi
at our department we have some screens setup that shows various dashboards for monitoring differnet systems and SQL Monitor is one of them.
the potential problem is that our office is visited by...
Suggestions alert filtering
Hi
I´m currently working on tuning my alerts so that I don't have to deal with a lot of repetitive alerts every morning.
For example I have a lot of long-running-queries alerts from my nightly sche...
Job duration unusual
Hi
It seems to me that this alert sometimes is raised when it shouldn't
I've set this alert to be ignored if run less than 60 seconds.
My settings are as follows:
Alert Threshold:
Raise this alert ...
Ok
If you put in the feature Exclusion by process name in version 2.1 I will be very happy, thats the feature I'm looking for. Filtering by query text will not help me in this particular case because the nightly jobs are executing some SELECT:s against an order and orderrows table
/Johan / comments
Ok
If you put in the feature Exclusion by process name in version 2.1 I will be very happy, thats the feature I'm looking for. Filtering by query text will not help me in this particular case becau...
Hi
That doesnt really help. The advanced filter you're mentioning is for display purposes only and I need a way of telling SQL Monitor that I do not want any alerts to be raised if the SQL process is a certain user or if the process i s run certain times.
As it is now Now there will be alerts every night when my dataextraction jobs are run and my email inbox is filled with alerts every morning.
I want to be able to tune SQL Monitor so it does not raise any alerts I'm not interested in and i think I would need some new filtering parameters to set under Alert Settings for Long Running Jobs (i.e the possibilty to exlude certain processes/users from the alert, maybe to disable the alert when the scheduled jobs are run).
/Johan / comments
Hi
That doesnt really help. The advanced filter you're mentioning is for display purposes only and I need a way of telling SQL Monitor that I do not want any alerts to be raised if the SQL process ...
Configure Emailing alerts
Is it possible to configure the alerts to only send an email when it has reached the Status high? Certain alerts is interesting to see in the dashboard but they are not so important that I would li...
Alert Filtering
Hi
Is there a way to filter an alert based on the process or the time? At nights I have som jobs that does som ETL processing that takes time, and it should take some time. The job accesses certain...