Muutke küpsiste eelistusi

E-raamat: Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data Workloads

,
  • Formaat: PDF+DRM
  • Ilmumisaeg: 21-Mar-2023
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484292259
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 67,91 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data WorkloadsSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 21-Mar-2023
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484292259
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Take a deep dive into the Azure SQL Database Hyperscale Service Tier and discover a new form of cloud architecture from Microsoft that supports massive databases. The new horizontally scalable architecture, formerly code-named Socrates, allows you to decouple compute nodes from storage layers. This radically different approach dramatically increases the scalability of the service. This book shows you how to leverage Hyperscale to provide next-level scalability, high throughput, and fast performance from large databases in your environment.

The book begins by showing how Hyperscale helps you eliminate many of the problems of traditional high-availability and disaster recovery architecture. You’ll learn how Hyperscale overcomes storage capacity limitations and issues with scale-up times and costs. With Hyperscale, your costs do not increase linearly with database size and you can manage more data than ever at a lower cost.

The book teaches you how to deploy, configure, and monitor an Azure SQL Hyperscale database in a production environment. The book also covers migrating your current workloads from traditional architecture to Azure SQL Hyperscale. 


What You Will Learn
  • Understand the advantages of Hyperscale over traditional architecture
  • Deploy a Hyperscale database on the Azure cloud (interactively and with code)
  • Configure the advanced features of the Hyperscale database tier
  • Monitor and scale database performance to suit your needs
  • Back up and restore your Azure SQL Hyperscale databases
  • Implement disaster recovery and failover capability
  • Compare performance of Hyperscale vs traditional architecture
  • Migrate existing databases to the Hyperscale service tier

Who This Book Is For

SQL architects, data engineers, and DBAs who want the most efficient and cost-effective cloud technologies to run their critical data workloads, and those seeking rapid scalability and high performance and throughput while utilizing large databases


Intermediate user level
About the Authors xi
About the Technical Reviewers xiii
Introduction xv
Part I Architecture
1(74)
Chapter 1 The Journey to Hyperscale Architecture in Azure SQL
3(34)
SQL on Azure
5(2)
The Basics of Azure SQL
5(2)
Azure SQL Platform as a Service
7(15)
Deployment Models
9(1)
Purchasing Models and Service Tiers
10(3)
Availability Models and Redundancy
13(2)
Standard Availability Model: Locally Redundant Availability
15(1)
General Purpose Service Tier: Zone-Redundant Availability
16(2)
Premium and Business Critical Service Tier: Locally Redundant Availability
18(1)
Premium and Business Critical Service Tier: Zone-Redundant Availability
19(2)
Protecting Against Regional Outages Using Failover Groups with Geo-redundant Availability
21(1)
The Hyperscale Service Tier
22(13)
Hyperscale Architecture Overview
24(1)
Deploying Your First Hyperscale Database
25(9)
Cleaning Up
34(1)
Summary
35(2)
Chapter 2 Azure SQL Hyperscale Architecture Concepts and Foundations
37(38)
Hyperscale Azure SQL Scalability and Durability
38(2)
Foundations of Azure SQL Hyperscale
40(9)
The Buffer Pool Extension
41(1)
The Resilient Buffer Pool Extension
41(1)
Investigating the Size of RBPEX
41(4)
Row Versioning-Based Isolation Level
45(3)
Accelerated Database Recovery
48(1)
Multitier Architecture Concepts in Hyperscale
49(25)
Compute Nodes
50(8)
Log Service
58(3)
Page Servers
61(7)
Azure Standard Storage
68(2)
How Do the Tiers Work Together?
70(4)
Summary
74(1)
Part II Planning and Deployment
75(264)
Chapter 3 Planning an Azure SQL DB Hyperscale Environment
77(48)
Considerations When Planning for Hyperscale
77(47)
The Azure SQL Database Logical Server
78(3)
Considerations for Reliability
81(13)
Considerations for Network Connectivity
94(14)
Considerations for Security
108(11)
Considerations for Operational Excellence
119(5)
Summary
124(1)
Chapter 4 Deploying a Highly Available Hyperscale Database into a Virtual Network
125(34)
An Example Hyperscale Production Environment
126(3)
The Starting Environment
129(10)
The Starting Environment Deployment Script
131(2)
Deploying the Starting Environment Using the Azure Cloud Shell
133(3)
Creating a SQL Administrators Group
136(3)
Deploying a Highly Available Hyperscale Database into a Virtual Network
139(16)
Basic Configuration of the Database
141(5)
Configuring Network Connectivity
146(4)
The Final Configuration Tasks and Deployment
150(5)
Deleting the Example Environment
155(2)
Summary
157(2)
Chapter 5 Administering a Hyperscale Database in a Virtual Network in the Azure Portal
159(12)
Administering a Hyperscale Database in a Virtual Network
160(10)
Deploying a Management VM and Azure Bastion
163(4)
Using the Management VM with an Azure Bastion
167(3)
Summary
170(1)
Chapter 6 Configuring Transparent Data Encryption to Bring Your Own Key
171(16)
Enabling Customer-Managed Key Transparent Data Encryption
172(13)
Creating a User-Assigned Managed Identity
174(1)
Granting the Key Vault Crypto Officer Role to a User
175(3)
Generating a Key in the Azure Key Vault
178(2)
Granting Access to the Key by the User-Assigned Managed Identity
180(2)
Assigning the User-Assigned Managed Identity to the Logical Server
182(2)
Enabling Customer-Managed TDE
184(1)
Summary
185(2)
Chapter 7 Enabling Geo-replication for Disaster Recovery
187(16)
Deploying a Hyperscale Geo Replica
188(12)
Creating a Logical Server in the Failover Region
189(2)
Connecting a Logical Server to a Virtual Network with Private Link
191(5)
Enabling the Customer-Managed Key TDE
196(2)
Enabling Geo-replication of a Hyperscale Database
198(2)
Summary
200(3)
Chapter 8 Configuring Security Features and Enabling Diagnostic and Audit Logs
203(10)
Enabling Microsoft Defender for SQL
204(2)
Storing Diagnostic and Audit Logs
206(5)
Sending Audit Logs to a Log Analytics Workspace
207(2)
Sending Database Diagnostic Logs to Log Analytics
209(2)
Summary
211(2)
Chapter 9 Deploying Azure SQL DB Hyperscale Using PowerShell
213(28)
Introduction to Infrastructure as Code
214(1)
Imperative vs. Declarative Infrastructure as Code
215(1)
Deploying Hyperscale Using Azure PowerShell
216(23)
The Azure PowerShell Modules
216(2)
Deploying the Starting Environment
218(1)
The Complete Deployment PowerShell Script
218(2)
Azure PowerShell Commands in Detail
220(19)
Summary
239(2)
Chapter 10 Deploying Azure SQL DB Hyperscale Using Bash and Azure CLI
241(26)
Deploying Hyperscale Using the Azure CLI
241(23)
The Azure CLI
242(1)
Deploying the Starting Environment
243(2)
The Complete Deployment Bash Script
245(2)
Azure CLI Commands in Detail
247(17)
Summary
264(3)
Chapter 11 Deploying Azure SQL DB Hyperscale Using Azure Bicep
267(18)
About Azure Bicep
268(1)
Deploying Using Azure Bicep
268(16)
A Complete Azure Bicep Deployment
268(3)
Hyperscale Resources in Azure Bicep
271(13)
Summary
284(1)
Chapter 12 Testing Hyperscale Database Performance Against Other Azure SQL Deployment Options
285(54)
HammerDB
286(50)
HammerDB TPROC-C Workload
287(1)
HammerDB Step-by-Step
287(14)
Schema Build Performance Metrics
301(11)
TPROC-C Workload Metrics
312(24)
Summary
336(3)
Part III Operation and Management
339(68)
Chapter 13 Monitoring and Scaling
341(20)
Monitoring Platform Metrics
342(9)
Viewing Metrics with the Metrics Explorer
342(2)
Streaming Metrics to a Log Analytics Workspace
344(1)
Alerting on Platform Metrics
345(6)
Monitoring and Tuning Database Performance
351(2)
Monitoring Query Performance
351(1)
Performance Recommendations
352(1)
Automatically Tuning Database Performance
352(1)
Gathering Insights from the Database
353(1)
SQL Analytics
354(3)
Scaling a Hyperscale Database
357(3)
Manually Scaling Up a Hyperscale Database
358(1)
Manually Scaling Out a Hyperscale Database
359(1)
Autoscaling a Hyperscale Database
360(1)
Summary
360(1)
Chapter 14 Backup, Restore, and Disaster Recovery
361(20)
Hyperscale Database Backups
361(7)
Backup Retention Policy
362(3)
Backup Storage Redundancy
365(2)
Monitoring Backup Storage Consumption with Azure Monitor Metrics
367(1)
Hyperscale Database Restores
368(9)
Example 1 Restore to Same Region, LRS to LRS
369(2)
Example 2 Restore to Same Region, LRS to GRS
371(1)
Example 3 Restore to the Same Region, GRS to GRS
372(1)
Example 4 Geo Restore to Different Region, GRS to LRS
372(1)
Example 5 Geo-restore to Different Region, GRS to GRS
373(2)
Comparing Restore Performance of Hyperscale to Traditional Azure SQL Databases
375(2)
Disaster Recovery
377(2)
Summary
379(2)
Chapter 15 Security and Updating
381(18)
Azure SQL Database Security Overview
381(15)
Network Security
384(3)
Access Management
387(3)
Auditing and Azure Threat Detection
390(2)
Information Protection
392(4)
Updating and Maintenance Events
396(2)
Summary
398(1)
Chapter 16 Managing Costs
399(8)
Azure Hybrid Benefit
399(2)
Reserving Capacity
401(2)
Purchasing Reserved Capacity
401(1)
Estimating Reserved Capacity Benefits
402(1)
Utilizing Reservations
402(1)
Scaling In and Scaling Down Replicas
403(2)
Summary
405(2)
Part IV Migration
407(54)
Chapter 17 Determining Whether Hyperscale Is Appropriate
409(10)
Key Considerations for Hyperscale
409(9)
Scalability
410(3)
Reliability
413(1)
Business Continuity
413(3)
Cost
416(2)
Summary
418(1)
Chapter 18 Migrating to Hyperscale
419(30)
Common Migration Methods
419(28)
In-Place Conversion of an Azure SQL Database to Hyperscale
421(4)
Migrating to Hyperscale with Data Migration Assistant
425(7)
Migrating to Hyperscale with the Azure Database Migration Service
432(11)
Migrating with ADS with the Azure SQL Migration Extension
443(1)
Migrating to Hyperscale Using Import Database
444(2)
Migrating to Hyperscale Using a Data Sync and Cutover
446(1)
Summary
447(2)
Chapter 19 Reverse Migrating Away from Hyperscale
449(10)
Reverse Migration Methods
450(6)
Reverse Migration Using the Azure Portal
450(3)
Reverse Migration Using Transact SQL
453(1)
Reverse Migration Using Azure CLI
454(2)
Common Pitfalls of the Reverse Migration Process
456(1)
Migrating to an Unsupported Service Tier
456(1)
Database Not Eligible for Reverse Migration
457(1)
Summary
457(2)
Chapter 20 Conclusion
459(2)
Index 461
Zoran Bara is a cloud architect and data specialist with more than 15 years of hands-on experience in data optimization, administration, and architecture. He is a Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a masters degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is his passion. He is also an organizer of the Auckland SQL User Meetup Group, an active blogger, and speaker at different SQL events such as Data Summits, SQL Saturdays, SQL Fridays, Meetups, etc. Daniel Scott-Raynsford is a Partner Technology Strategist at Microsoft with 15 years of experience as a software developer and solution architect. He specializes in DevOps and continuous delivery practices. He was a Microsoft MVP in Cloud and Datacenter Management for three years before joining Microsoft and is an active PowerShell open source contributor and Microsoft DSC Community Committee member. He is also a contributor to the Azure Architecture Center on multi-tenant architecture practices.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842922592e.html
Märksõnad: