evgkushnir
Old Hand
Points: 384
More actions
April 28, 2008 at 12:40 am
#187060
Hi everyone,
have one question.
I had CPU 100% on my SQL Server.
After I run
CHECKPOINT
DBCC DROPCLEANBUFFERS
DBCC FLUSHPROCINDB(5)
CPU became 20%
Why?
VD
Ten Centuries
Points: 1149
April 29, 2008 at 7:52 am
#808355
A few times when our SQL server hit 100% CPU it was because a proc lost a good execution plan.
May 2, 2008 at 1:53 am
#809952
Why does this happen?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply