Storage 101 for Azure SQL and SQL Server Engineers | Data Exposed: MVP Edition

Published 04-27-2021 09:00 AM 760 Views
Microsoft

Why is storage so important for Data Engineering? Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, we will go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database.

Watch on Data Exposed


Resources:
Argenis' blog on IO Block Size
Gianluca's WorkloadTools MVP Edition episode
For any questions, reach out to Argenis and other MVPs on Twitter with #SQLHelp

View/share our latest episodes on Channel 9 and YouTube!
%3CLINGO-SUB%20id%3D%22lingo-sub-2294924%22%20slang%3D%22en-US%22%3EStorage%20101%20for%20Azure%20SQL%20and%20SQL%20Server%20Engineers%20%7C%20Data%20Exposed%3A%20MVP%20Edition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2294924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWhy%20is%20storage%20so%20important%20for%20Data%20Engineering%3F%20Learn%20how%20storage%20impacts%20the%20performance%20of%20your%20database%20solution.%20In%20this%20episode%20with%20MVP%20Argenis%20Fernandez%2C%20we%20will%20go%20over%20the%20basics%20of%20I%2FO%2C%20what%20the%20different%20access%20patterns%20are%20for%20the%20database%20engine%20and%20how%20to%20tell%20when%20there%20is%20an%20issue%20with%20underlying%20storage%20for%20your%20database.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FFMOT4rWf1J8%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%3CA%20href%3D%22https%3A%2F%2Fblog.purestorage.com%2Fpurely-technical%2Fwhat-is-sql-servers-io-block-size%2F%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EArgenis'%20blog%20on%20IO%20Block%20Size%3CBR%20%2F%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FLgVHK9IBXSc%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EGianluca's%20WorkloadTools%20MVP%20Edition%20episode%3CBR%20%2F%3E%3C%2FA%3E%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3EFor%20any%20questions%2C%20reach%20out%20to%20Argenis%20and%20other%20MVPs%20on%20Twitter%20with%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%3E%23SQLHelp%3C%2FSPAN%3E%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%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2294924%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%2F202729i490928FF0C962B7B%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%20about%20the%20basics%20between%20databases%20and%20storage%20concepts%20with%20MVP%26nbsp%3B%3CSPAN%3EArgenis%20Fernandez.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2294924%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Apr 26 2021 01:57 PM
Updated by: