Post reply

background spid causing blocking

  • May 6, 2014 at 12:44 pm

    #307138

    hi, i have a sql 2008 r2 OLTP instance. I have noticed a background spid running for two days, status: background, login: sa, lastwaittype: SOS_SCHEDULER_Y,statement: NULL. This spid is causing blocking on my server for other transactions. I have looked on sysprocesses and i can't see what is running, i do see the command column changing from update, select. I have also seen a large growth in my tempdb but cannot figure out what is running causing this. Can anyone help me?

  • May 6, 2014 at 3:42 pm

    #1711291

    can i try to kill this spid? or since is an internal spid, the only way to stop it is to restart services?

  • May 6, 2014 at 5:02 pm

    #1711313

    DBA-640728 (5/6/2014)

    can i try to kill this spid? or since is an internal spid, the only way to stop it is to restart services?

    Do you have replication running, by any chance?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 6, 2014 at 8:31 pm

    #1711331

    yes i do have replication running

  • May 8, 2014 at 8:08 am

    #1711869

    I restarted the services and that solved the spid running in the background for days.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply