Knowledge Base

Tips for MS SQL Server Monitoring using SNMP Helper

Cette page n’existe pas en français en ce moment. Nous vous prions de nous excuser.

Specific tips for users of MS SQL Server in cooperation with SNMP Helper

If the ?System Processor Queue Length? (SNMP Helper Pro only) regularly exceeds the recommended maximum, but the CPU utilization is not correspondingly as high (which is typical), then consider reducing the SQL Server "max worker threads" configuration setting. It is a possible reason that the Processor Queue Length is high is because there are an excess number of worker threads waiting to take their turn. By reducing the number of "maximum worker threads", what you are doing is forcing thread pooling to kick in (if it hasn't already), or to take greater advantage of thread pooling.

By Category

SNMP Helper