(to the tune of Winter Wonderland)
Help desk calls, there’s more tickets
Users say, “it’s all broken”
A horrible sight, it happened last night
Tuning with a SQL query plan
[Post-Chorus]
Gone away is the good plan
Here to stay is a new plan
The reports now won’t run, let’s have us some fun
Struggling through a bad query plan
[Verse 1]
In the GUI, we can see the new plan
Thankful we have the query store
They’ll say, “Are you done yet” We’ll say, “No man”
But I’ll let you know after I explore
[Refrain]
O.M.G. did you see that
Look at this, check the wait stats
The plans that were laid, bad choices were made
Struggling with a bad query plan
[Chorus]
Help desk calls, there’s still more tickets
Users say, “it’s still broken”
A terrible plight, what happened last night
Looking for a good query plan
[Post-Chorus]
Gone away is the bad plan
Here to stay is a good plan
The reports should now run, we had us some fun
Forcing now a good query plan
[Verse 2]
In the GUI, we can see the good plan
Since we just used the query store
They’ll say, “Are you done yet” We’ll say, “Yes man”
I set the plan to what it was before
[Refrain]
Later on, we’ll examine
As we look at what happened
Why did it regress, looks like we’ll need to retest
Working with a good query plan (edited)