Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Database strange behavior
Message
 
 
To
29/09/2008 16:03:50
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 6.5 and older
Miscellaneous
Thread ID:
01350510
Message ID:
01351612
Views:
21
>Sergey,
> I did not. I don't know how will need assistance here. I am more developer don't know much about administrative part.

Check this article How to troubleshoot performance problems in SQL Server

There is a section about locks in it.
select  
    request_session_id as spid,  
    resource_type as rt,   
    resource_database_id as rdb,  
    (case resource_type 
      WHEN 'OBJECT' then object_name(resource_associated_entity_id) 
      WHEN 'DATABASE' then ' ' 
      ELSE (select object_name(object_id)  
            from sys.partitions  
            where hobt_id=resource_associated_entity_id) 
    END) as objname,  
    resource_description as rd,   
    request_mode as rm,  
    request_status as rs 
from sys.dm_tran_locks 
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform