Select Page

Third-Party Tools for SQL Server 2016

Author: Eric Russo | 4 min read | November 17, 2015

When Microsoft SQL Server 2016 is released, there will be many new features, but none will magically address issues associated with the smooth operation of your databases. However, the native tools within SQL Server can be easily augmented with the many different third-party tools now available.

Third-party tools are designed to help database administrators attend to tasks such as system administration, backup, monitoring, regulatory compliance, and reporting. Some of these are designed to provide users with a quick visual representation of what’s happening with their systems.

Third-party monitoring tools are “more flexible than the tools that ship with the product,” according to Basit Farooq, lead database administrator for the United Kingdom’s Medical Protection Society, who relies on products such as Idera SQL Diagnostic Manager for identifying and resolving SQL Server bottlenecks and DbProtect and ApexSQL Audit for security auditing.

Farooq adds:

Third-party monitoring tools can help monitor SQL Server and database performance, resolve potential problems with threshold-based and trend-based alerts, and isolate the root cause of application performance issues.

There are third-party tools for almost any task. Among the many choices for extract, transform, and load tools (“ETL” tools) are products such as Informatica PowerCenter, SAS Enterprise Data Integration Server and Pentaho Data Integration.

Some third-party SQL tools perform extremely narrow niche tasks, such as database source control. Source control is designed to take those changes in a database from the development environment into test, then production. These tools provide audit trails during the process. One such tool is ApexSQL Source Control, which works with SQL Server Management Studio as well as various control systems. The company is working now on an array of changes to its products, all of which are designed to provide SQL Server 2016 support for its database administrator suite of auditing, recovery, and performance monitoring tools.

Database Monitoring Tools Save Time and Money

Database monitoring tools are extremely useful to over-worked SQL administrators. Andrea Letourneaum told Tech Targetshe quit her job as an on-call database administrator after one too many 3 a.m. phone calls. She says the wide availability of SQL Server monitoring tools from vendors including SolarWinds, SQL Sentry and Idera are a boon and make good database administrators even better at their jobs.

Brian Peasland, also writing on Tech Target, says he uses SolarWinds’ database performance analyzer and Oracle’s diagnostics and tuning packs for evaluating problems with SQL statements. He observed:

SolarWinds’ DPA and Oracle’s diagnostics and tuning packs cost money, but I think they are worth the price. If I did not have these SQL performance tools at my disposal, I could have easily spent a week, instead of minutes, on this Oracle SQL performance issue.

Of course, the tool we at Datavail consider most essential is our SQL Server Health Check. This diagnostic tool helps users see what’s happening with their SQL Server environment and provides them with a road map of the work that needs to be performed to improve database performance.

We also have teams of experts able to help with the native tools found in SQL Server, such as those within SQL Server Reporting Services.

We are now hands-on with the trial version of SQL Server 2016 and following the announcements from these and other third-party tool providers. For more information about updating to a newer version of SQL Server, please download our white paper, Upgrading to SQL Server 2012 and Beyond.

Datavail can help your organization make the transition to the newest version of SQL Server. Contact Datavail to discuss a custom solution designed for your enterprise and to learn more about our database services and how our experts can help with your ongoing operations or special projects.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

PostgreSQL vs. Oracle: Let’s Compare

Discover some key differences between PostgreSQL vs Oracle that can help you make an informed decision when deciding on a database management system.

Vijay Muthu | March 30, 2021

Oracle RMAN Backup and Recovery with Restore Points

Oracle restore points are useful for benchmark testing. Find out how you can use Oracle’s Recovery Manager (RMAN) tool to create and use restore points.

Cindy Putnam | May 3, 2019

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

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


Work for Us

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