THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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.

Blocking, Blockers, and Other B Words (A Month of Activity Monitoring, Part 14 of 30)

THIS CONTENT HAS BEEN MOVED HERE.

Published Thursday, April 14, 2011 11:00 AM by Adam Machanic

Comments

 

Adam Machanic said:

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

April 16, 2011 10:06 AM
 

Adam Machanic said:

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

April 20, 2011 10:35 AM
 

Adam Machanic said:

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

April 22, 2011 4:31 PM
 

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
 

Andrew Calvett View Andrew Calvett's profile on LinkedIn said:

Whilst reviewing the CPU statistics of a system that i knew was CPU bound i found the numbers were not

May 30, 2011 7:06 AM
 

Joe said:

Great article, but you have a small typo.  You write: "We can start to understand the situation in the sys.dm_exec_requests view by adding a few additional columns", but you really mean sys.dm_os_waiting_tasks, not sys.dm_exec_requests.  The sys.dm_exec_requests part of the picture comes later.

September 15, 2014 12:45 PM
 

Adam Machanic said:

@Joe:

I meant that we can understand the situation occurring in the requests view by adding more columns to the waiting_tasks query. So sentence is correct as-is but is perhaps ambiguously written :-)

--Adam

September 15, 2014 2:02 PM
 

Guest said:

Hi Adam,

Why would the number of sessions returned from sp_whoIsactive and sys.dm_exec_requests differ?e.g. sys.dm_exec_requests returns 90 rows while sp_whoIsActive 30.

Shouldn't they be equal as sys.dm_exec_requests "Returns information about each request that is executing within SQL Server" (from BOL). What point am I missing here?

Thank you.

November 25, 2014 8:39 AM
 

Adam Machanic said:

@Guest

sp_whoisactive returns, by default, only "interesting" sessions. The DMV, on the other hand, returns everything.

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/05/less-data-is-more-data-a-month-of-monitoring-part-5-of-30.aspx

November 25, 2014 10:30 AM
 

Guest said:

Thank you.

November 25, 2014 1:14 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

Syndication

Privacy Statement