Industry-leading Performance Monitoring for SQL Server on Linux

What performance monitoring is available in SQL Sentry for SQL Server on Linux?

SentryOne offers comprehensive database performance monitoring, diagnosing, and optimization capabilities for SQL Server 2017 on Linux. While not all the scenarios and features covered by SQL Server on Windows are supported by Microsoft on Linux yet, SQL Server 2017 on Linux is ready to support transactional and data-warehousing workloads, as well as Availability Groups.

Supported SentryOne products:

SQL SentrySQL Sentry Essentials

 

A single platform for monitoring SQL Server on Windows, Linux, and Cloud servers is ever more important   

The IT landscape is continually changing and diversifying. In recognizing this trend, Microsoft launched SQL Server 2017 as a cross-platform database engine for Windows, Linux, and Docker containers.

With its leading performance and security features and significant total cost of ownership advantages, SQL Server 2017 is poised to become the platform of choice for a growing number of enterprises. Organizations now want to choose the right OS platform for their enterprise database workloads and are looking for products that offer standard installation processes, common cross-platform tools, and a native user experience on the platform, all of which SQL Server provides.

The SentryOne Monitoring Platform embraces a similar strategy. With SentryOne, you can easily monitor and optimize all your SQL Server on-premises and cloud servers for peak performance from within a comprehensive, unified toolset.

 

 

Optimize the Performance of SQL Server on Linux

 

SentryOne SQL Sentry and SQL Sentry Essentials provide top-rated database monitoring capabilities for SQL Server on Windows and Linux.  With powerful dashboarding capabilities, users can monitor all their Windows, Linux, and heterogeneous SQL Server database server environments from within the same SentryOne monitoring client.  

SentryOne monitoring services for SQL Server on Linux include:

  • The Performance Analysis Dashboard tab for monitoring key database activities, including transactions, compilations, and recompilations; SQL Server waits, memory consumption, and database IO.
  • The Top SQL tab for viewing and analyzing highest-impact queries that can cause performance bottlenecks with SQL Server on Linux.
  • The Indexes tab for viewing index stats and analyzing index fragmentation and scheduling defragmentation tasks (only available in SQL Sentry) for improved database performance. 

 

Microsoft SQL Server 2017 on Linux doesn't support certain enterprise features like SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and massively parallel processing (MPP).  Consequently, SentryOne monitoring support for these features is limited to Windows environments at present. 

For a complete feature listing of SentryOne and SQL Server on Linux, visit our documentation and relevant Microsoft online resources.  

 

SQL Sentry provides the most comprehensive performance monitoring available for SQL Server on Linux, giving you the detailed metrics you need to troubleshoot performance problems.

SQL Sentry for SQL Server on Linux

 

SQL Sentry provides unrivaled performance insights for SQL Server on Linux, giving data teams the information they need to keep databases running at peak performance.  


 

Accelerate SQL Server on Linux with SQL Sentry

  • Use SQL Sentry or SQL Sentry Essentials (for less than five targets)  to monitor SQL Server on Linux  
  • Provides the same UI experience and features as for monitoring SQL Server on Windows
  • Install the SentryOne desktop client and monitoring service on Windows
  • Install SQL Server on Windows or Linux to store collected SentryOne monitoring data
  • Monitor SQL Server 2017 on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu 
  • SQL Sentry offers OS host monitoring features which aren't available for Linux

“Let's get this straight: when it comes to performance analysis tools for SQL Server, this is the only product I'd recommend.”

—Tim Ford, DBA, Mindbody, Inc.