SQL Server Performance

lock timeout

Discussion in 'SQL Server 2008 T-SQL Performance Tuning' started by maryam, Mar 5, 2009.

  1. maryam New Member

    I have a problem related to sql server performance.
    I'm managing a big DB with many stored procedured and users connecting to it. Some times it is very slow. I was checking the blocked processes using sp_who and no process was blocked but in the same time there were many lock:timeout events in the profiler!!!! what is the reason? how can I find which query/stored procedure is causing the lock timeout and why there was no blocked process in sysProcesses??
    Any help is appreciated.
    Thanks
  2. jr81 New Member

    Hi Are you running sql 2005?, If so try setting the Blocked process threshold to a certain value, and try capturing the queries in profiler? Did you find any queries that were running for a long time ? You can also try using this:http://support.microsoft.com/kb/271509
    Thanks
    Jay

Share This Page