Alter Configuration

Table of Contents



Alters the value of a system parameter while the engine is running.


round-pushpin Alters the engine configuration enabling deferred IO and setting the max cache size.
ALTER CONFIGURATION WITH (DeferredIOEnabled = true, CacheMaxMemory = 1024)



  • BaseAddress
  • DataRootPath
  • TransactionDataPath
  • LogDirectory
  • FlushLog
  • DefaultDocumentPageSize
  • UseCompression
  • HealthMonitoringEnabled
  • HealthMonitoringChekpointSeconds
  • HealthMonitoringInstanceLevelEnabled
  • HealthMonitoringInstanceLevelTimeToLiveSeconds
  • MaxIdleConnectionSeconds
  • DefaultIndexPartitions
  • DeferredIOEnabled
  • WriteTraceData
  • CacheEnabled
  • CacheMaxMemory
  • CacheScavengeInterval
  • CachePartitions
  • CacheSeconds


SQL::Keywords
A breakdown of all high-level statements available via the query handler.