Posted by Ian Murphy on 12/09/05 18:37

Hi, I've just picked up on this thread. I am also having the same
problem. Configuration is a 2003svr with sql server with sp4.

I am seeing exactly the same symptoms and have tried the suggestions
posted in this thread, all no no avail.

We're a small consultancy and have a collection of db's for various
packages mounted on the server. The server behaved normally until a few
days ago. I don't know what changed but I initially attacked disk and db
fragmentation and rebuilt the indexes to see if that was the cause - no
luck.

The cpu simply sits at 100% for the sqlserver process.

If anyone wants to make any suggestions this is not a production server
so I'm open to ideas.

What does work is taking the db's offline and putting them online again
- not exactly an ideal solution.

Unfortunatly the problem only rears its head occasionally and once you
have taken 7 o 8 db's offline it goes away. I am not sure the problem is
being caused by the last one to be taken offline.

I need this to go wrong again a few more times to work out which is
causing the problem.

regards

Ian Murphy



*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]