In our SQL ConstantCare® mentoring service, we collect data about your SQL Server’s health, backups, index designs, wait stats, and more.

You have the option – totally optional – of including queries and query plans, too. If you enable that, we will see your queries, and the queries themselves might contain confidential data. Here’s an example:

Should your application ever write queries like that? Obviously not – but it might. Similarly, execution plans include user queries, so they’re another route to see this kind of private data.

Sending in queries and execution plans is entirely up to you. If you want our advice on the queries, we’ll need to see the queries, full stop – but not everybody needs advice on their queries. If you only want advice on health, wait stats, and index designs, you’ll still get a ton of value out of SQL ConstantCare®.

To enable query and query plan advice, use the –sendplancache true parameter (that’s two minus signs, not one) when adding new connections. To edit existing connections:

Or, if you’ve got a lot of servers, it may be easier to edit your UserSettings.config file manually. In a text editor, open %localappdata%\ConstantCare\Current\UserSettings.config, and look for the sendplancache lines:

Just change the sendplancache values from false to true.

For more details, see the Quick Start Guide.