Third-Party Tools for SQL Server 2016

While we welcome the release of Microsoft SQL Server 2016, none of the many new features will magically repair all of the issues associated with the smooth operation of your databases. However, the native tools within SQL Server 2016 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 TechTarget she quit her job as an on-call database administrator after one too many three-in-the-morning phone calls. She says the wide availability of SQL Server monitoring tools are a boon and make good database administrators even better at their jobs.

Of course, the tool which 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.

For more information about updating to a newer version of SQL Server, please download our white paper, Upgrading to SQL Server 2012 and Beyond.