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 |
|
drsloat
Starting Member
45 Posts |
 Posted - 2008-01-17 : 09:10:15
|
| I have a SQL Server 2005 database. There is Transactional replication (distributor is on another machine) to a second server that we use for reporting.Under a typical load there are around 800-1000 transaction/sec and 40-50% CPU usage. I have recently had two situations where the CPU spiked to nearly 100% sending down the transactions/sec and the system remained "stuck" until I restarted SQL Services. At that point things went back to normal.A problem that I'm having is that when the cpu gets spiked it is very hard to find out what's going on. I can not get a profiler to run and usually can not even see the process info.What could cause this to happen? What should I do to collect information to debug the problem?Thanks |
|
|
drsloat
Starting Member
45 Posts |
|
|
|
|
|
CPU Gets Stuck near 100%