How do you configure host caching for data disk and log disk for your VM that hosts SQL Server in Azure?
Experience Level: Senior
Tags: Azure CloudAzure SQL DatabaseAzure Virtual Machines
Answer
- Log - None.
- Data - ReadOnly.
Disk caching setting recommendation on when to use this setting
- None - Configure host-cache as None for write-only and write-heavy disks.
- ReadOnly - Configure host-cache as ReadOnly for read-only and read-write disks.
- ReadWrite - Configure host-cache as ReadWrite only if your application properly handles writing cached data to persistent disks when needed.
Related Azure Cloud job interview questions
According to Microsoft Cloud Adoption Framework (CAF), what are the three specific terms related to Management phaze that can help improve conversations among business stakeholders?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are 6 key steps for establishing a management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat is management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are the 5 disciplines of cloud governance according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorIs Cloud Security Posture Management (CSPM) available for all Azure Subscriptions?
Microsoft Defender Junior