SQL Server on Linux Storage Secrets | Data Exposed: MVP Edition

Published Jul 27 2021 09:00 AM 1,399 Views
Microsoft

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!

 

Watch on Data Exposed


Resources:
%3CLINGO-SUB%20id%3D%22lingo-sub-2562764%22%20slang%3D%22en-US%22%3ESQL%20Server%20on%20Linux%20Storage%20Secrets%20%7C%20Data%20Exposed%3A%20MVP%20Edition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESQL%20Server%20object%20disks%20on%20Windows%20Server%20can%20be%20expanded%20at%20any%20time%20with%20no%20issues%2C%20but%20Linux%20doesn%E2%80%99t%20quite%20work%20like%20that%20by%20default.%20In%20a%20situation%20where%20you%20run%20out%20of%20space%2C%20you%E2%80%99re%20out%20of%20luck%2C%20unless%20you%20know%20some%20secrets%20about%20Linux.%20The%20mysterious%20Linux%20Logical%20Volume%20Manager%20must%20be%20used%20before%20you%20put%20anything%20on%20the%20disks%20to%20properly%20set%20up%20the%20disks%20so%20you%20can%20expand%20them%20in%20a%20pinch%20in%20the%20future.%20In%20this%20episode%20with%20David%20Klee%2C%20we%E2%80%99re%20going%20to%20walk%20through%20how%20to%20use%20this%20service%20to%20set%20up%20your%20object%20volumes%20the%20right%20way%20from%20the%20beginning%20and%20show%20you%20how%20to%20expand%20the%20disks%20with%20no%20outage.%20Break%20out%20your%20pocket%20protectors%20and%20come%20learn%20with%20someone%20who%20was%20compiling%20Linux%20kernels%20while%20in%20elementary%20school!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FB5UA0pZuDKw%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%3E%3CEM%3E%3CBR%20%2F%3EResources%3A%3C%2FEM%3E%3C%2FDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9nHjLEKdd5k%2520%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%242%20Million%20Reasons%20to%20Start%20with%20Tuning%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fdavidklee.net%2F%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDavid%20Klee's%20website%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fheraflux.com%2F%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHeraflux%20Data%20Platform%20Consultants%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Fsqlibrium.com%2F%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESQLlibrium%20Training%3C%2FA%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%3E%3CBR%20%2F%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2562764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201130iE9AAF33173512AF8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20how%20to%20set%20yourself%20up%20with%20storage%20success%20on%20SQL%20Server%20on%20Linux.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2562764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jul 19 2021 08:34 AM
Updated by: