Using the SAS Scalable Performance Data Server

Duration:

3 days

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

• 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.