SQL Server Performance

Lockups and blank processes

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by KrelianXgs, Jan 22, 2007.

  1. KrelianXgs New Member

    So lately I've been getting calls occasionally about system performance. First thing I do is check for cases of blocking as the system has a history of it. I execute some stored procedures which find long running processes with locks or processes waiting for locks. I check these processes in Activity Monitor and when I select "Details" after choosing the process in Activity Monitor, the Last T-SQL Command Batch is nothing. No SQL statement at all.

    Is this normal in the case of locked up processes? Do you think it's a crashed program on one of the clients causing the problem? This seems to be the only theory that I can think of.
  2. satya Moderator

    http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
    http://sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk - take a look at it even though it refers SQL 2000 as most of it applies to 2005 too.

    http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx also a good one to check.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page