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

    Thanks,
  6. satya Moderator

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

    HTH

    _________
    Satya SKJ

Share This Page