SQL Server Performance

blocked processed in Sql Server 2000

Discussion in 'Performance Tuning for DBAs' started by chinnis, Mar 20, 2003.

  1. chinnis New Member

    I ran sp_Who2 active
    i got this result

    spid kpid blocked waityype cmd
    01 03 select

    it doesn't even show that the processes with spid 03 exists but it shows when
    i run sp_who2 as sleeping.
    when i run
    dbcc inputbuffer(03)
    it says null
    but i don't understand why is it blocking.

    any help is
  2. satya Moderator

    That is system SPID, check any of the jobs are running too long.

    Satya SKJ
  3. chinnis New Member

    when i run sp_who2 active but it is showing only that spid 03 is blocking spid 01, i am not clear what jobs have to do here
    sorry i am bad in undesrtanding can you make me little clear
  4. satya Moderator

    I mean to say check whether any job are running on the server while this process is shown on current activity.
    Are there any other applications running?

    Satya SKJ
  5. chinnis New Member

    No jobs's were running at that time but they might be some transations
    going from different databases.At that time i didn't see any active transactions.
    but do you think if you see open_tran > 1 do you see any problem
    for spid 03 as i mentioned above it is sleeping but i think open_tran > 1

  6. satya Moderator

    Capture the trace using PROFILER and see all the activities on the SQL server.


    Satya SKJ

Share This Page