Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agiotti
Starting Member
37 Posts |
 Posted - 2011-10-22 : 08:52:21
|
| Hello All,While reviewing Microsoft SQL Server 2008 Implementation and Maintenance training kit I came across this particular question.Which of the following are used to locate blocked processes?a. sys.dm_exec_sessions viewb. sys.dm_exec_requests viewc. sys.dm_os_waiting tasks viewd. sp_who2 system stored procedureBoth the book and the training kit exam prep CD says that item (c.) is incorrect. However, BOL displays blocking_session_id column as part of the returned list for this DMV. BOL description for blocking_session_id: ID of the session that is blocking the request. The training CD and book explains that this DMV list processes that are waiting on a resource but you cannot locate blocked processes using this view.I have created a blocking test and this DMV does display the session id and the wait resource. If you select this DMV as one of the answers you will get the entire question wrong, why? |
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
|
|
|
Exam 70-432