SQL Server on Linux Storage Secrets

Data Exposed - Channel 9

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn't quite work like that by default. In a situation where you run out of space, you're out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before you put anything on the disks to properly set up the disks so you can expand them in a pinch in the future. In this episode with David Klee, we're going to walk through how to use this service to set up your object volumes the right way from the beginning and show you how to expand the disks with no outage. Break out your pocket protectors and come learn with someone who was compiling Linux kernels while in elementary school!

[00:37] About David Klee
[01:18] Challenge overview
[02:14] Linux Logical Volume Manager
[03:00] Demo: Logical Volume Manager Setup
[09:22] Who should this set up
[10:05] Getting started

Resources:

$2 Million Reasons to Start with Tuning

David Klee's website

Heraflux Data Platform Consultants

SQLlibrium Training

About David Klee:

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies and SQLibrium Education. His areas of expertise are cloud, virtualization, performance tuning, and business continuity. David speaks at a number of national and regional technology-related events, including the PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups.

About MVPs:

Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram