|Papers Topic List|
|May 2010||Staying Highly Available using SASŪ Grid Manager: The Performance Management Application at Commerzbank AG (PDF)
This paper discusses some of the challenges and achievements of this project. The main software components used and discussed are the SAS Grid Manager 9.2 and the SAS Scalable Performance Data Server 4.5.
|May 2010||SASŪ Scalable Performance Data ServerŪ: Star Schema Support (PDF)
This paper covers important areas relevant to the SAS Scalable Performance Data Server star schema support.
|June 2009||Best Practices for Configuring your IO Subsystem for SAS Scalable Performance Data Server Tables (PDF)
This paper is designed to augment earlier papers (referenced in this document) and only covers additional information that pertains to SAS SPD Server tables. You may want to read Best Practices for Configuring your IO Subsystem before reading this paper.
|March 2008||Managing large Data with SAS SPD Server (PDF)
This paper provides the concepts behind demonstrations of how you can enhance query performance when you use the SAS SPD Server to manage large data tables.
|September 2007||Scalability Solution for SAS Dynamic Cluster Tables: SAS Scalable Performance Data Server 4.3 and Later (PDF)
This paper provides an overview of dynamic cluster tables in SAS Scalable Performance Data Server 4.3 as well as enhancements that have been included in later releases. Dynamic cluster tables enable both the partitioning of data based on criteria in the data and parallel loading of the cluster tables.
|October 2006||Partitioning of SAS Scalable Data Server Tables (PDF)
This paper is an overview on setting and controlling the data partition size of SAS Scalable Performance Data Server (SAS SPD Server) tables. Setting and controlling the partition size are the most basic functions for managing data tables that are stored with the SAS SPD Server. The paper discusses partitioning standard SAS SPD Server tables and then uses the discussion as a basis to develop an understanding of how to partition dynamic cluster tables.
|March 2006||SAS Scalable Performance Data Server 4.3 TSM1: (PDF)
This paper discusses the coverage, restrictions, tuning, and performance benefits of the Parallel Join Facility and the enhanced GROUP BY method in the SAS SPD Server 4.3 TSM1 release. This paper assumes a basic understanding of SAS SPD Server tables and concepts of data partitioning, symmetric multiprocessing, and configuring disk for I/O scalability. Knowledge of SQL and joins is also recommended.