Latches and Spinlocks - SQL Server 2012 Internals and Troubleshooting - page 202

FIGURE 7-20
Note that although the object_name i eld appears to end in the string 'Latches' , this i eld is
actually stored as nchar(256), rather than nvarchar(256), so there is a large amount of whitespace at
the end, and that last % is needed.
Extended Events
Chapter 13 is dedicated to the topic of extended events, so this section simply explains which
extended events are available for latches and spinlocks. If you open the New Session Wizard for
Extended Events from SQL Server 2012 Management Studio, you will reach a screen from which
you select the events you wish to capture. After reaching this, i rst scroll the Event library
section to reveal the Channel drop-down box. Then, as shown in Figure 7-21, check Debug, which
is unchecked by default.
FIGURE 7-21