SSCrazy,

MAXDOP is MAX DEGREE OF PARALLELISM (http://msdn.microsoft.com/en-us/library/ms181007(v=sql.105).aspx)

A parameter that says to use just the number of seted cores on the server for each query, 0 is...

Hey Guys,

I keep having the same problem, but now I have some useful informations, see below:

First, we have changed the MAXDOP parameter from 0 to 4, but we have some...

Ok,

The problem not occurred any more time.

But I will wait and comment.

Thanks.

Hey,

Thanks for the quick answer, in the last occurrence I try to run the update statistics command on the exclusive table, but the problem was not solved, OK, maybe I...

Guys,

Just to give fair closure to this topic, wasn't just the cache the problem.

In fact, our infrastructure team just forgot to upgrade one windows server to SP1, so, this cause...

Hi everyone,

My problem was solved, when my infrastructure team made the upgrade, beyond the memory and CPU, they have included a cache plate, that was malfunctioning, they substituted e now...