what is sp_lock?

Question

what is the use of sp_Lock stored procedure in sql?

Manikandan Murugesan · Answer

Refer the following link : https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-lock-transact-sql On Transact SQL language the sp_lock is part of Database Engine Stored Procedures and shows information about locks.

Manas Mohapatra · Answer

StoredProcedure(sp_lock) avialable from SQLServer 2000 onwards. It will give insight of locks happening in database. It will reomove in future version of SQLserver. Below query should give you existing locks. exec sp_lock Moreover it uses SQL isolation level to lock records. There are different types of isolation level like: READ UNCOMMITTED READ COMMITTED REPEATABLE READ SNAPSHOT SERIALIZABLE You can use this SP to diagnosing the database performance issue. Follow below link: http://www.techrepublic.com/article/diagnosing-sql-server-performance-issues-using-sp-lock/