Usage Note 17759: Solving SAS Performance Problems: Employing Host-Based Tools
Solving SAS Performance Problems: Employing Host-Based Tools,
a paper presented at SUGI 31 (2006) by Tony Brown of the SAS
Performance Lab, is available here:
http://support.sas.com/rnd/scalability/papers/practicalperf.pdf
This paper discusses an iterative, disciplined approach to diagnose
performance problems with the SAS System on Unix and Windows systems.
It details the employment and interpretation of the most commonly
available host-based performance monitors, to help understand what
resource bottlenecks existed during the job run. It also details
how to overlay this information with SAS logs to reconcile episodes
of bad performance on the host and storage systems to the SAS job
steps. This process can help identify the performance restraints
with SAS processes, and in doing so, lead to their quick resolution.
The paper includes attachments that contain a log information macro
that can be used for all operating environments. In addition, there
are attachments that contain individual monitoring scripts for AIX,
HP-UX, Linux, and Solaris.
For your convenience, these scripts are also available from the FTP site:
http://ftp.sas.com/techsup/download/unix/AllScripts.zip
Performance monitoring for Windows is discussed in the text of the paper.
Operating System and Release Information
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP3 | |
| Linux | 9.1 TS1M3 SP3 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 SP3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2006-05-23 17:48:23 |
| Date Created: | 2006-05-23 17:23:36 |