June 25, 2013
by
5 Comments | 5,284 views

VN:RO [1.9.17_1161]

Untrusted check constraints

This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. This can point to a data integrity issue which should be investigated. Read more

June 25, 2013
by
0 comments | 5,006 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

June 5, 2013
by
0 comments | 5,836 views

VN:RO [1.9.17_1161]

Percentage of blocked connections

Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention. Read more