Indexes (rowstore) 101 information: clustered, non-clustered and heaps
What indexes are and how they are organized internally is very much a 101 topic. For those unfamiliar I can recommend Brent Ozars free class “How to Think Like the…
Monitoring Metrics – Page Life Expectancy (PLE) and associated metrics
For my writeups of monitoring metrics I will add what I see as necessary correlation metrics to have a more complete description of how I would use it. Page Life…
Locks vs Latches, a short comparison
This is not a detailed in-depth dive into locks nor latches , but a short summary to highlight the difference and to show that they are different but do affect…
Troubleshooting blocking using sp_whoisactive
First, resolving the current immediate blocking situation is important, but to prevent the issue from reoccurring or at least to make an informed decision as to what to do about…