当Enroll一个Instance之后,1hour过后,发现该 Managed instance 的health status 仍然处于 No Data Available 状态,why?
1,手动 collect 和 upload 数据到UCP
链接到Managed Instance,点击Utility information,点击Collect and Upload Now,数据上传成功,但是,在UCP中,该Instance的health status 仍然处于 No Data Available 状态。
2,由于Utility Information 是使用Agent 来收集数据的,打开 sysutility_mi_collect_and_upload Job查看history
Step2 出错,错误消息是:Executed as user: NT Service\SQLSERVERAGENT. Internal error: A job step could not successfully pipe a script to PowerShell
3,Remove 这个Instance后,在Validate到配置WMI时,出现Warning
Waning 消息是:
WMI must be configured correctly. Validation completed with a warning. WMI on the target instance is not configured properly for it to report data back to the UCP. Verify that the following classes are available on the machine and are accessible to SQL Server Agent service account:
Win32_MountPoint
Win32_PerfRawData_PerfProc_Process
Win32_PerfRawData_PerfOS_Processor
Win32_Processor
Win32_Volume
Win32_LogicalDisk
For example, issue the PowerShell command ‘Get-WmiObject Win32_PerfRawData_PerfProc_Process‘ on the target machine to verify that the Win32_PerfRawData_PerfProc_Process class is accessible. If the SQL Server Agent Service account recieves an Access Denied error, then the account may need to be added to the "Performance Monitor Users" group. For more information, see the Help topic for this operation.
这是错误的根源,参考资料:Access permission issue when uploading data to the utility warehouse ,我有没有解决这个问题。
Utility5:UCP无法获取Managed Instance的Resouce Utility data
原文:http://www.cnblogs.com/ljhdo/p/5180319.html