Using the SAS Scalable Performance Data Server

Duration: 3.0 days
Course fee:
EPTO units: .
CEUs: 1.8

Available for on-site training or can be scheduled at any SAS training facility if demand warrants.

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

Expand/Collapse All Expand All Collapse All Print version

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

This course addresses SAS Scalable Performance Data Server.

Course Materials

Students receive a hardcopy of the course notes.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers