大网数据广告活动
磁盘与文件系统

I/O Parameters

· 52CE 我爱测

Learn more about: I/O Parameters

Applies to: Windows | Windows Server

I/O Parameters

This topic contains parameters that are used for input and output (I/O).

JET_paramAccessDeniedRetryPeriod
53

Windows XP and later:  This parameter configures the duration of time (in milliseconds) that the database engine will use to access a file that is locked before failing with JET_errFileAccessDenied. This time delay is designed to work around anti-virus software that may hold some of the database engine's files open briefly after they are closed.

Note  As a result of the above retry logic, any attempt to attach to a database or use a log file that is already in use by the database engine will result in a delay of this size before the API call returns a (legitimate) failure. This parameter can be used to turn down that delay in case this is a common scenario.

Label Value
Default Value: 10000
Type: Integer
Valid Range: 0 – 4294967295
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: Yes
Affects Physical Layout: No
Affects Reliability: Yes
Affects Performance: Yes
Affects Resources: No
Availability: Windows XP and later

JET_paramCreatePathIfNotExist
100

When this parameter is set to true then any folder that is missing in a file system path in use by the database engine will be silently created. Otherwise, the operation that uses the missing file system path will fail with JET_errInvalidPath.

Label Value
Default Value: False
Type: Boolean
Valid Range: False, True
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: Yes
Affects Reliability: No
Affects Performance: No
Affects Resources: No
Availability: All

JET_paramEnableFileCache
126

When this parameter is True, the database engine will use the Windows file cache as a read cache for all of its various files. It will also use it as a write cache for the temporary database or for databases that are opened with recovery disabled. The database engine must disable write caching for ordinary databases, transaction log files, and checkpoint files to protect the transactional integrity of the databases.

It is important to note that the use of the Windows file cache will add a second layering of caching for database files. The database cache will still use its own memory to cache the database files. The intent of this mode is to allow the application to configure the database engine with a small dedicated cache and to allow Windows to donate spare memory to further improve the caching of database data.

Label Value
Default Value: False
Type: Boolean
Valid Range: False, True
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: No
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: Yes
Availability: Windows Vista and later

JET_paramIOPriority
152

This parameter controls how ESE handles I/O operations. The values can be set to 0 (JET_IOPriorityNormal) for normal operation, or 1 (JET_IOPriorityLow) for low priority operation. When the priority is set to JET_IOPriorityLow, ESE uses the new thread I/O priority functionality available in Windows Vista to reduce the I/O priority on the thread so that subsequent I/O operations are issued at the new low priority.

Windows Vista:  JET_paramIOPriority is introduced in Windows Vista.

Label Value
Default Value: 0
Type: Integer
Valid Range: 0 - 1
Scope: Instance
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: Yes
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: No
Availability: Windows Vista

JET_paramOutstandingIOMax
30

This parameter controls how many database file I/Os can be queued in the host operating system at one time.

A larger value for this parameter can significantly help the performance of a large database application.

Windows XP and Windows Server 2003:  This parameter is ignored on Windows XP and Windows Server 2003 and does not affect the operation of the database engine.

Label Value
Default Value: Windows 2000:   64Windows Vista:   1024
Type: Integer
Valid Range: Windows 2000:  8 – 2147483647Windows Vista:  0 – 65536
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: No
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: Yes
Availability: All

JET_paramMaxCoalesceReadSize
164

Maximum number of bytes that can be grouped for a coalesced read operation.

Label Value
Default Value: 262144
Type: Integer
Valid Range: 0-1073741824
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: No
Availability: Windows 7

JET_paramMaxCoalesceWriteSize
165

Maximum number of bytes that can be grouped for a coalesced write operation.

Label Value
Default Value: 393216
Type: Integer
Valid Range: 0-1073741824
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: No
Availability: Windows 7

JET_paramMaxCoalesceReadGapSize
166

Maximum number of bytes that can be gapped for a coalesced write I/O operation.

Label Value
Default Value: 262144
Type: Integer
Valid Range: 0-1073741824
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: No
Availability: Windows 7

JET_paramMaxCoalesceWriteGapSize
167

Max number of bytes that can be gapped for a coalesced read I/O operation.

Label Value
Default Value: 393216
Type: Integer
Valid Range: 0-1073741824
Scope: Global
Set After <a href="gg269354(v=exchg.10).md">JetCreateInstance</a>: Yes
Set after <a href="gg294068(v=exchg.10).md">JetInit</a>: No
Affects Physical Layout: No
Affects Reliability: No
Affects Performance: Yes
Affects Resources: No
Availability: Windows 7

Requirements

Requirement Value
Client Requires Windows Vista, Windows XP, or Windows 2000 Professional.
Server Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.
Header Declared in Esent.h.

See Also

JetCreateInstance
JetInit

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 04/11/2016
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。