Throughput refers to the volume of work completed in a fixed time period. There are two ways of thinking of throughput:
As a single transaction, for example, 5 UpdateTitle transactions per minute, or
As the entire Adaptive Server, for example, 50 or 500 server-wide transactions per minute
Throughput is commonly measured in transactions per second (tps), but it can also be measured per minute, per hour, per day, and so on.
When you set the various limits for Adaptive Server it means that the server may have to handle large volumes of data for a single query, DML operation, or command. For example, if you use a data-only-locked (DOL) table with a char(2000) column, Adaptive Server must allocate memory to perform column copying while scanning the table. Increased memory requests during the life of a query or command means a potential reduction in throughput
