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 Sentry

 

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.

SentryOne embraces a similar strategy. With SentryOne SQL Sentry, 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 provides 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 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

More about SQL Server on Linux

More resources

“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.

 

Ready to end your database performance problems?

 

Download a SQL Sentry trial

See for yourself how SQL Sentry can help you achieve optimal database performance.

Download Free Trial

Schedule a SQL Sentry demo

Learn more about how SQL Sentry can help you troubleshoot and prevent database performance problems. Register to attend a public demo or schedule a one-on-one session.

Schedule Demo

Learn more about SQL Sentry

Discover how you can quickly find and fix SQL Server performance problems with SQL Sentry, which delivers proven scalability, easy-access dashboards, and visibility across your entire database environment.

Learn More