SQL Server Performance

Sp_lock (SP_ID)

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by ashish.johri2007, Mar 15, 2007.

  1. ashish.johri2007 New Member

    Hi,<br /><br />There is one very interesting thing I have observed. Eventhough I have not used this table (Hold_Withdrawal_Item_Fund) and related table for last some months…I am getting this in the result when I do a query:<br /><br />Sp_lock (SP_ID)<br />Result - 1115151018<br /><br />select object_name(111515101<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br />Result - Hold_Withdrawal_Item_Fund<br /><br />Ashish Johri
  2. MohammedU New Member

    Run the query against master..sysprocesses table to see the origin of the SPID...
    You are not using but may be some one else...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page