I can Clear Plan Cache for the current database through database-scoped configuration. I verify the context before considering eviction.
How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121
Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.
Grouping by query_hash to Find Cheap Queries That Cost the Most
Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
Recovering Unsaved Query Windows After SSMS Closes Unexpectedly
A restart ate your script, but maybe not all of it. Two places to look: SSMS recovery files and the text SQL Server remembers.
Rarely Run Queries in SQL Server: What the First Run Pays
Rarely run queries start with a plan that has left the cache. This test compiles a five table report procedure and measures the compile CPU on the first run, the second run, and a run after the cache was cleared. It also shows how to check whether a plan is still cached.
Buffer Cache Hit Ratio: Why a Healthy Number Can Lie
A 99 percent ratio does not mean your memory is fine. Here is how to read the counter correctly and what to check beside it.