You are currently browsing legacy 4.0 version of documentation. Click here to switch to the newest 5.1 version.
Configuration: Storage
The following configuration options allow you configure the storage engine.
Storage.TempPath
You can use this setting to specify a different path to temporary files. By default, it is empty, which means that temporary files will be created at same location as data file under the Temp
directory.
- Type:
string
- Default:
null
- Scope: Server-wide or per database
Storage.TransactionsModeDurationInMin
How long transaction mode (Danger/Lazy) lasts before returning to Safe Mode. Value in minutes with default set to 1440 (24 hours). Set value to 0 for infinite.
- Type:
int
- Default:
1440
- Scope: Server-wide or per database
Storage.MaxConcurrentFlushes
Maximum concurrent flushes.
- Type:
int
- Default:
10
- Scope: Server-wide or per database
Storage.TimeToSyncAfterFlushInSec
Time to sync after flush in seconds
- Type:
int
- Default:
30
- Scope: Server-wide or per database
Storage.NumberOfConcurrentSyncsPerPhysicalDrive
Number of concurrent syncs per physical drive.
- Type:
int
- Default:
3
- Scope: Server-wide or per database
Storage.CompressTxAboveSizeInKb
Compress transactions above size (value in KB)
- Type:
int
- Default:
512
- Scope: Server-wide or per database
Storage.ForceUsing32BitsPager
Use the 32 bits memory mapped pager even when running on 64 bits.
- Type:
bool
- Default:
false
- Scope: Server-wide only
Storage.MaxScratchBufferSizeInMb
Maximum size of .buffers
files
- Type:
int
- Default:
256
when running on 64 bits,32
when running on 32 bits orStorage.ForceUsing32BitsPager
is set totrue
- Scope: Server-wide or per database