Abstract: Methods for performance evaluation of admission control policies (ACPs) include storing a simulation model including an admission queue and a finite capacity region (FCR), the admission queue admitting queries to the FCR based on an active ACP, the FCR modeling a resource constraint, generating traces, each trace being generated based on processing a single query using the database system, the single query being associated with a query type of a plurality of query types, for each query type, determining a query fork size and a service time from an associated trace to provide a plurality of tuples, each tuple being associated with a query type and including the fork size and the service time associated with the query type, parameterizing the simulation model based on the plurality of tuples, and for each of the ACPs, generating a performance parameter by applying a workload to the simulation model.

Abstract: A topology reader may determine a topology of a Non-Uniform Memory Access (NUMA) architecture including a number of, and connections between, a plurality of sockets, each socket including one or more cores and at least one memory configured to execute a plurality of threads of a software application. A core list generator may generate, for each designated core of the NUMA architecture, and based on the topology, a proximity list listing non-designated cores in an order corresponding to a proximity of the non-designated cores to the designated core. A core selector may determine, at a target core and during the execution of the plurality of threads, that the target core is executing an insufficient number of the plurality of threads, and may select a source core at the target core, according to the proximity list associated therewith, for subsequent transfer of a transferred thread from the selected source core to the target core for execution thereon.

Abstract: Methods for performance evaluation of admission control policies (ACPs) include storing a simulation model including an admission queue and a finite capacity region (FCR), the admission queue admitting queries to the FCR based on an active ACP, the FCR modeling a resource constraint, generating traces, each trace being generated based on processing a single query using the database system, the single query being associated with a query type of a plurality of query types, for each query type, determining a query fork size and a service time from an associated trace to provide a plurality of tuples, each tuple being associated with a query type and including the fork size and the service time associated with the query type, parameterizing the simulation model based on the plurality of tuples, and for each of the ACPs, generating a performance parameter by applying a workload to the simulation model.

Abstract: A topology reader may determine a topology of a Non-Uniform Memory Access (NUMA) architecture including a number of, and connections between, a plurality of sockets, each socket including one or more cores and at least one memory configured to execute a plurality of threads of a software application. A core list generator may generate, for each designated core of the NUMA architecture, and based on the topology, a proximity list listing non-designated cores in an order corresponding to a proximity of the non-designated cores to the designated core. A core selector may determine, at a target core and during the execution of the plurality of threads, that the target core is executing an insufficient number of the plurality of threads, and may select a source core at the target core, according to the proximity list associated therewith, for subsequent transfer of a transferred thread from the selected source core to the target core for execution thereon.