SQL Server Lock Listesi

August 15, 2010

Eğer SQL Server ınızda o anda var anda var olan lock ların listesini almak isterseniz. Aşağıdaki ufak script den faydalanabilirsiniz.

   SELECT resource_type, resource_subtype, resource_description, 
   resource_associated_entity_id, request_mode, request_status, request_lifetime
   FROM sys.dm_tran_locks

tags: , , ,
posted in SQL Server, T-SQL by sedat.salman

Follow comments via the RSS Feed | Leave a comment | Trackback URL

1 Comment to "SQL Server Lock Listesi"

  1. smy wrote:

    1839 satır döndü,hepsinin durumu şöyle,bu sonuçları nasıl yorumlamalıyım?
    resource_type:DATABASE
    resource_subtype:
    resource_description:
    resource_associated_entity_id:0
    request_mode:S
    request_status:GRANT
    request_lifetime:0

    Link | July 19th, 2011 at 11:26

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org