Architecting, installing and maintaining your SAS environment

Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Reply
Occasional Contributor
Posts: 10

Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Dear all,

 

How do you edit your .cfgs to balance the load for UTILLOC and WORK librefs on 2 NVME drives?

HEre are my lines from sasv9.cfg

 

-UTILLOC ('d:\SAS UTILITY FILES','e:\SAS UTILITY FILES')

-WORK "e:\SAS94\SASFoundation\9.4\nls\en\work_list.txt"

 

Here is my work_list.txt following http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n1qr5dmzagn9krn1lt...

/d/SAS_TEMP
/e/SAS_TEMP
    Method=Random

 

SAS loaded through EG just freezes until i remove these lines. The folders exist and everything else works ok. If i just specify one UTILLOC and and only one work lib, and run a whole bunch of sorting with 10 gigs datasets, the code runs a minute but it never writes any util files to the UTILLOC (verified through res monitor) it just creates a few 0 size files in that location. I really wish there were more documentation on these features. I have a terabytes big project and this optimization will save time.

 

Thank you

Super User
Posts: 8,080

Re: Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Posted in reply to astrae_research

I'd rather use one volume striped over those two disks, and use the one resulting path for WORK. To further speed things up, use a similar stripeset for UTILLOC. That's what I did for a long time with LVM on AIX, and it served me well. Nowadays, the SAN storage is fast enough to handle all I/O (WORK and permanent).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 10

Re: Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Posted in reply to KurtBremser

Thank you for the answer! Unfortunately, there is no budget (or time to research other options) for anything else so I'm looking for a quick and dirty way to make things work.

 

I corrected the file (just trial and error, love the sas doc) and now SAS loads but only uses one folder for WORK and never the other.

 

Thsi is the file now

"d:\SAS_TEMP"
"e:\SAS_TEMP"
    Method=Random

 

 

Super User
Posts: 8,080

Re: Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Posted in reply to astrae_research

SAS uses both drives sequentially, so you won't get any load balancing out of that.

Combine the two drives into a stripeset and use that for WORK.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 10

Re: Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Posted in reply to KurtBremser

Ok, so I misunderstood the doc. Would software striping done in Win 7 x64 do?

Super User
Posts: 8,080

Re: Multiple UTILLOC and WORK Libraries for IO balancing on Win7 64 bits with SAS 9.4 TS1m3

Posted in reply to astrae_research

astrae_research wrote:

Ok, so I misunderstood the doc. Would software striping done in Win 7 x64 do?


I would try that.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 5 replies
  • 148 views
  • 0 likes
  • 2 in conversation