Re: Longest SQL runtime??

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 19:51:06 -0400

What does "stop saving" mean? Do you get an error message at runtime, or in
the event log?

I have had much longer uptimes than that with databases measured in the
hundreds of GBs. However, we have normalized databases, running on very
expensive hardware as well (e.g. fiber connection between servers, and an
EMC SAN for data files). 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Denny" <anonymous@discussions.microsoft.com> wrote in message 
news:4A74C681-4116-42B4-8F88-6E3147FF6466@microsoft.com...
>I am curious as to how many of you have had your SQL server run non stop 
>for 6 months or more without any problems and how large is your database 
>file?
>
> We are running SQL Server 2000 on a dual PIII 1 Ghz system with 2 gigs of 
> RAM. Our SQL database is roughly 8 gigs in size and it seems we can't get 
> any more than 4-6 weeks before things stop saving (inserting records) and 
> we have to bounce it. We don't even have to reboot the box, just bounce 
> the SQL service and it runs good for another 4-6 weeks. In my opinion it 
> is our poor designs, tons of duplicate data, very wide tables, etc, etc. 
> My boss does not seem to think this is the case being everything works 
> great for 4-6 weeks. One would think if it was caused by our poor designs 
> we would have this problem all of the time, not after 6 weeks of runtime. 
> Because of his belief I am unable to talk him into redesigning everything 
> to be normalized.
>
> Any and all input is welcome.
>
> Thanks,

Relevant Pages

  • Re: Backing Up Mirrored database
    ... Tibor Karaszi, SQL Server MVP ... > all databases; and both run successfully without any issues. ... "Attempt to backup but receives an error message from the engine so the job fails"? ...
    (microsoft.public.sqlserver.tools)
  • Balasan: RE: Balasan: RE: Balasan: RE: cant execute "use $database"
    ... Here is the error message: ... use strict; ... I want that my perl code can work with several databases. ... If you are using SQL Server 2005 Express, ...
    (perl.dbi.users)
  • Re: Suspect
    ... why would it need to sync with the Log files? ... there has been no activity on these databases ... See the SQL Server errorlog for more information ... But the error message is ...
    (microsoft.public.sqlserver.server)
  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)