O envio de formulários no site de suporte está temporariamente indisponível para manutenção programada. Se precisar assistência imediata, entre em contato com o suporte técnico. Lamentamos o inconveniente.
SQL Server workload metrics stop populating in Global View
Descrição
For some SQL Server agents, the Workload metrics stop displaying on the Global View dashboard after collections have been running for some time. This condition remains until agent is Deactivated / Activated.
The following error can be seen in the agent log:
WARN [AGENTNAME-lowPriorityPool-1-[DBSS_Wait_Statistics][]] com.quest.glue.core.comms.filters.StaleDataFilter - Discarding sample ee88653b-88ce-4aa4-a919-1934f2c50d8c timestamped at MMM DD, YYYY HH:MM:SS AM CDT because it is 1 hour 0 minutes 11 seconds older than the server's current time and will be rejected anyway. The data sample was submitted by DB_SQL_Server/5.9.7.10/DB_SQL_Server/AGENTNAME on [MTP Agent - HOSTNAME/IPADDRESS].
Causa
The DBSS_Wait_Statistics collection could not run on schedule due to the lack of the low priority threads which are in charge of running some collections, such as 'DBSS_Wait_Statistics' collection. As a result, the DBSS_Wait_Statistics may read the old data from the cache which is populated by the PI engine more than one hour ago and it then uses PI records' sample_endtime as the submission time. So FglAM will discard these metrics because they are old.
Resolução
Increase the number of threads in low priority threads pool from the default 2 to 4.
Navigate to Administration | Agents | Agent Status
Edit the properties for the database agent
Select the link to Modify the properties for all DB_SQL_Server agents
Increase The number of threads in low priority threads pool from 2 to 4
Criado em: 2/25/2021 Última atualização em: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bem-vindo ao Suporte
Você pode encontrar ajuda de suporte on-line para *produto* da Quest em um local de suporte afiliado. Clique em Continue (Continuar) para ser direcionado ao conteúdo de suporte correto e à assistência a *produto*.
Encerramento do suporte aos navegadores IE 8, 9 e 10
O Portal da Quest Software não é mais compatível com IE8, 9 e 10. Recomendamos a atualização do navegador para a versão mais recente do Internet Explorer ou do Chrome.