Sample Header Ad - 728x90

How to turn off logging of "Software Usage Metrics enabled" and ESENT errors

5 votes
1 answer
5204 views
I am running SQL Server 2017 Standard CU 5 in a failover cluster with two nodes (single instance cluster). I have followed these two manuals to deactivate CEIP aka spyware features: - The CEIP service is disabled and stopped, - the CEIP role removed from the cluster - and all registry entries regarding CustomerFeedback and EnableErrorReporting are set to 0. However I still get the message "Software Usage Metrics is enabled." in SQL Server error logs after a service restart. Additionally there are frequent errors from ESENT like the following in my windows event log: ESENT error access denied There is a MS Knowledge Base article for this problem. However it is for SQL Server 2012. It says that this error is related to the "Software Usage Metrics feature". I already followed the advice to grant permissions for the SQL Server service account. However the error message keeps appearing and I don't want Microsoft to collect data anyway. Here are my questions: 1. Is that the same feature as the CEIP stuff or something else? 2. How do I deactivate Software Usage Metrics correctly?
Asked by Martin Guth (715 rep)
Mar 22, 2018, 07:26 AM
Last activity: Oct 2, 2018, 01:20 PM