June 25, 2013
by
0 comments | 5,263 views

VN:RO [1.9.17_1161]

Untrusted foreign keys

This metric returns the number of foreign keys that have their is_not_trusted flag set to 1 in the sys.foreign_keys table. An untrusted foreign key may threaten a database’s referential and data integrity. Read more

August 2, 2012
by
2 Comments | 2,245 views

VN:RO [1.9.17_1161]

Disabled backup jobs

This metric investigates backup jobs, searching for any that may be disabled inappropriately. If any of your backup jobs have been disabled inappropriately, you may not be aware of their state. Read more

July 4, 2012
by
0 comments | 2,769 views

VN:RO [1.9.17_1161]

Number of unused indexes

Use this metric if you want to monitor the number of indexes per database that haven’t been used for the last month. Indexes that aren’t in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space. Read more