Date:         Tue, 5 Apr 2011 15:46:49 +0000
Reply-To:     "DUELL, BOB (ATTCINW)" <bd9439@ATT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "DUELL, BOB (ATTCINW)" <bd9439@ATT.COM>
Subject:      Re: Compare Options between machines
Comments: To: Ben Powell <bpowell555@GMAIL.COM>
In-Reply-To:  <201104051214.p35AkstE005767@waikiki.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Hi again,

You mentioned that your "remote" PC is running SAS 8.2 and your "local" PC is running SAS 9.2.  Do they both connect to Sybase with the same software?  Perhaps you have ACCESS TO SYSBASE on one and are using ACCESS TO ODBC on the other?

If it's the same, is the "middleware" configure the same way and with the same driver on both machines?

I have absolutely zero experience with Sybase myself, so I'm just guessing.

Good luck,

Bob


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ben Powell
Sent: Tuesday, April 05, 2011 5:14 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Compare Options between machines

Thanks. I've tracert from both machines and its one hop both ways, with
<1ms ping time. I also tried pulling SAS data from a network fileshare and
the speed is the same for each machine, so I really don't think its the
network.

I ran this comparison of options but none stood out:

option nolabel;
proc sql;
create table op.v9 as
select *
from dictionary.options;
quit;

proc sort data = op.v9;by optname;run;
proc sort data = op.v8;by optname;run;

data x;
merge op.v8 (in=x rename=(setting=v8set)) op.v9 (in=y rename=
(setting=v9set));
by optname;
keep optname v8set v9set;
run;

data dif;
set x;
if v8set^=v9set and v8set^="";
run;

data dif2;
set x;
if v8set^=v9set and v9set^="";
run;

What else that's so well hidden could cause such a significant performance
degradation? Performance difference is 10-20 times,

Rgds

On Tue, 5 Apr 2011 07:29:56 -0400, S=?ISO-8859-1?Q?=C3=B8ren?= Lassen
<s.lassen@POST.TELE.DK> wrote:

>Ben,
>You have had several good suggestions why things may be running slower
>on the local machine - very probably it is a question of bandwidth,
>not just of the machines, but of all the network connections between
>them.
>
>But if you need to compare the system options on the two machines,
>I think the easiest solution is to save data from DICTIONARY.OPTIONS,
>e.g.:
>proc sql;
>  create table savelib.options%sysfunc(translate(&sysver,_,.))
>    as select * from dictionary.tables
>    order by optname;
>quit;
>
>- the problems with the other suggestions so far being that PROC OPTSAVE
>did not exist under SAS 8.2, and ODS OUTPUT does not produce anything
>(as far as I can see) with PROC OPTIONS.
>
>Regards,
>Søren
>
>On Mon, 4 Apr 2011 11:27:03 -0400, Ben Powell <bpowell555@GMAIL.COM>
wrote:
>
>>Hi list,
>>
>>I have a local and remote pc both running SAS Access to Sybase. The
remote
>>machine is version 8.2 and the local machine is version 9.2. When running
>>the same code in a connection the remote machine typically executes much
>>faster and will use 10*++ the network traffic as measured by windows task
>>manager. Usually 12.5% vs something like 0.5%.
>>
>>Is there a way I can compare the current default connection properties on
>>each system to see if this might be the root cause?
>>
>>I was trying to output proc options to dataset whereby I could compare
the
>>two results easily but am not able to get an output dataset. Any
>>suggestions?
>>
>>Thanks
>>
>>ods output "Library Members" = test;
>>proc datasets library = work;quit;
>>/*proc options;run;*/
>>ods output close;