LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 1998, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 ?
Comments: To: "Werner E. HELM" <helm@FH-DARMSTADT.DE>
Comments: cc: Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Content-Type: multipart/mixed;

Werner,

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.

Rob

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 <905513250.1128511.0@vm121.akh-wien.ac.at>, 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 > ETC > -- > Peter Crawford


[text/x-vcard]

begin: vcard fn: Rob Rohrbough n: Rohrbough;Rob org: Rohrbough Systems Design, Inc. adr: 9215 Dorcas Street;;;Omaha;NE;68124-2039;USA email;internet: rob@rohrbough-systems.com title: Consultant tel;work: (402) 343-1493 note: A SAS(R) Institute Quality Partner x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard


Back to: Top of message | Previous page | Main SAS-L page