• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

August 8, 2018

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 needed to make room for new data.  There are times when data modification causes data to be inserted in the middle of a page, this causes...

July 30, 2018

Many 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 about this incredibly powerful tool, I urge you to do so now. 

I'm going to provide a quick means of tracking queries with extended...

October 23, 2017

It'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. 

The process nodes show information regarding the actual modification.  The node that is X'd out is known as the deadlock victim. This...

October 17, 2017

Deadlocks can be a serious plague to your existing systems. I am a fan of being proactive whenever  possible. So instead of waiting for complaints from users or application developers, and then having to dig through logs and extended events, we can setup some type of a...

Please reload

Please reload

RECENT POSTS: 

FOLLOW ME:

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server.  When not working I like to lift weights, play music, and travel with my wife.

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle