Resources

SAS Technical Papers » Performance

Papers Topic List 
Date Title
March 2017 Advisory Regarding SAS® Grid Manager with Isilon (PDF)
This technical paper outlines the best practices regarding SAS® Grid Manager with Isilon Storage.
December 2014 Performance and Tuning Considerations for SAS on EMC Isilon S200 Storage Nodes (PDF)
This technical paper will outline performance test results performed by SAS, and general considerations for setup and tuning to maximize SAS Application performance with clustered Isilon S200 storage nodes.
November 2014 Performance and Tuning Considerations for SAS on the EMC XtremIO All-Flash Array (PDF)
This technical paper will outline performance test results performed by SAS, and general considerations for setup and tuning to maximize SAS Application performance with EMC XtremIO arrays.
August 2014 Performance and Tuning Considerations for SAS on PURE Storage FA-420 Flash Array (PDF)
This technical paper will outline performance test results performed by SAS, and general considerations for setup and tuning to maximize SAS Application performance with Pure Storage FA-420 arrays.
July 2014 Performance and Tuning Considerations for SAS on NETAPP EF550 Flash Array (PDF)
This technical paper will outline performance test results performed by SAS, and general considerations for setup and tuning to maximize SAS Application performance with NETAPP EF550 flash storage arrays.
February 2014 Best Practices for SAS® on EMC VNX Unified Storage (PDF)
An overview of the EMC VNX unified storage system will be discussed, including physical and virtual architecture, pooling and virtualization, storage tiers and management. This will be followed by a list of practical recommendations for implementation with SAS.
March 2014 Performance and Tuning Considerations for SAS® on Fusion-io ioScale Flash Storage (PDF)
This technical paper will outline performance test results performed by SAS, and general considerations for setup and tuning to maximize SAS Application performance with Fusion Flash Storage.
March 2014 Performance and Tuning Considerations for SAS® on Fusion-io ION Accelerator (PDF)
This technical paper will outline performance test results performed by SAS, and general considerations for setup and tuning to maximize SAS Application performance with the Fusion-io ION Accelerator.
October 2013 Technical Paper: Data Modeling Considerations in Hadoop and Hive (PDF)
This paper explores the techniques used for data modeling in a Hadoop environment as well as a data partition strategy and an investigation into the role that indexing, data types, files types, and other data architecture decisions play in designing data structures in Hive.
April 2013 Best Practices for SAS® on EMC SYMMETRIX VMAX Storage (PDF)
This paper documents best practices for architectural setup and tuning to maximize SAS Application performance with EMC SYMMETRIX VMAX storage.
July 2012 SAS® Foundation 9.3 on Oracle SPARC T4 Server: An I/O Performance and Tuning Summary (PDF)
This paper documents a study on how to improve I/O for intensive SAS workloads running on Oracle SPARC T4 and Solaris 11. Oracle has released a new version of the T-series SPARC processor (T4) with an enhanced floating point capability, and testing shows it can be used effectively for SAS Foundation workloads and the middle tier. Previous versions of this processor (T1 and T2) were aimed primarily at middle-tier or Web-based workloads.
May 2012 Technical Paper: Optimize ETL for the Banking DDS (PDF)
This paper discusses techniques to optimize ETL for the banking DDS to SAS solution data marts when the banking DDS is stored in a relational database other than SAS. These techniques can also be used as general methods for how SAS Data Integration Studio ETL jobs can be run in a database.
June 2011 SAS® on Red Hat Enterprise Linux 6 (RHEL6) Tuning Guidelines (PDF)
June 2011 SAS® on Red Hat Enterprise Linux 5 (RHEL5) Tuning Guidelines (PDF)
March 2009 Improving SAS I/O Throughput by Avoiding the Operating System File Cache (PDF)
This paper will discuss when the use of SGIO and DIO is appropriate and how to specify and tune the two capabilities. In addition, the paper will present examples of potential system I/O throughput improvement, which can be very significant.
March 2009 In-Database Procedures with Teradata: How They Work and What They Buy You (PDF)
This paper discusses when the use of SGIO and DIO is appropriate and how to specify and tune the two capabilities. In addition, the paper will present examples of potential system I/O throughput improvement, which can be very significant.
March 2009 Maximizing the Performance of Your SAS Solution: Case Studies in Web Application Server Tuning for n-tier SAS Applications (PDF)
This paper follows a basic flow, which starts with an examination of the methods that are required to make the current single Java Web Application Server more responsive and more robust. It focuses on topics that are relevant for administrators, architects, and implementers of SAS solutions.
March 2009 Top Ten SAS DBMS Performance Boosters for 2009 (PDF)
Gleaned from internal development efforts and SAS technical support, this paper tracks the top ten performance options, code snips, and processes to increase your access speed to your data. Focus will be around both DATA step and solution performance enhancements against a variety of database management systems (DBMSs).
March 2008 New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database (PDF)
This paper presents the major SQL optimizations that have been added to PROC SQL to enhance its performance for SAS 9.2. These optimizations are the result of analyzing SQL queries generated by SAS clients and solutions, and finding new and innovative ways to squeeze out more performance.
November 2007 Configuring EMC CLARiiON for SAS Business Intelligence Platforms (PDF)
Deploying SAS applications optimally with data stored on EMC CLARiiON systems requires a close collaboration between SAS application programmers, database administrators, and storage administrators. Understanding how SAS typically drives I/O from the server environment and how CLARiiON works internally in servicing different types of I/O patterns is the key to enabling that effective collaboration.
January 2007 ETL Performance Tuning Tips (PDF)
As data volumes grow and the windows of time that ETL (extract, transform, and load) jobs are allowed to run shrink, ETL developers are faced with the challenge of creating highly efficient ETL jobs. Well-performing ETL jobs is a requirement. This paper provides important ETL performance, tuning, and capacity information for SAS®9 and SAS Data Integration Studio. ETL concepts are introduced and ETL performance topics are covered in depth and with examples as needed. Topics include how to analyze and debug flows, gain efficiency quickly, set up the system environment, and, when necessary, customize advanced performance techniques.
May 2005 IBM and SAS: Working Together to Promote Business Innovations with Grid Computing (PDF)
By combining IBM and SAS' leadership in the IT field, we can provide value-added solutions, state-of-the-art technologies, and extensive knowledge and experience to our mutual customers to solve their increasingly complex computing requirements.