Tag: plan-cache

Found 32 results for 'plan-cache'.

1) sql-server - How to regenerate execution plans after clearing the plan cache?
2) sql-server - Why are the majority of cached plans missing from sys.dm_exec_query_stats?
3) sql-server-2016 - Measuring plan eviction
4) sql-server - Redundant plans in cache because of missing type length
5) sql-server - Would it be better for query plans to be split by statement for re-usability?
6) sql-server - Query plan cache bloated by ad-hoc queries, even with "Optimize for Ad-hoc Workloads"
7) sql-server - Is execution plan cached “better” for stored procedures than for a non-dynamic query?
8) sql-server - Why query cache plan kept dynamic queries but not sp?
9) sql-server-2016 - Why get queryplans recompiled every minute
10) sql-server - how to query the plan cache to find how healthy it is?
11) sql-server - Optimize for ad-hoc workload
12) sql-server - Query plan deleted
13) sql-server - SQL Server 2016 All Queries recompile all the time (plan cache corruption?)
14) sql-server - Plan cache size and reserved memory
15) sql-server - SQL Server Plan cache size only 4GB on a server with 500GB RAM
16) sql-server - Identifying Execution Plans with Probe Residual
17) sql-server - How does SQL Server determine how much memory to allocate to Data cache
18) sql-server - sp_Blitzcache doesn't return as many results as sys.dm_exec_query_stats for a given query
19) sql-server - Does "Table Valued Function" force the plan to get into cache?
20) sql-server - Missing execution plans for stored procedures
21) sql-server - Why does the plan cache contain estimated and not actual execution plans?
22) postgresql - Prepare statements plan invalidation in postgresql
23) sql-server - What are the SET options that affect Plan Reuse and how to get their values in T-SQL?
24) sql-server - Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)?
25) sql-server - How can you have a Buffer cache hit ratio of 100% with PLE of 103?
26) sql-server - Why is parallelism not good in this query?
27) sql-server - How to query cached plans that contain a specific missing index?
28) tempdb - Why does FREEPROCCACHE let you shrink tempdb?
29) sql-server - Resolving sp_Blitz Finding: Many Plans for One Query
30) sql-server - Execution Plan Warnings cardinality xml data type
31) sql-server - Field = Parameter OR Parameter IS NULL Pattern
32) sql-server - SQL Server cached an execution plan which is not optimal in some cases and uses it for all consequent queries