Date: Thu, 17 Sep 1998 21:08:58 -0500
Reply-To: Rob Rohrbough <rob@ROHRBOUGH-SYSTEMS.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Rob Rohrbough <rob@ROHRBOUGH-SYSTEMS.COM>
Organization: Rohrbough Systems Design, Inc.
Subject: Re: SAS on P II with 2 HDs : Performance ?
In my experience the most benefit may be gained by concentrating more
about the nature of the data and the interaction between master data and
the SASWORK library or among the data rather than worrying too much
about the programs. Also of concern may be your OS's page file. Two
things to consider when you have the luxury of more than one disk is
data transfer rate and head positioning (and the conflicts caused by
having more than one data item on the same drive).
If you have only one master dataset you analyze, for instance, you may
consider putting your master library on one drive and SASWORK on the
other drive so that your initial traversals copy from one to the other
without causing head conflicts. If your data is voluminous, and
assuming the SCSI drive is faster, and you are reducing the data on the
first traversal, I would put the voluminous data there and SASWORK on
the IDE with the programs and swap file.
That is one approach. Of course your results may vary and I have made
several assumptions about your situation. I also know that to really
evaluate performance and optimize it can be a long and painstaking
effort. That may be one reason performance tuning can get into the big
bucks. That is not what I do, but I have been involved in this type of
thing in some of my apps. Hope this gives you a little to chew on as
you decide how to configure your machine.
Peter Crawford wrote:
> Subject: SAS on P II with 2 HDs : Performance ?
> Date: Fri, 11 Sep 1998 19:01:56 +0100
> From: Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
> In article <email@example.com>, Werner E. HELM
> <helm@FH-DARMSTADT.DE> writes
> >Dear SAS-L :
> >I have a new PC P II-400 with 2 HD's one UW-SCSI and one EIDE UDMA,
> >both partitioned.
> >I will run SAS 6.12 TS045 under Win '98.
> >How should I setup SAS to get the best performance out of my system ??
> >Werner E. HELM .
> When you have tried SAS on both channels,
> let us know how the performance compares !
> I can think of several configurations of interest
> UW-SCSI EIDE UDMA
> 1 SAS DATA
> 2 DATA SAS
> 3 SAS WIN98
> 4 WIN98 SAS
> 5 SAS + WIN98 DATA
> Peter Crawford
fn: Rob Rohrbough
org: Rohrbough Systems Design, Inc.
adr: 9215 Dorcas Street;;;Omaha;NE;68124-2039;USA
tel;work: (402) 343-1493
note: A SAS(R) Institute Quality Partner