|
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 ***
Navigation:
[Reply to this message]
|