Re: System degrades after 49.71 days
From: Croco Stimpy (none_at_none.com)
Date: 11/19/04
- Next message: mat: "Memory Leaks"
- Previous message: Andrea Anastasescu: "ignore errors"
- In reply to: Lockdesign Ltd: "System degrades after 49.71 days"
- Next in thread: Rick Sawtell: "Re: System degrades after 49.71 days"
- Reply: Rick Sawtell: "Re: System degrades after 49.71 days"
- Reply: Lockdesign Ltd: "Re: System degrades after 49.71 days"
- Reply: Andrew J. Kelly: "Re: System degrades after 49.71 days"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 08:26:13 -0500
We have a "maintenance window" on the 3rd friday of every month.
At 3:00am, we reboot EVERY M.S. server in the place. Hundreds of them.
Including domain controllers.
It really helps. I suggest you consider doing the same.
"Geoff Kell (Lockdesign Ltd)" <Geoff Kell (Lockdesign
Ltd)@discussions.microsoft.com> wrote in message
news:0396B8BB-3F78-4C09-AB3E-D45CCA18F9FA@microsoft.com...
> We have a SQL Server 7 database running on a Compaq Proliant ML370 under
> Windows 2000 Server.
>
> Normal operation has approximately 300-330 connections to the database.
>
> The system runs fine until after 49.71 days when we start to experience
> processes timing out their transactions. These processes had performed the
> exact same type of transactions without problem prior to the 49.71 days.
>
> The 49.71 days ties in with the number of milliseconds that may be held in
> a
> 32 bit quantity. I have found reference to problems in this area for SQL
> Server 6.5 and the GetDate() function but nothing for SQL Server 7.
>
> It is interesting to note that this database was, until a year or so ago,
> running on a standard desktop style server under Windows NT 4 Server.
> Under
> this configuration we experienced no such problems at all. We upgraded to
> the
> Compaq server for increased resilience (dual network, power supply, etc).
> The
> problems we are experience are quite embarrassing as the reliability has
> fallen as we need to schedule reboots every 49 days. Since we run in a
> 24/7
> environment these restarts have quite an impact on our customers.
>
> Any advice/suggestions greatly appreciated.
- Next message: mat: "Memory Leaks"
- Previous message: Andrea Anastasescu: "ignore errors"
- In reply to: Lockdesign Ltd: "System degrades after 49.71 days"
- Next in thread: Rick Sawtell: "Re: System degrades after 49.71 days"
- Reply: Rick Sawtell: "Re: System degrades after 49.71 days"
- Reply: Lockdesign Ltd: "Re: System degrades after 49.71 days"
- Reply: Andrew J. Kelly: "Re: System degrades after 49.71 days"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
