Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article we will talk about SQL Server Telemetry \ CEIP Services.
CEIP (Customer Experience Improvement Program) is a thing of the past and almost every supplier is running it to collect product usage data, problems encountered and other information.
Every supplier has a Customer Experience Improvement Program – CEIP – to collect product usage data, issues encountered, and other information. Basically, it is a well-known and used method.
Before SQL Server 2016, you could choose whether to participate in CEIP at the installation stage, but with the data and data management becoming more important, you join CEIP by default after SQL Server 2016, and if your server can access the internet, the data collected here is sent to the developer via CEIP. forwards it to the team.
By the way, while talking about the CEIP incident, I would like to inform you that this is not a bad situation.
It is certain to give Microsoft the ability to collect “useful” data in the development of the processes I have outlined below and to maximize the impact on future developments.
Incident Management
Alert management (proactive approach)
Automatic management via bots (based on alerts)
Machine learning / data science
Exploring potential new features that can benefit maximum customers
Microsoft implements and uses the CEIP event differently for multiple products it develops. If you want to opt out and disable CEIP, you can run the powershell script below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | [code lang=”ps”] Get-Service | Where-Object { $_.Name -like ‘*telemetry*’ -or $_.DisplayName -like ‘*CEIP*’ } | ForEach-Object { $servicename = $_.Name; $displayname = $_.DisplayName; Set-Service -Name $servicename -StartupType Disabled $serviceinfo = Get-Service -Name $servicename $startup = $serviceinfo.StartType Write-Host "$servicename : $startup : $displayname"; } Set-Location "HKLM:\" $sqlentries = @( "\Software\Microsoft\Microsoft SQL Server\", "\Software\Wow6432Node\Microsoft\Microsoft SQL Server\" ) Get-ChildItem -Path $sqlentries -Recurse | ForEach-Object { $keypath = $_.Name (Get-ItemProperty -Path $keypath).PSObject.Properties | Where-Object { $_.Name -eq "CustomerFeedback" -or $_.Name -eq "EnableErrorReporting" } | ForEach-Object { $itemporpertyname = $_.Name $olditemporpertyvalue = Get-ItemPropertyValue -Path $keypath -Name $itemporpertyname Set-ItemProperty -Path $keypath -Name $itemporpertyname -Value 0 $newitemporpertyvalue = Get-ItemPropertyValue -Path $keypath -Name $itemporpertyname Write-Host "$keypath.$itemporpertyname = $olditemporpertyvalue –> $newitemporpertyvalue" } } [/code] |
If you want to perform the operation performed with the above script manually, you can follow the steps below.
First of all, stop the services that pass CEIP you see in services.msc.
Then, make sure that the following records are changed via regedit, depending on the installed SQL Server features.
1 2 3 4 5 6 7 8 9 10 11 | HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\CustomerFeedback=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\130\EnableErrorReporting=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS13.TESTINSTANCE\CPE\CustomerFeedback=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSAS13.TESTINSTANCE\CPE\EnableErrorReporting=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSRS13.TESTINSTANCE\CPE\CustomerFeedback=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSRS13.TESTINSTANCE\CPE\EnableErrorReporting=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL13.TESTINSTANCE\CPE\CustomerFeedback=0HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL13.TESTINSTANCE\CPE\EnableErrorReporting=0HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft \Microsoft SQL Server\130\CustomerFeedback=0HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft SQL Server \130\EnableErrorReporting=0 |
