SQL Server Plan Cache Bloat Performance Impacts
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
2024-04-10
plan cache
Checking the Plan Cache Warnings for a SQL Server Database
How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.
2015-03-02
7,649 reads
Find Single use plans in Plan Cache
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
813 reads
Blogs
Prepping for Certification, Part 1 of ?
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
How to Avoid Knowledge Stagnation
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
Forums
just finished a deep dive into snowflake
Sorry, but you do not have permission to view this content.
Database File Growth Report Script
Comments posted to this topic are about the item Database File Growth Report Script
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers