txn to pss ratio determines the total number of transaction descriptors that are available to the server.
|
Summary Information |
|
|---|---|
|
Default value |
16 |
|
Valid values |
1 – 2147483647 |
|
Status |
Static |
|
Display level |
1 |
|
Required role |
System administrator |
|
Configuration groups |
DTM Administration, Memory Use |
SAP ASE manages transactions as configurable server resources. Each time a new transaction begins, SAP ASE must obtain a free transaction descriptor from a global pool that is created when the server is started. Transaction descriptors are internal memory structures that SAP ASE uses to represent active transactions.
The outer block of each server transaction. The outer block of a transaction may be created explicitly when a client executes a new begin transaction command. SAP ASE may also implicitly create an outer transaction block when clients use Transact-SQL to modify data without using begin transaction to define the transaction.
Each database accessed in a multidatabase transaction. SAP ASE must obtain a new transaction descriptor each time a transaction uses or modifies data in a new database.
# of transaction descriptors = PSS structures * txn to pss ratio
The default value, 16, ensures compatibility with versions of SAP ASE earlier than 12.x which also allocated 16 transaction descriptors for each user connection. In version 12.x and later, the number of simultaneous transactions is limited only by the number of transaction descriptors available in the server.