Finding Job Step Failures

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
121 0
This metric returns a count of the job steps that failed in the latest execution of all jobs on the instance. This should be a calculated measure, where the change is what should alert the DBA. If any step in a job fails in the latest execution, this alert counts those failures and returns a […] Read more

Detecting Connection Timeouts

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
179 0
Connection timeouts can be difficult to troubleshoot. It’s sometimes not even apparent that a timeout has occurred. However, the connectivity_ring_buffer_recorded Extended Event can show that this has happened. This is a debug event within Extended Events, so some caution is necessary in its use. Microsoft can change the debug events without warning. You can use […] Read more

Database Drift – Monitoring Unauthorized Object Changes

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
846 0
This metric identifies when an object has been changed by other than the authorized login. It relies on an Extended Events session to capture the metrics and filters for a specific login. This is a tweak to this custom metric. Here is the necessary Extended Events Session (substitute the appropriate login for the ‘LoginName’ string. […] Read more

Databases at 80% of max file size

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
534 0
This metric tracks the largest file in a database as a percentage of the maximum file size. If there are 3 files, and 2 are at 50% of the max set (max_usage in sys.database_files), and a third is at 60%, the 60% number is returned. Read more

Detect MrbMiner Malware

VN:RO [1.9.17_1161]
Rating: 1.0/5 (1 vote cast)
1
1,393 0
This metric looks for the presence of the MrbMiner malware by checking for an account in sys.sql_logins. Additional information: https://www.zdnet.com/article/new-mrbminer-malware-has-infected-thousands-of-mssql-databases/ Read more

SQL Agent Jobs Owned By The Wrong Person

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
954 0
One or more SQL Agent jobs exist that are not owned by the database owner. You should fix these jobs so that they’re owned by the appropriate person. If the owning account is removed from Active Directory, the job may fail. Read more

Monitor Database Events

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
1,468 0 ,
This metric queries data from an Extended Events session to detect databases being dropped, created, started, stopped, attached or detached. It assigns a configurable “anxiety index” value (an integer from 1-10) to each detected event and then calculates a total based on the occurrences of these events over a period. First, create and start for […] Read more