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 |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2008-01-10 : 11:09:38
|
| Hi Experts, here we are having a very very serious problem, in SQL 2005, we are having 8 CPU's and in the task manager CPU usage is showing 100% and the performance of server is very very poor and last night the server has got rebooted, still CPU Usage is showing 100%, So how can i improve the performance? it is very very urgent for me, can any one please let me know what is going on and what is the solution.-Thanks N Regards,Kanthi. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-11 : 00:07:32
|
| Find out which process uses most cpu first. But you said it's memory issue in the header. |
 |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-01-11 : 00:17:22
|
| Try this'Exec sp_updatestats' |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-14 : 07:14:52
|
| One thing you could try is : Open Profiler and pick any statements that are taking to long to run (whatever you define as being to long). Optimise. Which may include updating statistics , checking indices. Another thing to try is : sys.dm_os_wait_stats for 2005 and track back to see what is slowing the system downJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
SQL Server - Performance (Memory Issues)