Shrinking TempDB and what to do when it doesn’t
This post is based on Tara’s recent blog post over on Brent Ozar’s site: and another: Basically, a query is killing your tempDB.…
Read MoreCategory: Cache
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read More
Using SQL Server 2012 Performance Dashboard Reports
Below is the link to install (on your local workstation instance of SSMS) the SQL Server 2012 Performance Dashboard Custom Reports. SQL Server…
Read More
sql_handle vs. plan_handle
sql_handle: is the hash of the original T-SQL source. plan_handle: is the hash of the cached execution plan. The important thing to note…
Read More
A Simple Overview of a SQL Query
Here are the 4 basic steps all queries go through: 1. Parsing: The query is examined by SQL Server to syntax errors, invalid…
Read More
SQL Server 2012 DMV’s (Dynamic Management Views)
Notes about DMV’s in General DMV data is discarded when the SQL Server service is restarted as it is stored in memory and…
Read More
SQL Server 2012 Internals
Life Cycle of a Query The command parser evaluates the query and generates a hash to see if the buffer pool has an…
Read More