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%