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 |
|
powertower
Starting Member
1 Post |
 Posted - 2011-02-16 : 08:36:58
|
| We have SQL 2008 installed on server 2003. Periodically the servers CPU usage will climb to almost 100% and start dropping connections. After a few minutes people can reconnect and everything is fine for a few hours. No useful information can be found in the logs. Can someone help me debug this problem? I've been googling for days...This 2008 setup was migrated from mssql 2000. May be useful info? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-16 : 14:23:44
|
| Use profiler or a server side trace to see what is hogging up the CPU like that.Likely to be a missing index, or you may just need to rebuild indexes. Did you rebuild 'em when you migrated from 2000 to 2008? |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-17 : 00:26:43
|
| Is there any error message like "A significant part of sql server process memory has been paged out...."in the SQL Server Error log ?PBUH |
|
|
|
|
|
|
High CPU / Memory Usage + Dropped Connections