Configure usage and diagnostic data collection for SQL Server tools (CEIP)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

Learn how the Customer Experience Improvement Program (CEIP) helps Microsoft identify ways to make our software better. You can configure tools to opt in or out at any time.

Note

For an explanation of the user data collection and use practices for Microsoft SQL Server releases, please refer to this privacy statement.

Opting in and out of CEIP for SQL Server Data Tools

The Customer Experience Improvement Program is a program designed to help Microsoft improve its products over time. This program collects information about computer hardware and how people use our product, without interrupting the users in their tasks at the computer. The information that is collected helps Microsoft identify which features to improve. In this document we will cover how to opt-in or out of CEIP for SQL Server Data Tools (SSDT) for Visual Studio 2017, Visual Studio 2015, and Visual Studio 2013. For information on opting out of CEIP for SQL Server, see Turning local audit off for SQL Server.

Choice and Control over CEIP and SQL Server Data Tools for Visual Studio 2017

SSDT for Visual Studio 2017 is the data modeling tool that ships with SQL Server 2017. It uses the CEIP options that are built into Visual Studio 2017. You can learn more about how to submit feedback through CEIP in Visual Studio 2017 from this help document from Visual Studio.

For preview versions of SQL Server 2017, CEIP is turned on by default. You can turn it off, or back on again, by following the instructions below.

In Visual Studio (applies to full language installations of Visual Studio 2017)

If you run SSDT Setup on a computer that already has Visual Studio, only the SQL Server and Business Intelligence project templates are added. For this scenario, customer feedback options that Visual Studio provides can be used to opt in or out of CEIP.

  1. Start Visual Studio.

  2. From the Help menu, select Send Feedback > Settings.

  3. To turn CEIP off, click No, I would not like to participate, and then click OK.

    To turn CEIP on, click Yes, I am willing to participate, and then click OK.

Use a registry-based policy or Group Policy

If you run SSDT Setup on a computer that does not have Visual Studio 2017, only the Visual Studio Shell is installed. The shell doesn't provide customer feedback options. In this case, a registry update is the only option for configuring CEIP

Enterprise customers may construct Group Policy to opt in or out by setting a registry-based policy for SQL Server 2017.

The relevant registry key and settings are as follows:

  • 64-bit OS, Key = HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VSCommon\15.0\SQM
  • 32-bit OS, Key = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VSCommon\15.0\SQM

When Group Policy is enabled, Key = HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\VisualStudio\SQM

Entry = OptIn

Value = (DWORD)

  • 0 is opted out (turn off the VSCEIP)
  • 1 is opted in (turn on the VSCEIP)

Caution

Incorrectly editing the registry may severely damage your system. Before making changes to the registry, you should back up any valued data on the computer. You can also use the Last Known Good Configuration startup option if you encounter problems after manual changes have been applied.

For more information about the information collected, processed, or transmitted by CEIP, see the Privacy Statement.

Choice and Control over CEIP and SQL Server Data Tools for Visual Studio 2015

SSDT for Visual Studio 2015 is the data modeling tool that ships with SQL Server 2016. It uses the CEIP options that are built into Visual Studio 2015. You can learn more about how to submit feedback through CEIP in Visual Studio 2015 from this help document from Visual Studio.

For preview versions of SQL Server 2016, CEIP is turned on by default. You can turn it off, or back on again, by following the instructions below.

In Visual Studio (applies to full language installations of Visual Studio 2015)

If you run SSDT Setup on a computer that already has Visual Studio, only the SQL Server and Business Intelligence project templates are added. For this scenario, customer feedback options that Visual Studio provides can be used to opt in or out of CEIP.

  1. Start Visual Studio.

  2. From the Help menu, select Send Feedback > Settings.

  3. To turn CEIP off, click No, I would not like to participate, and then click OK.

    To turn CEIP on, click Yes, I am willing to participate, and then click OK.

Use a registry-based policy or Group Policy

If you run SSDT Setup on a computer that does not have Visual Studio 2015, only the Visual Studio Shell is installed. The shell doesn't provide customer feedback options. In this case, a registry update is the only option for configuring CEIP

Enterprise customers may construct Group Policy to opt in or out by setting a registry-based policy for SQL Server 2016.

The relevant registry key and settings are as follows:

Key = HKEY_CURRENT_USER\Software\Microsoft\VSCommon\14.0\SQM

RegEntry name = OptIn

Entry type DWORD:

  • 0 is opt out

  • 1 is opt in

Caution

Incorrectly editing the registry may severely damage your system. Before making changes to the registry, you should back up any valued data on the computer. You can also use the Last Known Good Configuration startup option if you encounter problems after manual changes have been applied.

For more information about the information collected, processed, or transmitted by CEIP, see the Privacy Statement.

Choice and Control for CEIP and SQL Server Data Tools - BI (SSDT-BI)

If you are using SSDT-BI, you will be given an opportunity to participate in CEIP during installation. Later, CEIP configuration changes for SSDT-BI can be made through client tools or by editing registry settings.

In SSDT and SSDT-BI for Visual studio 2013

  1. Start the tool and open a new or existing project for either Analysis Services or Integration Services.

  2. From the Help menu, select Microsoft SQL Server Customer Feedback Options.

  3. To turn CEIP off, click No, I don't wish to participate.

    To turn CEIP on, click Yes, I am willing to participate.

  4. Click OK.

Use a registry-based policy or Group Policy

Enterprise customers may construct Group Policy to opt in or out by setting a registry-based policy for SQL Server 2014.

The relevant registry key and settings are as follows:

Key = HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\120

RegEntry name = CustomerFeedback

Entry type DWORD:

  • 0 is opt out

  • 1 is opt in