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 5 (of 5 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy