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

Converse agora com nosso suporte

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

SQL Server monitoring queries appear to cause excessive CXPACKET waits
Descrição

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

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.
Resolução
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 enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Conteúdo recomendado

Produto(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

Título