killing old spids

  • Is it ok to kill spids after a certain amount of time based on last batch date?

  • That would completely depend upon the business you are in and the companies security requirements. I could see reasons for doing it.

    Just make sure you don't kill any of the SPIDS that you need.

  • Fraggle (9/10/2008)


    That would completely depend upon the business you are in and the companies security requirements. I could see reasons for doing it.

    Just make sure you don't kill any of the SPIDS that you need.

    Heh... no fair teasing... what reasons? 😛

    --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)

  • Sorry that was a typo. Meant to say I couldn't see any reason for it.

  • Whew! Thanks for the feedback, Fraggle. Thought I missed something:).

    --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)

  • Sorry to scare you there Jeff. 😀

  • Fraggle,

    Thanks for the feedback. The situation I am most curious about was a connection from one of the web servers (to the database) that had a last batch date of about a week ago. In that case, is it ok to assume that connection was somehow "lost" and is safe to be killed? This is coming from a highly transactional system where other connections from the same web server have been created since then.

    Thanks,

    Jen

  • A week old and other connections already created ? I say nuke em til they glow!

    Your Friendly Neighborhood DBA,

    Chuck

  • Fraggle (9/12/2008)


    Sorry to scare you there Jeff. 😀

    Dang... as luck would have it, I found a reason to actually nuke old spids... connection leaks. I recently started a job at a new company and they have to reboot at least once per month due to a connection overload. Yeah, I know... fix the code... I agree. Problem is there's so much bloody code it'll take a while to find the offenders. The hidden problem is that if I actually "fix" it by deleting the abhorant spids, they might say "All done" instead of actually looking for and fixing the problem. What a choice...

    --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)

  • If it has been open a week, I would say kill it. Kill it hard.

    Sorry to hear that Jeff. At least if you fix it, you will be a hero....or out of a job. Either way, atleast you won't be board.

    Fraggle

  • Thanks all. I just needed some confirmation. Enjoy the rest of your weekend. 🙂

    Jen

Viewing 11 posts - 1 through 10 (of 10 total)

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