Longest SQL runtime??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Denny (anonymous_at_discussions.microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 16:41:08 -0700

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,