List of Bugs Fixed in SQL Server 2014 CU2 – Part 1

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of Cumulative update package (CU) 2 for Microsoft SQL Server 2014.

KB Article 2926223
SQL Server 2014 bug ” Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012 or SQL Server 2014 in Management Tools
KB Article 2928300
SQL Server 2014 bug ” Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server related to SQL Server performance
KB Article 2931815
SQL Server 2014 bug ” Loads or queries on CCI tables block one another in SQL Server 2014 with SQL Server service
KB Article 2932559

SQL Server 2014 bug ” Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014 with Analysis Services
KB Article 2933103
SQL Server 2014 bug ” Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server related to SQL performance
KB Article 2936154
SQL Server 2014 bug ” DTA utility crashes with an access violation when you use user-defined function in SQL Server with Management Tools
KB Article 2938192
SQL Server 2014 bug ” The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014 with Integration Services
KB Article 2938476
SQL Server 2014 bug ” Errors when you use export/import data wizard to move data in SQL Server with Integration Services

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

BENEFITS Coming with New SQL Server 2016 Release

SQLServerF1

SQL Server 2016 is making buzz in the community where lots of interested Database Administrators, Developers, Managers trying to get more insights about the product and trying to get an idea about new features introduced with SQL Server 2016 and what are the enhancements or changes to the existing features like AlwaysON, In-Memory OLTP, etc. Microsoft SQL Server team works on new features based on what competitors are already providing and something new and more than what competitors already have. Also, there are lot of enhancements made to existing features based on the feedback from user community and customers using the SQL Server product.

Blow are the features or enhancements that come up with new SQL Server 2016 as reported in their official blog.
BENEFITS of SQL Server 2016
– Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics
– New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
– Built-in advanced analytics provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database

– Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android
– Simplify management of relational and non-relational data with ability to query both through standard T-SQL using PolyBase technology
– Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes
– Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2016

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

CPU or Processor Speed Slowdown Errors in Windows Eventlogs

SQLServerF1

You may receive or notice below warning message in Windows System logs periodically.
Source: Microsoft-Windows-Kernel-Processor-Power
Event ID: 37
Task Category: (7)
Level: Warning
User: SYSTEM
Computer: ServerName
Description:
The speed of processor # in group # is being limited by system firmware. The processor has been in this reduced performance state for ## seconds since the last report.”

Starting with Windows Server 2008 R2, CPU power plan has been introduced where we can set the CPU power plan to either balanced or high performance. Each of these power plan has its own advantages and disadvantages. Balanced power plan consumes less power, but when the system or server is very busy, the performance will not be so good. With High performance power plan, the power consumption would be high, but on busy systems it dramatically improves the performance. So, on critical and important busy systems, it is advisable to use high performance CPU power plan. Also, in cases where you notices errors or warnings in event logs as mentioned above, go ahead and enable the high performance CPU power plan.

You can enabled this feature from control panel to either high performance or balanced power plan, but on some systems this may also have been enabled at BIOS level, so you will have to make changes both at control panel and BIOS level. Also on VMware or hyper-v or other virtual systems, it is required that this power plan is set to high performance on both guest and host servers or systems and also at BIOS level on the host server.

Below are the steps to change CPU power plan setting to High performance mode
– Open control panel and check the Power Options. Change or Make sure that the CPU Power Scheme is set to High Performance, and check that every option is set to “Always On”.
– Make sure latest drivers and firmware are installed on the server, especially for your motherboard and CPU.
– Reboot the server or system and go to your BIOS settings. Make sure that your power settings are set to maximum. This may differ from server to server.

Hope this was helpful.

This is applicable for below versions of Windows Servers

Windows Server 2008 R2
Windows Server 2012
Windows Server 2012 R2

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings