Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.

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.

Comments

No Comments Yet.
Be the first to tell us what you think.
Azure SQL Database
Azure SQL Database

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
Azure Virtual Machines
Azure Virtual Machines

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
AZ-304 Microsoft Azure Architect Design Preparation
AZ-304 Microsoft Azure Architect Design Preparation

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself