• Super Cat - Friday, January 5, 2018 4:50 AM

    Has anyone deployed any of the patches released for SQL 2016 and SQL 2017 to any of their environments. 

    Is anyone considering it?
    Has anyone tested the impact. 

    I do not run 2016 or 2017 in the environment I am responsible for.

    I applied CU3 to SQL Server 2017 yesterday afternoon. I don't have a lot of load running against this server currently (3 QA people and some developers - 25 databases) but so far I'm not seeing the dreaded 30% I/O hit that some articles have mentioned. Using Redgate SQL Monitor, I compared a 3 hour window this morning against the same window a week ago and see nothing out of the ordinary. I looked at CPU usage on the VM and on SQL Server as well as average disk read/write on the data, log and tempdb drives. Everything looks like very similar to before the patch. I will continue monitoring this during the day today and will be patching our DEV box this afternoon. DEV has 10 developers hitting it and some report writers / analysts as well so it sees more I/O. This will give me a better idea if a busier box will show more of a hit.

    A little about the QA box:
    Windows Server 2016 (not patched for Meltdown / Spectre yet - one step at a time) (VM)
    64GB RAM
    4 core
    Largest DB ~ 500GB - active QA work going on against this database.

    (more to come)