Post reply

killing old spids

  • September 10, 2008 at 3:04 pm

    #212554

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

  • September 10, 2008 at 7:19 pm

    #870071

    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.

  • September 10, 2008 at 8:14 pm

    #870081

    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)
    Intro to Tally Tables and Functions

  • September 10, 2008 at 8:36 pm

    #870090

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

  • September 11, 2008 at 6:50 pm

    #870714

    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)
    Intro to Tally Tables and Functions

  • September 12, 2008 at 1:01 am

    #870778

    Sorry to scare you there Jeff. 😀

  • September 12, 2008 at 8:24 am

    #871014

    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

  • September 12, 2008 at 2:20 pm

    #871329

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

    Your Friendly Neighborhood DBA,

    Chuck

  • September 12, 2008 at 5:01 pm

    #871390

    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)
    Intro to Tally Tables and Functions

  • September 13, 2008 at 5:12 pm

    #871477

    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

  • September 13, 2008 at 8:54 pm

    #871505

    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