Red Hat Enterprise Linux offers a cost-effective, efficient, and scalable foundation for Microsoft SQL Server with core benefits to support your entire environment.
Better performance, out of the boxNot only can SQL Server run on Linux, it actually performs better. In recent benchmarks, Microsoft tested performance against a variety of different database sizes, and Red Hat Enterprise Linux was the fastest at every level. Apart from raw speed, Red Hat Enterprise Linux performed better at overall cost per transaction. Additionally, Red Hat Insights can provide performance tuning information for specific SQL Server deployments and other related systems, such as cloud environments or the operating system itself.
The performance tests illustrate the core needs many database administrators and IT departments are encountering: managing increasing costs while tackling challenges with performance as demands change.
Blog: SQL Server database best practices now available through Red Hat Insights
Increased operational efficiencyMore than half of organizations installing SQL Server on Linux choose that platform to reduce operating costs. As database sizes increase, there is a proportional strain on IT resources, requiring more skilled administrators, more expensive hardware or software-defined solutions, and complexity around availability. Related, IT departments are trying to reduce dependence on a single vendor for their technology stacks and have the flexibility to move between environments as required.
Red Hat Enterprise Linux offers a variety of flexible subscription options with competitive pricing in leading cloud marketplaces. For on-premises hardware, Red Hat Enterprise Linux leads in all categories for lowest cost per transaction on SQL Server according to the TPC-H benchmark.
Simplified management and standardizationUsing Red Hat Enterprise Linux as a platform for SQL Server has additional advantages even over the speed and scalability of using a Linux system. Red Hat Enterprise Linux includes default profiles which automatically configure the system for better performance and security specific to SQL Server environments (using the tuned mssql profile).
Depending on the existing applications and team structure, IT departments may be able to consolidate and standardize on Red Hat Enterprise Linux rather than trying to split workloads between Windows and Linux systems. Standardization is a way to simplify and manage environments as they grow more complex, and the SQL Server Management Studio (SSMS) offers integrated management for SQL Server components.
New to Linux? Red Hat Enterprise Linux web console is a web-based management interface to simplify deployment, daily administration and complex tasks. Web console’s intuitive and easy-to-use web interface simplifies complex activities for non-experienced admins so they can perform tasks without command line knowledge and get a quick and convenient system overview from a centralized web interface.
Read more about how to manage SQL Server workloads
Consistency for hybrid cloudRed Hat Enterprise Linux provides a consistent experience for security, performance, features, and more across container and cloud environments, and it is certified for SQL Server. As SQL Server deployments grow in the cloud, that level of performance and flexibility can help IT teams manage their workloads with more efficiency.
Built In Security and High AvailabilityGet access to the security features of SQL Server and the hardened code of Red Hat Enterprise Linux. Red Hat Enterprise Linux also offers built-in security at the OS level so you don’t have to manage it separately for every workload, protecting against common vulnerabilities and exposures (CVE).
Red Hat Enterprise Linux provides business-critical uptime, fast failover, and improved manageability with Red Hat High-Availability Add-On, combined with SQL Server’s availability groups and backup tools to quickly recover in case of an unexpected failure.
More capabilities for Linux environmentsThe benefits work both ways. Red Hat Enterprise Linux can provide better cost and operational efficiencies for Windows administrators, but Microsoft SQL Server can also offer new functionality and workflows for Linux administrators if their applications require different capabilities than those available with open source SQL databases.
Read more about how the right platform amplifies the power of your database environment
How can automation help?Running SQL Server on Red Hat Enterprise Linux can improve performance and save time, but automation can help your enterprise run even more efficiently. With Red Hat® Ansible® Automation Platform, you can install and manage SQL Server in a consistent and reliable manner—on bare metal, virtual, and private and public cloud environments. Ansible Automation Platform reduces SQL Server installation to just minutes, integrates advanced analytics to help you build intelligent applications, and can improve performance for transactional systems and data warehouses.
Learn more about infrastructure automation with Ansible Automation Platform
Not subscribed to Ansible Automation Platform? You can still take advantage of automation with Red Hat Enterprise Linux system roles, a collection of supported Ansible roles that ensure consistent workflows and streamline the execution of manual tasks. Easily optimize your most popular workloads at the time of deployment and simplify ongoing administration by automating workload-specific tasks.
With Red Hat Enterprise Linux’s Microsoft SQL Server system role, you can install, configure and tune Microsoft SQL Server in your enterprise Linux environment with recommended defaults. Use custom network parameters for SQL Server and enable advanced SQL Server functionality, such as SQL Server Agent, full-text search (FTS), powershell, force unit access (FUA) capability, and TLS encryption capabilities. The SQL Server role also supports configuration of SQL Server Always On availability groups with the Red Hat High Availability Add-on. In this configuration SQL Server is capable of delivering increased uptime and scale-out performance capabilities.
Automate network and Microsoft SQL Server configuration using RHEL System Roles
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4