Page Splits, should I worry?I wish page splits were delicious. What are page splits? Page splits occur when a data page gets filled with data and a new page is...
Capture Query Information with Extended EventsMany of us have not made the effort to switch from profiler to Extended events. It's 2018, if you haven't found a few hours to learn...
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....
Deadlocks: Alerting and Information CollectionDeadlocks can be a serious plague to your existing systems. I am a fan of being proactive whenever possible. So instead of waiting for...