Category Archives: Plan Guides

Creating a plan guide

I initially had lots of trouble creating my first plan guide. There are some strict rules to getting them to work, but when they do, it’s magical. Plan guides are unique to a database – you need to make sure … Continue reading

Posted in Plan Guides | Comments Off on Creating a plan guide

Cleaning up old single use plans

After identifying the queries for which we want to create a plan guide, we could just leave it there and the old plans will age out naturally or we could clean them out ourselves. The command to clean out the … Continue reading

Posted in Plan Guides | Comments Off on Cleaning up old single use plans

Creating a Plan Guide

One day while looking at the cache usage on a particular server, I was surprised at the size of the procedure cache. Looking closely, there were a large number of single use plans in the cache. I looked at the … Continue reading

Posted in Plan Guides | Comments Off on Creating a Plan Guide