Alter Configuration
Table of Contents
Overview
Alters the value of a system parameter while the engine is running.
Example:
ALTER CONFIGURATION WITH (DeferredIOEnabled = true, CacheMaxMemory = 1024)
Configuration Items
- BaseAddress
- DataRootPath
- TransactionDataPath
- LogDirectory
- FlushLog
- DefaultDocumentPageSize
- UseCompression
- HealthMonitoringEnabled
- HealthMonitoringChekpointSeconds
- HealthMonitoringInstanceLevelEnabled
- HealthMonitoringInstanceLevelTimeToLiveSeconds
- MaxIdleConnectionSeconds
- DefaultIndexPartitions
- DeferredIOEnabled
- WriteTraceData
- CacheEnabled
- CacheMaxMemory
- CacheScavengeInterval
- CachePartitions
- CacheSeconds
Related
- Keywords - A breakdown of all high-level statements available via the query handler.