One Query Many Plans – SQL in Sixty Seconds #171

Yesterday I wrote a blog post SQL SERVER – Same Result Same Query Plan – Different Entry in Cache, where I had discussed my experience from Comprehensive Database Performance Health Check. After the blog post, lots of people asked me it will be more helpful if I can create a video on the same topic of one query many plans.

As per the request here is the video based on the blog post of One Query Many Plans. Here is the blog post where you can download the query to inspect your cache memory: SQL SERVER – List Query Plan, Cache Size, Text and Execution Count.

Well, that’s it for today. If you liked this video, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Menu
Exit mobile version