wait statistics

Brent Ozar's DBA Training Plan no.15: What’s Your SQL Server Waiting On?

  • Article

Brent continues his DBA Training Plan: Whenever your queries need to wait on something – storage, locks, memory, whatever – SQL Server tracks what it’s waiting on, and for how long. It’s like you’re seeing INSIDE the server, with all kinds of possible debug points being tracked. All you have to do is ask SQL Server, “What have you been waiting on?”. Here Brent shows you how.

2019-09-27

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

Any guides for sizing Azure managed instances.

By Sliverlight

Hi All, Has anyone got any tips for sizing a move from VM running...

How to check if NextDay is Holiday (exclude Saturday and Sunday)?

By SQL Server

Hi: We maintain a calendar table with these columns. We have a process which...

Always On - tips for running large transactions

By NicHopper

Hi all, I wanted to get a second opinion on something, this weekend I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers