SQL Server monitoring queries appear to cause excessive CXPACKET waits (4308111)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

SQL Server monitoring queries appear to cause excessive CXPACKET waits
Beschreibung

The top two SQL queries for a particular SQL Server are from Foglight, and are causing millions of CXPACKET waits. Average duration per wait is very low, but the amount of the waits seem excessive.
Ursache

Foglight for SQL Server needs to query SQL Server System Tables. Once System Tables are queried, some of what is seen in various Database Dashboards and views are reflections of SQL Server background activity. This activity is not indicative of poor performance of the monitoring processes, but may indicate a need for tuning of the Instance(may include reviewing hardware requirements), database application logic and procedures. Foglight data collections can run at high frequencies, which may make them appear to impact system performance, when in fact they do not.
Lösung
Tune the MAXDOP on the instance to reduce the CXPACKET wait you are experiencing:
1. https://support.microsoft.com/en-us/kb/2806535 - Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server.
2. http://www.sqlserverbestpractice.com/configuration/sql-server-configuration/maxdop/

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5, 5.7.1, 5.6.11, 5.6.10, 5.6.7, 5.6.5; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Titel