El envío de formularios en el sitio de soporte no está disponible temporalmente para programar el mantenimiento. Si necesita asistencia inmediata, comuníquese con el soporte técnico. Disculpe las molestias ocasionadas.
SQL Server workload metrics stop populating in Global View
Descripción
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.
Resolución
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
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bienvenido al portal de soporte
Puede encontrar ayuda de soporte en línea para el *producto* Quest en un sitio de soporte afiliado. Haga clic en Continuar para ser dirigido al contenido de soporte y a la asistencia adecuados para el *producto*.