White Papers

Improving SAS I/O Throughput by Avoiding the Operating System File Cache

Category: Data Management, Servers and Server OS

Tags: data

Overview SAS I/O processing (the reading and writing of SAS data files - data sets, catalogs, index files, and so on) is done by default via the UNIX or Windows operating system's file cache. When accessing SAS data files in the multi-gigabyte range, overall system I/O throughput can be negatively affected. One method that might avoid such an I/O bottleneck is to avoid the operating system's file cache by using the SGIO SAS parameter (that was introduced with SAS 8) or the new DIO SAS parameter (that has been added to SAS 9.2 on several UNIX platforms). This paper will discuss when the use of SGIO and DIO is appropriate and how to specify and tune the two capabilities.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: SAS Institute
File Format: PDF
Date Published: May 1, 2009
Format: White Papers
Topics: UNIX, Knowledge and Data Management

Similiar White Papers

IBM Power Systems offer a smart alternative to Windows servers

Maintaining data security, performance, availability and recoverability is a growing challenge. The IBM Power platform o

Publisher: IBM | Tags: data, data security, database

Sybase ASE 12.5.x for UNIX: Integrating "Quiesce Database" Feature With Backup and Recovery Using a NetApp Filer Without Reboot

This paper covers the techniques for integrating the quiesce database feature provided in ASE for backing up and restori

Publisher: Network Appliance (NetApp) | Tags: database, server

Breaking DB2 Platform Barriers

Are you supporting DB2 on multiple platforms? In this Quest white paper, "Breaking DB2 Platform Barriers," DB2 expert Ji

Publisher: Quest Software | Tags: linux, os

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute | Tags: crm, customer service, data, data mining

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »