Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Azure SQL Hyperscale Deep Dive - NOT Just for Massive Databases!

John Savill's Technical Training
318K subscribers
<__slot-el>
<__slot-el>
6K views 6 months ago #Azure #johnsavillstechnicaltraining #sql
A deep dive into Azure SQL Hyperscale which, as we will see, betrays the fact this is a great option for almost every SQL workload, not just those that need huge scale. 🔎 Looking for content on a particular topic? Search the channel. If I have something it will be there! 🤔 Due to the channel growth and number of people wanting help I no longer can answer or even read questions and they will just stay in the moderation queue never to be seen so please post questions to other sites like Reddit, Microsoft Community Hub etc. ▬▬▬▬▬▬ C H A P T E R S ⏰ ▬▬▬▬▬▬ 00:00 - Introduction 01:07 - Regular SQL architecture 02:45 - SQL Hyperscale architecture 03:03 - Components 03:45 - Log Service 05:28 - Page Servers 07:54 - Database storage scale 10:04 - Cache 12:08 - Compute scale 13:18 - Provisioned vCores 17:49 - Scaling the vCores 20:37 - Serverless 23:24 - Replicas 27:25 - Named replicas 29:42 - Geo-replication 33:28 - Elastic pool 38:22 - Per DB mi …...more
...more
Azure SQL Hyperscale Deep Dive - NOT Just for Massive Databases!
190Likes
6,073Views
Oct 72024
A deep dive into Azure SQL Hyperscale which, as we will see, betrays the fact this is a great option for almost every SQL workload, not just those that need huge scale. 🔎 Looking for content on a particular topic? Search the channel. If I have something it will be there! 🤔 Due to the channel growth and number of people wanting help I no longer can answer or even read questions and they will just stay in the moderation queue never to be seen so please post questions to other sites like Reddit, Microsoft Community Hub etc. ▬▬▬▬▬▬ C H A P T E R S ⏰ ▬▬▬▬▬▬ 00:00 - Introduction 01:07 - Regular SQL architecture 02:45 - SQL Hyperscale architecture 03:03 - Components 03:45 - Log Service 05:28 - Page Servers 07:54 - Database storage scale 10:04 - Cache 12:08 - Compute scale 13:18 - Provisioned vCores 17:49 - Scaling the vCores 20:37 - Serverless 23:24 - Replicas 27:25 - Named replicas 29:42 - Geo-replication 33:28 - Elastic pool 38:22 - Per DB min and max vCore 40:27 - Isolation 40:40 - Scaling elastic pool 41:16 - You don't need to know any of this 42:24 - Pricing 43:53 - Huge scale flexibility 44:25 - Other names 45:38 - Close ▬▬▬▬▬▬ K E Y L I N K S 🔗 ▬▬▬▬▬▬ ► Whiteboard: 🔗 https://github.com/johnthebrit/Random... ▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬ 📖 Recommended Learning Path for Azure 🔗 https://learn.onboardtoazure.com 🥇 Certification Content Repository 🔗 https://github.com/johnthebrit/Certif... 📅 Weekly Azure Update 🔗    • Azure Infrastructure Updates   ☁ Azure Master Class 🔗    • Microsoft Azure Master Class v2 (bein...   ⚙ DevOps Master Class 🔗    • DevOps Master Class   💻 PowerShell Master Class 🔗    • PowerShell Master Class   🎓 Certification Cram Videos 🔗    • Microsoft Certification Exam Prep Videos   🧠 Mentoring Content 🔗    • Virtual Mentoring   ❔ Questions? Maybe I answered it in my FAQ 🔗 https://savilltech.com/faq 👕 Cure Childhood Cancer Charity T-Shirt Channel Store 🔗 https://johns-t-shirts-store.creator-... 👂 Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings!    • YouTube Captions and Auto Translate Q...   for a demo of using this feature. SUBSCRIBE ✅    / @ntfaqguy   #Azure #sql #johnsavillstechnicaltraining

Follow along using the transcript.

John Savill's Technical Training

318K subscribers