Skip to main content
Redhat Developers  Logo
  • AI

    Get started with AI

    • Red Hat AI
      Accelerate the development and deployment of enterprise AI solutions.
    • AI learning hub
      Explore learning materials and tools, organized by task.
    • AI interactive demos
      Click through scenarios with Red Hat AI, including training LLMs and more.
    • AI/ML learning paths
      Expand your OpenShift AI knowledge using these learning resources.
    • AI quickstarts
      Focused AI use cases designed for fast deployment on Red Hat AI platforms.
    • No-cost AI training
      Foundational Red Hat AI training.

    Featured resources

    • OpenShift AI learning
    • Open source AI for developers
    • AI product application development
    • Open source-powered AI/ML for hybrid cloud
    • AI and Node.js cheat sheet

    Red Hat AI Factory with NVIDIA

    • Red Hat AI Factory with NVIDIA is a co-engineered, enterprise-grade AI solution for building, deploying, and managing AI at scale across hybrid cloud environments.
    • Explore the solution
  • Learn

    Self-guided

    • Documentation
      Find answers, get step-by-step guidance, and learn how to use Red Hat products.
    • Learning paths
      Explore curated walkthroughs for common development tasks.
    • Guided learning
      Receive custom learning paths powered by our AI assistant.
    • See all learning

    Hands-on

    • Developer Sandbox
      Spin up Red Hat's products and technologies without setup or configuration.
    • Interactive labs
      Learn by doing in these hands-on, browser-based experiences.
    • Interactive demos
      Click through product features in these guided tours.

    Browse by topic

    • AI/ML
    • Automation
    • Java
    • Kubernetes
    • Linux
    • See all topics

    Training & certifications

    • Courses and exams
    • Certifications
    • Skills assessments
    • Red Hat Academy
    • Learning subscription
    • Explore training
  • Build

    Get started

    • Red Hat build of Podman Desktop
      A downloadable, local development hub to experiment with our products and builds.
    • Developer Sandbox
      Spin up Red Hat's products and technologies without setup or configuration.

    Download products

    • Access product downloads to start building and testing right away.
    • Red Hat Enterprise Linux
    • Red Hat AI
    • Red Hat OpenShift
    • Red Hat Ansible Automation Platform
    • See all products

    Featured

    • Red Hat build of OpenJDK
    • Red Hat JBoss Enterprise Application Platform
    • Red Hat OpenShift Dev Spaces
    • Red Hat Developer Toolset

    References

    • E-books
    • Documentation
    • Cheat sheets
    • Architecture center
  • Community

    Get involved

    • Events
    • Live AI events
    • Red Hat Summit
    • Red Hat Accelerators
    • Community discussions

    Follow along

    • Articles & blogs
    • Developer newsletter
    • Videos
    • Github

    Get help

    • Customer service
    • Customer support
    • Regional contacts
    • Find a partner

    Join the Red Hat Developer program

    • Download Red Hat products and project builds, access support documentation, learning content, and more.
    • Explore the benefits

Smarter memory control for SQL Server on RHEL with cgroup v2

Full support for cgroup v2 now added for RHEL

August 19, 2025
Vivien Wang Attinder Pal Singh (Microsoft)
Related topics:
Data integrationDatabasesIntegrationLinuxWindows
Related products:
Red Hat Enterprise Linux

    If you're running Red Hat Enterprise Linux for Microsoft SQL Server—especially in containers or Kubernetes—there's a nifty update you should know about. With SQL Server 2025 and SQL Server 2022 CU 20, Microsoft has added full support for cgroup v2, which is a big step forward for memory management on RHEL.

    What is cgroup v2, and why does it matter?

    On Red Hat Enterprise Linux (RHEL) and other modern Linux distributions, control groups (cgroups) help you control how much CPU, RAM, and other resources each process or container can use. It's like putting fair limits in place so no single workload can monopolize your entire server.

    cgroup v2 is the modern version. It's more efficient and provides more precise control. This matters even more if you run SQL Server inside containers on Red Hat OpenShift or Kubernetes clusters.

    Want to check if cgroup v2 is enabled on your RHEL system? You can verify this in your system configuration or follow Red Hat's official documentation. To turn it on manually, add systemd.unified_cgroup_hierarchy=1 to your GRUB settings and run an update. Many current RHEL releases have cgroup v2 enabled by default. See the blog SQL Server on Linux Now Supports cgroup v2 for more specifics.

    How SQL Server handled memory before

    Here's the problem this update fixes:

    • When running on RHEL, SQL Server has always tried to limit its own memory usage to about 80% of the total system RAM. That makes sense on bare metal or a virtual machine, but not inside a container.
    • Previously, older versions of SQL Server didn't detect cgroup v2 limits. So if you set your container to use only 4 GB of RAM, SQL Server would still try to grab 80% of the host's RAM. This often led to Out of Memory (OOM) errors and container crashes.
    • Back when cgroup v1 was common, Kubernetes and OpenShift used Guaranteed QoS to enforce resource limits, and SQL Server respected those. But once cgroup v2 became the new standard, SQL Server didn't catch up—until now.

    What's changed with SQL Server 2025 and 2022 CU 20?

    Good news: SQL Server is finally cgroup v2-aware. That means:

    • It reads the memory limits you set with cgroup v2.
    • It adjusts its usage automatically.
    • Containers stay within their resource limits, so you're much less likely to hit OOM errors.

    This is a big win for anyone running SQL Server in containers on OpenShift or Kubernetes on RHEL 9 or newer, where cgroup v2 is the default.

    Who benefits from this?

    This update is especially useful if you:

    • Run SQL Server in containers on OpenShift or Kubernetes clusters on RHEL.
    • Manage Linux-based SQL Server environments on Red Hat.
    • Want to avoid containers fighting over memory on your nodes.

    Put simply, this update brings SQL Server closer to the level of resource control you'd expect in a modern, cloud-native, containerized environment.

    How to keep an eye on things

    To make sure your SQL Server is behaving as expected on RHEL:

    • Use journalctl for system logs.
    • Check SQL Server's logs to track memory usage.
    • Use Kerberos logging and logger.ini if you run into authentication issues.

    Final thoughts

    It might look like a minor tweak, but for anyone running SQL Server on RHEL, this is a huge improvement. Better memory handling means fewer crashes, more predictable performance, and smoother operations in your containers or Kubernetes clusters.

    If you haven't already, plan your upgrade to SQL Server 2025 or SQL Server 2022 CU 20 and enjoy the peace of mind that comes with smarter, modern resource management on Red Hat.

    Further reading

    • SQL Server on Linux Now Supports cgroup v2
    • SQL Server on Linux Overview
    • SQL Server 2025 Release Notes
    • Deploy SQL Server on OpenShift or Kubernetes
    • Getting started with RHEL 10

    Related Posts

    • Using Microsoft SQL Server on Red Hat OpenShift

    • Getting Started with Microsoft SQL Server on Red Hat Enterprise Linux

    • Running Microsoft SQL Server pod on OpenShift

    • Deploying SQL Server on Linux using an Ansible playbook

    • Develop SQL Server databases on RHEL with Podman Desktop

    • Controlling resources with cgroups for performance testing

    Recent Posts

    • Protect data offloaded to GPU-accelerated environments with OpenShift sandboxed containers

    • Case study: Measuring energy efficiency on the x64 platform

    • How to prevent AI inference stack silent failures

    • Preventing GPU waste: A guide to JIT checkpointing with Kubeflow Trainer on OpenShift AI

    • How to manage TLS certificates used by OpenShift GitOps operator

    What’s up next?

    Dive into the world of Red Hat Enterprise Linux 10 with this concise cheat sheet designed to boost your productivity.

    Get the cheat sheet
    Red Hat Developers logo LinkedIn YouTube Twitter Facebook

    Platforms

    • Red Hat AI
    • Red Hat Enterprise Linux
    • Red Hat OpenShift
    • Red Hat Ansible Automation Platform
    • See all products

    Build

    • Developer Sandbox
    • Developer tools
    • Interactive tutorials
    • API catalog

    Quicklinks

    • Learning resources
    • E-books
    • Cheat sheets
    • Blog
    • Events
    • Newsletter

    Communicate

    • About us
    • Contact sales
    • Find a partner
    • Report a website issue
    • Site status dashboard
    • Report a security problem

    RED HAT DEVELOPER

    Build here. Go anywhere.

    We serve the builders. The problem solvers who create careers with code.

    Join us if you’re a developer, software engineer, web designer, front-end designer, UX designer, computer scientist, architect, tester, product manager, project manager or team lead.

    Sign me up

    Red Hat legal and privacy links

    • About Red Hat
    • Jobs
    • Events
    • Locations
    • Contact Red Hat
    • Red Hat Blog
    • Inclusion at Red Hat
    • Cool Stuff Store
    • Red Hat Summit
    © 2026 Red Hat

    Red Hat legal and privacy links

    • Privacy statement
    • Terms of use
    • All policies and guidelines
    • Digital accessibility

    Chat Support

    Please log in with your Red Hat account to access chat support.