killing old spids

Question

killing old spids

schep021

Hall of Fame

Points: 3538
More actions
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?

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

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

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 1

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.

Jeff Moden SSC Guru Points: 1004360 More actions · Answer 2

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)

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 3

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

Jeff Moden SSC Guru Points: 1004360 More actions · Answer 4

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)

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 5

Fraggle-805517

SSCrazy Eights

Points: 8907

September 12, 2008 at 1:01 am

#870778

Sorry to scare you there Jeff. 😀

schep021 Hall of Fame Points: 3538 More actions · Answer 6

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

Chuck Fox SSC Enthusiast Points: 120 More actions · Answer 7

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

Your Friendly Neighborhood DBA,

Chuck

Jeff Moden SSC Guru Points: 1004360 More actions · Answer 8

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)

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 9

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

schep021 Hall of Fame Points: 3538 More actions · Answer 10

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

Jen