Close Encounters of the CEIP Kind

  • Rodney Landrum

    SSCommitted

    Points: 1899

    Comments posted to this topic are about the item Close Encounters of the CEIP Kind

  • Jeff Moden

    SSC Guru

    Points: 996830

    Thanks for the very timely article, Rodney.  I agree that my right index finger will feel a great loss and not being able to turn it all off during installation.

    It would appear that you can disable both error and feature reporting fairly easy, once made aware of it.  Please see the following MS article. https://msdn.microsoft.com/en-us/library/ms143343.aspx  While the write up there is all very interesting, the very last paragraph quickly summarizes how to disable both and it's done without having change a policy or registry setting.  The registry setting appears to be only for the time-of-day when the feature reporting would occur if left enabled.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Ed Wagner

    SSC Guru

    Points: 286982

    Jeff Moden - Saturday, February 4, 2017 3:35 PM

    It would appear that you can disable both error and feature reporting fairly easy, once made aware of it.  Please see the following MS article. https://msdn.microsoft.com/en-us/library/ms143343.aspx

    That was a very timely article for me. I just installed a WSFC and SQL 2016 and saw those new services. I wondered how I missed it in the setup, but also how there were multiple new services consuming resources I didn't want consumed.

    And Jeff, thanks for so much for that link.  That's a definite must-have.

  • David.Poole

    SSC Guru

    Points: 75378

    I am behind the curve on this one.  A server collecting telemetry per se is only useful if it can send that data back to base.  Most production servers I've seen could not talk directly to the internet or send external mail.

    No matter what Microsoft does internally they can only simulate what their customers actually do.  That telemetry data can be a mine of information and flush out problems so they can be fixed early.  

    I'd be curious to know from those who have experienced various levels of paid support from Microsoft and other organisations how Microsoft rank.

    I've been quite impressed with both Microsoft and AWS.  Neo4j and DataStax were reasonable and certainly better than I expected given the size of company.

  • Gary Varga

    SSC Guru

    Points: 82166

    I am a little concerned that this is hidden. I can even understand this being fixed on for free, evaluation and developer versions. It seems a reasonable part of the deal. It is the nature of forcing this to be on for other editions that makes me feel a little uneasy. It is like they are deceiving their customers. That may or may not be their intention but unintended consequences may also occur.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Jeff Moden

    SSC Guru

    Points: 996830

    Gary Varga - Monday, February 6, 2017 4:42 AM

    I am a little concerned that this is hidden. I can even understand this being fixed on for free, evaluation and developer versions. It seems a reasonable part of the deal. It is the nature of forcing this to be on for other editions that makes me feel a little uneasy. It is like they are deceiving their customers. That may or may not be their intention but unintended consequences may also occur.

    I think MS needs a kick in the head.  Apparently they think they can do whatever they want because of their damned EULA and the way it's written.  I don't care how innocent the data being collected may be.  Part of "the deal" that I expect is having full and obvious notification and control of if and when any data is sent to anyone.  This is like MS installing a camera in my living room.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32407

    Thanks. I read Brent's article ages ago and then clean forgot to do anything about it. I'm going to see if I can get a policy created.

  • Gary Varga

    SSC Guru

    Points: 82166

    Beatrix Kiddo - Monday, February 6, 2017 7:34 AM

    Thanks. I read Brent's article ages ago and then clean forgot to do anything about it. I'm going to see if I can get a policy created.

    A brief article would be a good share. (I thought that I would suggest before Steve asked ;))

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • jay-h

    SSCoach

    Points: 18816

    ", maybe all of that previoustelemetry had taught Microsoft hat 98.9% of DBAs opt out of sending this data,so they gave up on the idea of collecting it! "

    Absence of a checkbox should not be interpreted as not collecting. Microsoft, like many other entities (including the government) doesn't just stop collecting.. they just stop talking about it and asking permission.

    You check is in the mail.

    ...

    -- FORTRAN manual for Xerox Computers --

  • julie.woolner

    SSC-Addicted

    Points: 484

    MS displaying the same mind set as they did in Windows 10

  • Ed Wagner

    SSC Guru

    Points: 286982

    Ed Wagner - Saturday, February 4, 2017 8:07 PM

    Jeff Moden - Saturday, February 4, 2017 3:35 PM

    It would appear that you can disable both error and feature reporting fairly easy, once made aware of it.  Please see the following MS article. https://msdn.microsoft.com/en-us/library/ms143343.aspx

    That was a very timely article for me. I just installed a WSFC and SQL 2016 and saw those new services. I wondered how I missed it in the setup, but also how there were multiple new services consuming resources I didn't want consumed.

    And Jeff, thanks for so much for that link.  That's a definite must-have.

    I installed a new SQL 2016 failover cluster today and can confirm that this does work.  After doing the normal stuff in the configuration manager, I made the changes described in the article on both nodes.  After a failover, the CEIP services were no longer running.

    Many thanks again, Jeff, for that article.

  • TomThomson

    SSC Guru

    Points: 104773

    Jeff Moden - Saturday, February 4, 2017 3:35 PM

    Thanks for the very timely article, Rodney.  I agree that my right index finger will feel a great loss and not being able to turn it all off during installation.

    It would appear that you can disable both error and feature reporting fairly easy, once made aware of it.  Please see the following MS article. https://msdn.microsoft.com/en-us/library/ms143343.aspx  While the write up there is all very interesting, the very last paragraph quickly summarizes how to disable both and it's done without having change a policy or registry setting.  The registry setting appears to be only for the time-of-day when the feature reporting would occur if left enabled.

    Sad to say, that article has disappeared - that url now redirects to https://msdn.microsoft.com/library/bb500395.aspx which contins no information at all about CEIP.

    It might be useful if someone could tell whether the method in the now inaccesible article still works and if it does describe it in this  thread.

    Tom

  • Ed Wagner

    SSC Guru

    Points: 286982

    TomThomson - Tuesday, May 9, 2017 2:24 AM

    Jeff Moden - Saturday, February 4, 2017 3:35 PM

    Thanks for the very timely article, Rodney.  I agree that my right index finger will feel a great loss and not being able to turn it all off during installation.

    It would appear that you can disable both error and feature reporting fairly easy, once made aware of it.  Please see the following MS article. https://msdn.microsoft.com/en-us/library/ms143343.aspx  While the write up there is all very interesting, the very last paragraph quickly summarizes how to disable both and it's done without having change a policy or registry setting.  The registry setting appears to be only for the time-of-day when the feature reporting would occur if left enabled.

    Sad to say, that article has disappeared - that url now redirects to https://msdn.microsoft.com/library/bb500395.aspx which contins no information at all about CEIP.

    It might be useful if someone could tell whether the method in the now inaccesible article still works and if it does describe it in this  thread.

    I tried the link and my bookmarked page, but both redirect to the page you have above that tells us nothing about CEIP.  I read it while the page was still up and did it, so here's a condensed version of what I remember:

    1. On the SQL Server, open Error and Usage Report Settings.  On my Windows Server 2012 R2, it's Start...Microsoft SQL Server 2016...SQL Server 2016 Error and Usage Reporting.
    2. Clear the checkboxes.  There's one for error reports and one for usage reports.
    3. Click OK when done.
    4. If you're running a cluster, don't forget to do the other nodes.
    5. I believe I failed over to make sure the settings stayed as I left them.
    6. With SQL 2016, there are system services for the CEIP, one for SQL and one for SSAS.  I took the extra step of disabling them.

    If anyone has anything to fill, please feel free to do so.  I hope this helps.

  • Woody

    Old Hand

    Points: 340

    This link appears to contain the same information on disabling phone home as the 'disappeared' link.

    https://support.microsoft.com/en-us/help/3153756/how-to-configure-sql-server-2016-to-send-feedback-to-microsoft

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply