The performance options
contains the performance parameters for the PERFORMANCE statement
to use the High-Performance Analytics procedure. Currently only the
Teradata and Greenplum database types support High-Performance Analytics.
The PERFORMANCE statement
defines performance parameters for multithreaded and distributed computing,
passes variables about the distributed computing environment, and
requests detailed results about the performance characteristics of
a High-Performance Analytics procedure.
The following performance
options can be specified for the PERFORMANCE statement.
|
|
|
|
Specifies an integer
to request that the High-Performance Analytics procedure writes periodic
updates to the SAS log.
|
|
|
Specifies how many processors
that the procedure should assume are available on each host in the
computing environment. You can enter the value of ACTUAL, or enter
an integer between 1 and 256.
|
|
|
Specifies the name of
the server for the database as defined through the hosts file and
as used in the LIBNAME statement.
|
|
|
Requests a table that
shows a timing breakdown of the procedure steps.
|
|
|
Specifies the timeout
in seconds for a High-Performance Analytics procedure to wait for
a connection to the appliance and establish a connection back to the
client.
|
|
|
Specifies the name of
the appliance. If a value for the Host option is specified, it overrides
the value of the grid host environment variable.
|
|
|
Specify the name of
the directory in which the High-Performance Analytics shared libraries
are installed on the appliance.
|
|
|
Specify the name of
the directory in which the High-Performance Analytics shared libraries
are installed on the appliance. If a value is specified for the Installation
directory option, it overrides this option.
|
|
|
Specifies the number
of nodes in the distributed computing environment, provided that the
data is not processed alongside the database. You can enter an integer
or you can specify a value of ALL if you want to use all available
nodes on the appliance without oversubscribing the system.
|
|
|
Specify the number of
threads for analytic computations. This option overrides the SAS system
option THREADS | NOTHREADS. If you do not specify a value for this
option, the number of threads are determined based on the number of
CPUs on the host on which the analytic computations execute.
|
|
|
Specifies the host name
for the grid. If a value for the Host option is specified, it overrides
the value of the grid host environment variable.
|
|
|
Specifies the command
to run a remote shell.
|
|
|
The host name of the
client node to which the grid connects.
|
|
|
Specifies the range
of parts that are permitted by the firewall.
|
|
|
Specifies the local
directory path for the grid node.
|
|
For more information
about High-Performance Analytics, see the
SAS High-Performance
Analytics Server 12.1: User's Guide.