首页 > 其他 > 详细

Utility5:UCP无法获取Managed Instance的Resouce Utility data

时间:2016-02-03 19:08:11      阅读:176      评论:0      收藏:0      [点我收藏+]

当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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!