SQL Server Processor Interupts per second >10 000

  • We have moved to a new 64 bit server with quad processors each with quad cores (16 cores total). I am not noticing performance issues but while monitoring the number of Processor interupts per second I am getting concerned as they appear to be extremely high. >10 000 and at times reaching 40k -50k (total across all). Two cores in paticular appear to be high but we are not pushing the box hard as the %idle time >90%.

    As we are new to 64bit and quad core systems I am not sure if this is normal. If we have a standby server and it also is high but no where near the maximums of the production system. I understand the concepts of interupts and usually this will be indicative of hardware issues but everything appears to be running normal. A little stumped.

    Any additional insight would be much appreciated

  • That level of interrupts is not unusual or concerning with a quad core based system. Older net-burst architecture processors were worth monitoring for interrupts, but no longer really.

    It is unlikely that SQL Server (if at SP3 or above) is the cause of the high number of interrupts, but you could always stop SQL Server and see if it changes much 😉

    Hope that helps a bit.

    Paul

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply