Date: Wed, 28 Jan 2009 07:40:47 -0500
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: Performance issues with 9.2
No, or at least I don't know if proc migrate had been used or not.
As soon as we moved to a multi-processor environment we noticed that jobs
analyzing large data sets were taking longer than they used to in a non-
server, single-user environment.
Our first attempt to resolve the matter, namely to move all of the data
onto the server's own harddrive, immediately produced the originally
anticipated improvements.
Since no one was able to offer either an explanation or alternative
solution, we simply expanded the server's hard drive and moved all of our
data there.
Thus, my question is simply "are your data files on the server's harddrive
or somewhere else on your network?"
Art
--------
On Tue, 27 Jan 2009 23:11:40 -0800, gss100 <gss650@GMAIL.COM> wrote:
>We migrated the new files to the x64 9.2 system with proc migrate. Is
>this what you mean?
>On Jan 27, 3:57 pm, art...@NETSCAPE.NET (Arthur Tabachneck) wrote:
>> Hardware issues are out of my league, but I do have a question. Do the
>> data files all reside on the new server?
>>
>> When I first went to a multi-processor SAS server, the first thing I had
>> to do (for similarperformanceissues) was move all of the data onto the
>> server.
>>
>> I don't have either Vista or9.2, thus don't know if they have added
>> anything new to the equation.
>>
<Snip>
