Pippen (name@notreal.add) writes:
> We are currently running MS-SQL2000 on a MS Server 2003 OS with 8G of
> memory (AWE enabled) with 4 HT processors (OS thinks that there are 8
> because of the HT). We are experiencing 1 - 3 days of very slow activity
> about the same time each month.

Well, it seems that you should be looking at what happening around
these days. Is there some process running on these days? Is lots of
data loaded in the beginning of this period, and then a maintenance
job handles reindexing a few days later?

One thing is for sure: it's not SQL Server that looks in the calender
and says "Oh, it's the 11th today, I take it soft for a couple of days".
If it is this regular there, is something in your environment. What is
of course hard to tell from a distance.

Not that I believe it matters, but I would recommend you to set "max
degree of parallelism" to 4, that is equal to the number of physical
processors.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp