November 8, 2012
by
0 comments | 3,849 views

VN:RO [1.9.17_1161]

Plan cache hit ratio

A high plan cache hit ratio does not guarantee that all queries are using the cache as well as they might. Knowing the percentage of queries that are satisfied from cache helps you to better understand the plan cache hit ratio value. Read more

November 1, 2012
by
0 comments | 1,532 views

VN:RO [1.9.17_1161]

Plan cache reuse

This metric shows the percentage of cached plans that are being used more than once. If a plan is cached but never reused, there may be an opportunity to tune your server to work more effectively. Read more

July 2, 2012
by
1 Comment | 4,453 views

VN:RO [1.9.17_1161]

Last backup size

Backups are at the heart of the activities of any DBA. You have to restore the backup to know it is good, but you can get an early alert that something is wrong if your backup size changes rapidly or unexpectedly in a short period of time. Read more