I was recently working on a client system that has problems running DBCC CHECKDB normally due to the concurrent volume of data changes occurring against their 2TB OLTP database. The challenge with running DBCC CHECKDB on this system is that the database snapshot (which DBCC CHECKDB creates) quickly exceeds the sparse file limits in Windows [...]
Jonathan Kehayias
The Rambling DBA
DBCC CHECKDB Execution Memory Grants – Not Quite What You Expect
Posted on: March 25, 2013 8:55 pm
Execution Plan Sanitizer v2
Posted on: February 28, 2013 12:02 am
Almost two years ago I blogged about Sanitizing Execution Plans using PowerShell. The original intent behind this idea was to be able to provide completely sanitized execution plans that could be shared outside of your business environment without the risk of sharing any design elements that may be considered Intellectual Property. Since writing that post I’ve [...]
Enlarging the AdventureWorks Sample Databases
Posted on: August 21, 2012 10:46 pm
The AdventureWorks set of sample databases are commonly used for presentation demos and showing how to use SQL Server, but one of the biggest challenges in using these databases is their small size which is geared towards ease of distribution, more than demonstrating all of the functionality of SQL Server. The concept of creating a [...]
Extended Events xml_deadlock_report and Multi-Victim Deadlocks
Posted on: May 27, 2009 10:32 am
At the beginning of the year, I wrote an article titled Retrieving Deadlock Graphs with SQL Server 2008 Extended Events that detailed how to use the default system_health session to retrieve deadlock graphs from SQL Server 2008 without having to use SQL Profiler, SQL Trace or enabling a Trace flag on the SQL Server. In [...]
