What are the challenges you face when working across database platforms? Take the survey
Options

processor utilisation

fatherjack2fatherjack2 Posts: 311
edited December 8, 2008 7:11AM in SQL Monitor Previous Versions
Hi,

I have had two alerts for High CPU utilisation but both instances are on the same hardware. they were at the same time. Does this mean that both instances were busy or will they always report the high CPU as its a shared resource?

we are 2x SQL 2005 64bit on a pair of dual core processors...

thanks

Senior DBA
Careers South West Ltd

Comments

  • Options
    Hi fatherjack,

    The CPU usage is a shared resource so both instances should raise the alert.

    You could take a look at the System Processes section for the alert to see which processes are taking up a lot of CPU time.

    I hope this helps,
    Matthew Flatt
    Redgate Foundry
  • Options
    Thanks for the reply Matthew,

    I just needed confirmation that if the CPU usage goes high then it would alert in both monitored instances. That means I only need to investigate it once..!

    Jonathan

    Senior DBA
    Careers South West Ltd
Sign In or Register to comment.