Select Page

Performance Tuning — Essential Tool for DBAs

Eric Russo | | June 12, 2017

sql server 2016 upgrade

The SQL Server 2016 release comes with new built-in features along with much needed improvements, making it the biggest leap forward in Microsoft’s data platform history. The SQL Server 2016 has several notable built-in features along with great improvements to some long-neglected capabilities in the previous versions that DBAs rely on. You can download our white paper, Making the Move to SQL Server 2016, which looks at the new and upgraded features offered by the latest addition to the SQL Server family.

Performance Tuning

Performance tuning is an essential tool that represents some of the major improvements made on SQL Server 2016, allowing DBAs access to the enhanced system performance metrics.

“Perhaps the most useful SQL Server 2016 feature for database administrators involves performance tuning, which allows DBAs to monitor and record the full history of query execution plans to diagnose issues and optimize plans. It will be invaluable for upgrades and patching to see where changes have impacted performance.” — Andrew Snodgrass, a research vice president at Directions on Microsoft, TechTarget

SQL Server Reporting Services (SSRS)

SQL Server Reporting Services received a significant makeover with the release of SQL Server 2016. Those include a new and brandable portal with a modern Web app appearance, with new KPI functionality that makes the building of dashboards much easier. It also includes paginated reports and mobile reports, desktop files for Excel, and power BI. The new option of installing reporting service separately outside the SQL Server setup makes the SSRS installation more lightweight, and enables users to configure the database with report server.

Master Data Services (MDS)

The MDS utility enables the management of master data sets of an organization. With MDS, users can create data models, perform access control on the data, organize the data into models, and create rules to update data.

PolyBase

PolyBase provides big data integration by allowing users to query distributed data sets; for example, querying Hadoop or SQL Azure blob storage using Transact SQL statements. It also enables the joining of relational data from SQL using written adhoc queries and optimizing them on the fly against semi-structured data with columnstore indexing.

JSON Support

SQL Server 2016 now has a built-in JSON support that allows users to interchange JSON data between applications and the SQL Server database engine. This feature provides great flexibility in reflecting business data in mobile applications as it allows the parsing and storage of JSON formatted data in a relation format and also allows relational data to be turned into JSON formatted data.

Columnstore Index Performance

SQL Server 2016 has much more mature In-Memory OLTP and columnstore indexes that are easily deployable and provides the ability to combine In-Memory OLTP and columnstore indexes on a single table. Single threading execution has made query execution time much faster. In addition, memory-optimized tables’ size limit has been raised to 2TB with capability of them being edited.

Overall, SQL Server 2016 is quite promising, providing comprehensive and enterprise-level database system that caters to today’s dynamic business needs. It also marks Microsoft’s cloud-first version of SQL Server and its investment in and improvements of the important features that had been long ignored.

To learn more about SQL Server 2016, please contact Datavail today or download Datavail’s recently released white paper, Making the Move to SQL Server 2016. Datavail is a specialized IT services company focused on Data Management with solutions in BI/DW, analytics, database administration, custom application development, and enterprise applications. We provide both professional and managed services delivered via our global delivery model, focused on Microsoft, Oracle and other leading technologies.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS