SQL Server Performance

Self locks with poor performance

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by jsgjoshua, Dec 4, 2008.

  1. jsgjoshua New Member

    I am running a DTS with a execute sql task. Task having I am calling a proc. This proc is running long. I am able to find it is running abnormal with lot of self locks.
    Any solution..
  2. rohit2900 Member

    Welcome to the Forums....!!!
    Can you post the code of the proc.
    How did you got to know that its running abnormal with lot of self locks?
  3. satya Moderator

    True, are you running SELECT * from <Tablename> on that task?
    If not check what kind indexes on that table which is involved in this task.

Share This Page