Had a high CPU on my SQL Servers and on further investigation, it appears
that the % privileged and interrupt time were high and not user time.
What should I account for such behavior especially if it occurs on many SQL
servers at the same time ?
Cannot find anything odd in the event or SQL Logs.Hi
"Hassan" wrote:
> Had a high CPU on my SQL Servers and on further investigation, it appears
> that the % privileged and interrupt time were high and not user time.
> What should I account for such behavior especially if it occurs on many SQ
L
> servers at the same time ?
> Cannot find anything odd in the event or SQL Logs.
You can also look at interupts/sec. If you are getting excessive number of
interupts it may be a disc issue so also look at Physical Disk counters.
John
Friday, March 9, 2012
High %privileged and interrupt time
Labels:
appearsthat,
cpu,
database,
further,
interrupt,
investigation,
microsoft,
mysql,
oracle,
privileged,
server,
servers,
sql,
time,
user
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment