Reading the Deadlock GraphIt's important to be able to analyze the deadlock graph once it's been detected. I'm going to give a brief run down on what I look at....
Book Review: SQL Server Query Performance Tuning by Grant FritcheyMy war torn copy. I spent the last few months looking like a total dork reading this book on the train. But I'm a rockstar when I get to...
Detecting Storage I/O Problems in SQL ServerSo here's a scenario. You have a client that has implemented SAN storage for your SQL Servers (could be virtual or physical). Your...
Parameter SniffingNot always optimal... What is it? Let’s say you have a parameterized proc, and it creates and caches an execution plan based on certain...
Consulting Series: The Value of Performance TuningWhat does the performance of SQL Server mean to you and your company? What are the benefits? How is the value perceived? Is it in dollars...
In-Memory OLTP for Noobs Pt. 2So let's jump right in and see if we can't make some of the In-Memory OLTP features work. Then I can work on elaborating the details....