• Print  |
  • Feedback  |

Knowledge Base

SAS Technical Papers » Performance

Papers Topic List 
Date Title File Size
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. 		918 KB
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. 		652 KB
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.		 1.14 MB
June 2011 SAS® on Red Hat Enterprise Linux 6 (RHEL6) Tuning Guidelines (PDF) 165 KB
June 2011 SAS® on Red Hat Enterprise Linux 5 (RHEL5) Tuning Guidelines (PDF) 165 KB
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.		 165 KB
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.		 267 KB
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.		 2.60 MB
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).		 111 KB
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.		 73 KB
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.		 518 KB
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.		 1,799 KB
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. 		943 KB