SELECT Statement executed against Classified table

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
261 0
Uses Server and database audit to track SELECT statements. First Create a Server audit: [crayon-5ba3249aa1576602972839/] Then a database specific Audit based on this server audit: (in this case on the Database: WideworldImporters, schema “Sales” and table: “Customers” [crayon-5ba3249aa157c922520301/] Then setup the custom metric: Read more

Full backup to odd path

VN:RO [1.9.17_1161]
Rating: 4.5/5 (2 votes cast)
2
319 0
This custom metric queries the MSDB database to search for multiple paths for a full backup Read more

Database user added

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
254 0
This custom metric queries the default trace to find events related to whenever a login is added as a database user to a database. Read more

Login added to serverrole

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
257 0
This custom metric queries the default trace to find events related to Server roles being altered Read more

New Server Login Added

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
223 0
This custom metric queries the default trace to find events related to creation of new Server Logins Read more

Failed SQL Server logins

VN:RO [1.9.17_1161]
Rating: 4.2/5 (6 votes cast)
6
21,896 0 ,
This metric returns the number of 'login failed' error messages found in the SQL Server error log file in the last hour. Read more

Current status of mirroring

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
11,871 0 ,
Mirroring systems can go offline. This metric returns the current state of the mirroring system so you’ll know from a single value what the current status of your mirroring environment is. Read more

Schema modified

VN:RO [1.9.17_1161]
Rating: 3.5/5 (2 votes cast)
2
9,005 0 ,
The metric is a necessary step in order to achieve the key purpose of this metric, which is to create an alert that will be raised when something is added to the schema, or the existing schema is modified. Read more