[MSSQL] free persistent connections

rea_and

Hi,
here I have a problem with persistent connections. The problem is that the mssql admin (a sort of) restarts the windows machine once or twice a day. These frequent restarts cause the death of mssql persistent links (I guessed). So, php pages sometimes fail to connect to the server db. For now I restart each time the web server.
So, I'd like to know if there some configuration set or some methods to syncronize this problem.

thx in advance.

mssql server 2005, on windows
php5+freetds lib, on linux

dougal85

your database server is being restarted multiple times a day? why?

Sxooter

dougal85 wrote:
your database server is being restarted multiple times a day? why?

Cause it's running on windows, where many windows syadmins have learned that the solution to all problems is to reboot?

rea_and

Sxooter wrote:
Cause it's running on windows, where many windows syadmins have learned that the solution to all problems is to reboot?

Something like that. His explanation was: windows updates!!!

So, for each win update I'd restart the web server...:mad:

Sxooter

rea|and wrote:
Something like that. His explanation was: windows updates!!!

So, for each win update I'd restart the web server...:mad:

You guys need a Change Approval Board, and all reboots / updates / interruptions of service should be scheduled, except for emergencies. Your Windows SA is playing loose and free and it's making you look bad.

stolzyboy

That "sysadmin" sounds like a clown.

If nothing else, do the reboots at "off-peak" hours, whatever that may be for your business.

I'd be willing to be he doesn't test his "updates" on a DEV or TEST server before doing it in PROD.

There is no reason a PROD server needs to be restarted that often at non-standard times.

I'd suggest this "sysadmin" be reported and a suggestion to be replaced with this sort of IT practice.

Wow.

Sxooter

Also, make his service account name somthing like "errorprone", "careless", or "reckless"

Just saying.

rulian

I run servers on WAMP no problem, no slowdowns
How crucial is your updates, if it's very crucial you should consider doing some redundancy, put that SA to the test