what is sp_lock?

Subash

9y5kSQL

what is the use of sp_Lock stored procedure in sql?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikandan Murugesan9y ago
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 Mohapatra9y ago
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/