Only the past 23 hours of SQL PI data is visble for a SQL Server database agent. (4230722)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Only the past 23 hours of SQL PI data is visble for a SQL Server database agent.
说明

Only the past 23 hours of SQL PI data is visble for a SQL Server database agent.
原因

User changed the host name and instance name of the monitored host in the Agent Status Property to an incorrect value so that the agent referred to a new PI_Instance key. The old data with the old instance_key could not be retrieved by the FMS.
解决办法
Disable and re enable the PI extension for the database agent
1. Navigate to the databases dashboard
2. Select the database agent
3. Click Settings | Administration
4. Select Performance Investigator
5. Click the checkbox for the database agent
6. Click the Disable button
7. Click the Enable button

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

产品：: 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; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

标题