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:
🔗
▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬
📖 Recommended Learning Path for Azure
🔗
🥇 Certification Content Repository
🔗
📅 Weekly Azure Update
🔗
☁ Azure Master Class
🔗
⚙ DevOps Master Class
🔗
💻 PowerShell Master Class
🔗
🎓 Certification Cram Videos
🔗
🧠 Mentoring Content
🔗
❔ Questions? Maybe I answered it in my FAQ
🔗
👕 Cure Childhood Cancer Charity T-Shirt Channel Store
🔗
👂 Enable the subtitles and from there you can translate to your native language via the auto-translate feature in settings! for a demo of using this feature.
SUBSCRIBE ✅
#Azure #sql #johnsavillstechnicaltraining
[ad_2]
source
Hey everyone, time to understand how Hyperscale works and where we can use it! Please make sure to read the description for the chapters and key information about this video and others.
⚠ P L E A S E N O T E ⚠
🔎 If you are looking for content on a particular topic search the channel. If I have something it will be there!
🕰 I don't discuss future content nor take requests for future content so please don't ask 😇
🤔 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.
👂 Translate the captions to your native language via the auto-translate feature in settings! https://youtu.be/v5b53-PgEmI for a demo of using this feature.
Thanks for watching!
🤙
Hi John, loved this video so much that I watched it twice 🙂 great explanation and deeper dive into this architecture option for Azure SQL
I see myself using it in no time
This was the best video on Hyperscale I have seen. Thanks!
Awesome video as always. 😎
Eye opening, thank you!
Thing is, when would you want to failover, other than if the data center or region was down? — in which case a Microsoft-managed failover will work just fine.