Principals with sysadmin login

VN:RO [1.9.17_1161]
Rating: 3.8/5 (5 votes cast)
5
27,842 0 ,
This metric counts the number of principals who are members of the sysadmin fixed server role. Adding a normal user to this role could pose a security risk and is not recommended. Read more

Untrusted foreign keys

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
9,169 0
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

Disabled replication jobs

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
7,151 0 ,
This metric investigates replication jobs, searching for any that may be disabled inappropriately. If any of your replication jobs have been disabled inappropriately, you may not be aware of their state. Read more

Disabled backup jobs

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
5,033 0
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

Percentage of fragmented indexes

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
18,024 0 ,
This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If multiple indexes are fragmented throughout the database, then an index maintenance strategy needs to be evaluated. Read more

Number of unused indexes

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
11,972 0
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