Windows 2000: On Windows 2000, this parameter should be set to a value roughly equal to four times the number of threads that will be inside the ESE API at the same time. ![]() The size is in database pages.īy default, the database cache will automatically adjust its size between the limits set by JET_paramCacheSizeMin and JET_paramCacheSizeMax. ![]() This parameter configures the minimum size of the database page cache. This size can be used by the application as an input to drive its manual adjustment of the cache size. When this parameter is read, the actual size of the cache in database pages is returned. Note The cache size is still subject to the limits imposed by JET_paramCacheSizeMin and JET_paramCacheSizeMax. The cache will then hold its size at that threshold until given a new size or until it is released to choose its own size. However, if the application sets this parameter to a non-zero value then the cache will adjust itself to that target size (in database pages). If the application sets this parameter to zero, then the cache will tune its own size in this manner. Ordinarily, the cache will automatically tune its size as a function of database and machine activity levels. This parameter can be used to control the size of the database page cache at run time. Windows XP and later: This parameter is obsolete and does not affect the operation of the database engine. ![]() This parameter controls the size of an auxiliary part of the database page cache that is used to simulate scatter gather I/O when it is otherwise not available. This topic contains parameters that are used for the database cache. Applies to: Windows | Windows Server Database Cache Parameters
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |