Summary information |
|
|---|---|
Default value |
The logical page size, in bytes |
Range of values |
The logical page size up to 2147483647 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
User Environment |
session tempdb log cache size specifies the size for each session tempdb log cache. Adaptive Server uses the tempdb log cache to buffer the user transaction log records for the session involving tempdb objects. The size for session tempdb log cache is determined by the Adaptive Server page size. Configuring a reasonable size for session tempdb log cache size can help prevent context switches due to a session having to flush the tempdb user log cache.
Adaptive Server includes two log caches for each user connection: the session tempdb log cache, and the user log cache, which is determined by the user log cache size parameter.
