SAS Technical Papers » Performance
Papers Topic List |
| Date | Title | File Size |
| March 2009 | Improving SAS I/O Throughput by Avoiding the Operating System File Cache (PDF) n this paper, we review selected enhancements that are being made to SAS procedure statements in Base SAS, SAS/STAT, and SAS Enterprise Miner, and how these procedures affect the distribution of work between SAS and Teradata. A summary of the performance characteristics of these enhanced procedures is also discussed. |
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 |