SAS ODBC Connection Time

shoin — Tue, 05 Jul 2022 21:07:57 GMT

Two SAS servers accessing SQL server DB via SYS DSN (old & new). Typical setup single servers SAS 9.4 TS1M7, db connection via SYS DSN 64 bit using SQL driver 17. The target SQL Db has no changes.

(using libname to connect in both, stats via fullstimer and sastrace string not shown)

Old sas server connection to DB takes < 4 seconds, whereas New 18 minutes (yes minutes).

I have turned on ODBC tracing and even sastrace, just want to ask if there is an another tool you guys may know of that would give me an idea as the issue.

I have questions out to my network, security people if there is any change b/w old & new sas servers as to authentication, realms, domain/sub-domain, etc. Of course no answer yet.

Thoughts what else I could use? BTW, that ODBC trace is no help. I am chasing it

5SBR22J 45c4-509c EXIT SQLSetConnectAttr with return code -1 (SQL_ERROR)
SQLHDBC 0x000001C1821C56F0
SQLINTEGER 1041 <unknown>
SQLPOINTER [Unknown attribute 1041]
SQLINTEGER 8

TIA

-S

Re: SAS ODBC Connection Time

SASKiwi — Tue, 05 Jul 2022 21:18:08 GMT

I suspect a network trace would be most useful here. It should show the timings of the SAS server to DBMS server network traffic.

Re: SAS ODBC Connection Time

shoin — Thu, 07 Jul 2022 16:53:26 GMT

Indeed, I have asked the network people when they r done smoking their stogies to use a trace 🙂

Thanks mate!

topic Re: SAS ODBC Connection Time in Administration and Deployment

SAS ODBC Connection Time

Re: SAS ODBC Connection Time

Re: SAS ODBC Connection Time