I/O Parameters

Windows

Last modified: January 09, 2012

Applies to: Windows | Windows Server

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.

Default Value:

10000

Type:

Integer

Valid Range:

0 – 4294967295

Scope:

Global

Set After JetCreateInstance:

Yes

Set after JetInit:

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.

Default Value:

False

Type:

Boolean

Valid Range:

False, True

Scope:

Instance

Set After JetCreateInstance:

Yes

Set after JetInit:

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.

Default Value:

False

Type:

Boolean

Valid Range:

False, True

Scope:

Global

Set After JetCreateInstance:

No

Set after JetInit:

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.

Default Value:

0

Type:

Integer

Valid Range:

0 - 1

Scope:

Instance

Set After JetCreateInstance:

Yes

Set after JetInit:

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.

Default Value:

Windows 2000:   64

Windows Vista:   1024

Type:

Integer

Valid Range:

Windows 2000:  8 – 2147483647

Windows Vista:  0 – 65536

Scope:

Global

Set After JetCreateInstance:

No

Set after JetInit:

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.

Default Value:

262144

Type:

Integer

Valid Range:

0-1073741824

Scope:

Global

Set After JetCreateInstance:

Yes

Set after JetInit:

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.

Default Value:

393216

Type:

Integer

Valid Range:

0-1073741824

Scope:

Global

Set After JetCreateInstance:

Yes

Set after JetInit:

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.

Default Value:

262144

Type:

Integer

Valid Range:

0-1073741824

Scope:

Global

Set After JetCreateInstance:

Yes

Set after JetInit:

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.

Default Value:

393216

Type:

Integer

Valid Range:

0-1073741824

Scope:

Global

Set After JetCreateInstance:

Yes

Set after JetInit:

No

Affects Physical Layout:

No

Affects Reliability:

No

Affects Performance:

Yes

Affects Resources:

No

Availability:

Windows 7

Requirements

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

Show:
© 2015 Microsoft