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:
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
Last activity: Oct 2, 2018, 01:20 PM