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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

SQL Server monitoring queries appear to cause excessive CXPACKET waits
Description

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.
Cause

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.
Résolution
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/

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Produit(s) :: 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

Historique de l’article :: Créé le : 4/24/2015
Dernière mise à jour le : 5/7/2023

Titre