SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 139 / 271

Work space refers to the area on disk that SPD Server software uses to store required files
when the available CPU memory cannot contain the entire set of calculations. During events
like these, some utility files are written to disk. Work space is important to scalability.
Tasks such as large sorts, index creation, parallel group-by operations, and SQL joins can
require dedicated work space to store temporary utility files.
Work space is typically configured as part of a large striped file system that spans as many
disks and I/O channels as possible. Workspace I/O can critically impact the performance
behavior of an SPD Server host.
Work space on disk is typically a RAID 0 configuration or some hardware-redundant RAID
design. RAID 0 configurations are risky to the extent that if the RAID 0 disk goes down,
the system will also be affected and any process that was running at the time of failure will
probably be affected.
Domains and Data Spaces
Overview of Domains and Data Spaces
SPD Server is a tool that can be configured to meet different organizational data
requirements. When an organization needs different types of SPD Server domain space,
administrators can use domain declarations in the
libnames.parm file to configure spaces
that balance processing speed, space, and growth needs with data security requirements.
Typically, SPD Server users use most or all of the types of table spaces. The type of queries
and reports that the user makes can indicate the type (or types) of data space that the user
needs. There are three basic types of domain space.
Overview of Domains and Data Spaces
133