Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Andy1805
Starting Member
2 Posts |
 Posted - 2011-07-26 : 02:27:51
|
Hi,first please excuse my bad english  We have a strong server with two hexacore XEON CPUs and on it a hyper-v W2K8 R2 with sql 2008 r2 and sage office line evolution.Most time everything is fine, cpu load between 5 to 20 % and from one moment to the other the cpu load goes on all 4 cores (i gave the VM 4 cores and 16 gb RAM) to 100% and if i look in the task manager, it is only the SQL Server that is responsible for it.Then everything is very slow and the people cant work anymore till I reboot the VM.Do you have any idea, where I can search the problem? We reinstalled the VM two times and nothing changed.Kindly regardsAndy |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
Andy1805
Starting Member
2 Posts |
Posted - 2011-07-26 : 08:03:47
|
| Thx for that link. But I think the performance is ok. 95-99% of the working time everything is fine and only perhaps 20 min of 8.5 h business time the cpu load goes to 100%. But I will goes through the optimation advices, maybe it will help. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL 2008 CPU Load 100%