September 10, 2008 at 3:04 pm
Is it ok to kill spids after a certain amount of time based on last batch date?
September 10, 2008 at 7:19 pm
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
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
Change is inevitable... Change for the better is not.
September 10, 2008 at 8:36 pm
Sorry that was a typo. Meant to say I couldn't see any reason for it.
September 11, 2008 at 6:50 pm
Whew! Thanks for the feedback, Fraggle. Thought I missed something:).
--Jeff Moden
Change is inevitable... Change for the better is not.
September 12, 2008 at 1:01 am
Sorry to scare you there Jeff. 😀
September 12, 2008 at 8:24 am
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
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
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
Change is inevitable... Change for the better is not.
September 13, 2008 at 5:12 pm
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
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