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)
805 reads
Blogs
Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger
By Steve Jones
There is a SET command in SQL Server that changes how much data is...
Secret management using Pulumi ESC SDK and Azure Key Vault
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Forums
The User Login
Comments posted to this topic are about the item The User Login
Using Feature Flags
Comments posted to this topic are about the item Using Feature Flags
Understanding UNION and UNION ALL in SQL Server
Comments posted to this topic are about the item Understanding UNION and UNION ALL...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers