Using the SAS Scalable Performance Data Server

Duration: 3.0 days CEU: 1.8

This course provides an overview of SAS Scalable Performance Data Server (SPD Server) architecture and data and index storage. This course also covers installing the SPD Server, using the SQL Pass-Through Facility, and optimizing SPD Server's use of resources.

Learn how to

install the SPD Server under UNIX and Windows
configure the SPD Server
administer and maintain the SPD Server
store and load data in the SPD Server
create and store indexes in the SPD Server
use the SQL Pass-Through Facility
optimize SPD Server performance.

Who should attend

SAS programmers, UNIX or Windows administrators, and administrators of the SAS Scalable Performance Data Server under Windows or UNIX

Prerequisites

Before attending this course, you should

be able to write SAS programs
understand the basics of your operating system
understand the basics of parallel processing
understand the basics of RAID arrays and/or Storage Area Networks.

Course Contents

Introduction to the SAS Scalable Performance Data Server

overview of SPD Server
SAS data sets used in the SPD Server class

Scalable Performance Data Server Architecture

connecting to SPD Server with a SAS client
investigating a client other than a SAS client
parallel processing

Installation of the SAS Scalable Performance Data Server (Self-Study)

installing SPD Server on UNIX
installing SPD Server on Windows
testing and troubleshooting

Configuring the SAS Scalable Performance Data Server

the SPD server parameter file
physical disk setup
the LIBNAME parameter file
troubleshooting
auditing SPD Server

Administration and Maintenance of SPD Server

overview of SPD Server Security
administering SPD Server using the SAS Management Console
administering Access Control Lists using the SAS Management Console
administering SPD Server using the SPD Server Account Manager
administering Access Control Lists using the SPDO procedure

Storing and Loading Data in the SAS Scalable Performance Data Server

data storage
partioning data
using the LIBNAME statement
loading data
SPD Server Compression
cluster tables

Creating and Storing Indexes in SPD Server

investigating the advantages of indexing
differentiating between index files

Using the SQL Procedure

discussing SQL Pass-Through Facility
asynchronous execution
investigate the advantages of parallel GROUP BY
comparing the SQL Pass-Through Facility and the LIBNAME statement

Optimizing Performance (Best Practices)

overview of techniques
sorting SPD Server tables
subsetting SPD Server tables using WHERE clauses
SQL planner optimizations
using the MINMAXVARLIST= table option
scalability testing
reviewing other optimization techniques

Backup and Restore of SAS SPD Server Data WHERE Clause Costing and EVAL Strategies Glossary of Technical Terms Summary of SPD Server Options and Macro Variables

LIBNAME statement options
SPD server macro variables
SPD server table options
SPDSSERV.PARM options

Software Addressed

This course addresses the following software product(s): SAS Scalable Performance Data Server.

Course Materials

Students receive a hardcopy of the course notes.

U.S. Schedule

02FEB2009 Cary, NC

13MAY2009 Chicago, IL

Check for additional and updated schedule information online at support.sas.com/courses/dispds.html.

Registration

To register for this course in the US, call 800-333-7660 or visit support.sas.com/training. This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to training@sas.com.