Register for My Free Session on Execution Plan Forcing
Category:
query-performance
I am excited to be giving a free online session as part of the Idera Live Virtual Conference, 2018!
Tag: query-store
Why Is My Function Missing From sys.dm_exec_query_stats and Query Store?
I just spent 90 minutes of my life figuring out a detail about sys.dm_exec_query_stats which I’m pretty sure I figured out five years ago, but didn’t write a blog post about.
Time to write a blog post, so I can save time when I go searching for this in a couple years.
EstimateRowsWithoutRowGoal helps you see: is it a statistics problem?
Category:
query-performance
, sql-server
SQL Server Management Studio version 17.5 adds a welcome feature for execution plans: a new visual attribute named EstimateRowsWithoutRowGoal.
Forced Plan Confusion: Is_Forced vs Use Plan = True
Category:
query-performance
, sql-server
Identifying that a query plan has been bossed around in Query Store can be a bit tricky, because it can appear in different ways.
Can I Force Multiple Plans for a Query in Query Store?
Category:
query-performance
Nope.
At least, not right now.
Auto-Tuning and the #1 Mindset Problem I Had as a DBA
Category:
query-performance
, sql-server
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why I’m excited about those features rather than afraid of them.
Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.
How to Find Queries Using an Index (and Queries Using Index Hints)
Category:
query-performance
Sometimes you know a query is out there, but it’s hard to find the exact query.
SQL Server stores query execution plans in cache, but it can be difficult to query the XML it stores. And there’s always a chance that the query plan won’t be there, due to memory pressure, recompile hints, or the plan cache being cleared by setting changes or other administrative actions.