RE: Strange situation

From: John Bandettini (anonymous_at_discussions.microsoft.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 01:41:03 -0700

Kob

If you were running SQL 6.5 or 7 on NT4 I would think from the symptoms you describe that you had a memory leak or something similar. These were very common on those platforms, most sites performed regular reboots just to avoid having these kind of problems. However SQL 2000 and Windows 2000 do not usually have these problems.

Are you running any other applications on the server? SQL Server does not like to share it's resources with other applications. Do you perform regular maint (dbcc's, index rebuilds etc) either through a maint plan or indivividual jobs?

Regards

John

Relevant Pages
Loading