THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Seeing All of the Waits (A Month of Activity Monitoring, Part 16 of 30)


Published Saturday, April 16, 2011 11:00 AM by Adam Machanic



Adam Machanic said:

This post is part 19 of a 30-part series about the Who is Active stored procedure. A new post will run

April 19, 2011 10:06 AM

Adam Machanic said:

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run

April 30, 2011 11:45 AM

Pavel Cupal said:

Today we were trapping blocked tasks from sys.dm_os_Waiting_tasks during a load test and two instances of SOS_SCHEDULER_YIELD were captured. Perhaps this changed since your post was original written in 2011? The output looked like this:

SnapshotTimestamp BlockingSPID SPID Thread Scheduler Wait_Ms WaitType ResourceDesc

2016-10-04 15:48:25.167 160 160 0 4 0 SOS_SCHEDULER_YIELD NULL

2016-10-04 15:49:35.770 102 102 0 0 0 SOS_SCHEDULER_YIELD NULL

The first one was on a user database

October 4, 2016 7:20 PM

Pavel Cupal said:

The second one was on master from running a separate query monitoring blocking chains using sys.sysprocesses during the same load test.

October 4, 2016 7:22 PM
New Comments to this post are disabled

About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement