Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It looks like the information you want is not captured by this event.</p> <p>You can see what fields are available for an event with:</p> <pre><code>select p.name package_name, o.name event_name, c.name event_field, c.type_name field_type, c.column_type column_type from sys.dm_xe_objects o join sys.dm_xe_packages p on o.package_guid = p.guid join sys.dm_xe_object_columns c on o.name = c.object_name where o.object_type = 'event' AND o.name = 'locks_lock_timeouts_greater_than_0' order by package_name, event_name </code></pre> <p>the result is:</p> <pre><code>sqlserver locks_lock_timeouts_greater_than_0 ID uint16 readonly sqlserver locks_lock_timeouts_greater_than_0 UUID guid_ptr readonly sqlserver locks_lock_timeouts_greater_than_0 VERSION uint8 readonly sqlserver locks_lock_timeouts_greater_than_0 CHANNEL etw_channel readonly sqlserver locks_lock_timeouts_greater_than_0 KEYWORD keyword_map readonly sqlserver locks_lock_timeouts_greater_than_0 count uint64 data sqlserver locks_lock_timeouts_greater_than_0 lock_type uint64 data </code></pre> <p>However, in SQL 2012 this event was replaced ( <a href="http://msdn.microsoft.com/en-us/library/ms144262.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms144262.aspx</a> ) by lock_timeout_greater_than_0 which has the following set of fields</p> <pre><code>sqlserver lock_timeout_greater_than_0 UUID guid_ptr readonly sqlserver lock_timeout_greater_than_0 VERSION uint8 readonly sqlserver lock_timeout_greater_than_0 CHANNEL etw_channel readonly sqlserver lock_timeout_greater_than_0 KEYWORD keyword_map readonly sqlserver lock_timeout_greater_than_0 collect_resource_description boolean customizable sqlserver lock_timeout_greater_than_0 collect_database_name boolean customizable sqlserver lock_timeout_greater_than_0 resource_type lock_resource_type data sqlserver lock_timeout_greater_than_0 mode lock_mode data sqlserver lock_timeout_greater_than_0 owner_type lock_owner_type data sqlserver lock_timeout_greater_than_0 transaction_id int64 data sqlserver lock_timeout_greater_than_0 database_id uint32 data sqlserver lock_timeout_greater_than_0 lockspace_workspace_id ptr data sqlserver lock_timeout_greater_than_0 lockspace_sub_id uint32 data sqlserver lock_timeout_greater_than_0 lockspace_nest_id uint32 data sqlserver lock_timeout_greater_than_0 resource_0 uint32 data sqlserver lock_timeout_greater_than_0 resource_1 uint32 data sqlserver lock_timeout_greater_than_0 resource_2 uint32 data sqlserver lock_timeout_greater_than_0 object_id int32 data sqlserver lock_timeout_greater_than_0 associated_object_id uint64 data sqlserver lock_timeout_greater_than_0 duration uint64 data sqlserver lock_timeout_greater_than_0 resource_description unicode_string data sqlserver lock_timeout_greater_than_0 database_name unicode_string data </code></pre> <p>From this I was able to derive the database (database_id) and in my case table (variously in object_id, associated_object_id, resource_0) from their Ids.</p> <p>I didn't see an obvious way to find who was locking the object from the data captured by this event.</p> <p><strong>EDIT</strong> - see <a href="https://stackoverflow.com/questions/5572585/sql-server-lock-timeout-exceeded-deleting-records-in-a-loop">SQL Server Lock Timeout Exceeded Deleting Records in a Loop</a> for an example of using sp_lock and sp_who2 to debug the cause of a lock timeout event.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to get owner and locked object from locks_lock_timeouts_greater_than_0 event in SQL Server?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USbkr
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 Thank you for the information about changes in SQL Server 2012. Unfortunately, I need this information on SQL Server 2008. Maybe, someone else will found an workaround for SQL Server 2008.
      singulars
      1. PO
      1. USTN.
    2. COWhy have you set a lock timeout, normally it will wait an unlimited amount of time if there is not a deadlock?
      singulars
      1. PO
      1. USbkr
    3. COThe application has a user interface.
      singulars
      1. PO
      1. USTN.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload