donsjones48 (3/24/2015)
Has anyone experience any problems following the installation of the February 2015 patches?We are experience higher than normal CPU and Memory paging with the patches installed. When we removed the patches performance goes back to normal.
We are running Windows Server 2008 R2 with SQL Server 2012 SP2 CU1 which is contained within a VM running VMware vSphere 5.5 update 2/3. The VM has 4 dedicated CPUs and 24 GB of dedicated memory. Right now, SQL Server is set to grab all of memory; we are looking at limiting SQL Server access to 18-20GB, and leave remaining memory to the OS and other running applications.
DJ
1) Apparently you didn't test your application (under load) with the new patch before you threw it into production. That is just asking for something bad to happen. I would do performance tuning on a system with the patch applied and find what query(s) went sideways and fix them. Most systems have "the table" and "the query" - if your "the query" went south performance wise on the new build then you are going to have trouble.
2) You should NEVER EVER EVER have a SQL Server box with default max memory setting, even laptops and development servers!!!! SQL Server can and will take too much and overwhelm the box. That alone could be responsible for your issues when you patched up.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service