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

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

astrae_research — Tue, 22 Aug 2017 06:57:13 GMT

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#n1qr5dmzagn9krn1lt1c276963za.htm

/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

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

Kurt_Bremser — Tue, 22 Aug 2017 07:14:26 GMT

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).

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

astrae_research — Tue, 22 Aug 2017 14:29:45 GMT

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

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

Kurt_Bremser — Tue, 22 Aug 2017 14:34:35 GMT

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.

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

astrae_research — Tue, 22 Aug 2017 14:39:05 GMT

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

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

Kurt_Bremser — Tue, 22 Aug 2017 14:40:23 GMT

@astrae_research wrote:

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

I would try that.