Speaking at Performance Virtual Chapter
Have, you noticed an important query suddenly takes longer to run? Have you noticed the execution plan looks completely different than what you normally expect for your query? Today, I talked at the Performance Virtual Chapter going over how to identify plans that change and went over options to fix them in SQL Server 2005 to 2016 by forcing plans.
Where is the Code?
As promised, the demo code is attached here.
How Can Query Store Get Better?
I would love to see Query Store have the ability to capture statistics for AG Secondaries that are enabled for read traffic. A bonus, would be the ability to force plans for AG Secondaries as well.
Being that today is my birthday I thought I would share a nice gift to everyone who follows my blog. Below is a free link to a recorded video of one of my latest presentations that goes over multiple SQL Server developer anti-patterns I see repeated over and over again in the field. Most of these are patterns that any IT professionals can identify and fix just by identifying the pattern and changing the pattern to another one shown in the video that is optimizer friendly. I promise no brain surgery is required 😉
Make Your SQL Server Queries Go Faster
I hope you enjoy the hour long video on making your SQL Server queries go faster!
If you want to play along feel free to download the sample scripts. If you want to learn more about being a proactive performance tuner check out my root cause performance analysis blog series which includes my What Is Running Script, Disk Latency, Wait Stats monitor processes and more..
Recently, I gave my first presentation of the year at Austin .NET User Group on Writing Faster Queries and I got a great question about Extended Events. The question was, “What security permissions are required for creating and modifying Extended Event Sessions?” I thought it would make a great blog post as I am sure others might be wondering the same thing.
In SQL Server 2008 to create an Extended Event Session you are going to need CONTROL SERVER and ALTER ANY EVENT SESSION permission on the instance that you need Extended Events created on. With SQL Server 2012 and 2014 If you want to create and modify Extended Events you are only going to need ALTER ANY EVENT SESSION.
If you like this post check out these other related blog posts: