topic Re: SAS Grid to Sqlserver data upload performance. in SAS Programming

SAS Grid to Sqlserver data upload performance.

smijoss1 — Fri, 17 Jul 2020 17:09:56 GMT

The "insertbuff=" parameter is no longer working for Sqlserver. (Since the latest update on sas Grid)

the Libname statement works fine. but when it tries executing the proc append , it gives "Error: The connection to the server has been lost." Error.

i have about 10 table contain about 300K to 400K records each. so without the insert buffer it take a Loooong time.

has insertbuff been replaced with any other option ? Since Bulkload does not work on SAS Grid what other option do I have ?

libname mydblib sqlsvr datasrc=xxx     user=xxx   password=xxx schema=xxx DIRECT_EXE=delete DBCOMMIT=1000 ReadBuff= 10000   ;

proc append base=mydblib.Smijo_Class data=sashelp.class;
Run;

libname mydblib clear;

Re: SAS Grid to Sqlserver data upload performance.

ballardw — Fri, 17 Jul 2020 17:23:01 GMT

To help someone that knows more on this topic than I do you might want to mention which release of SQL Server you are connecting to.

Re: SAS Grid to Sqlserver data upload performance.

smijoss1 — Fri, 17 Jul 2020 17:27:47 GMT

Thank you for replying. Here are the details of the Sqlserver.

SAS Grid Version : 9.04.01M6P110718
SYSHOSTINFOLONG Linux LIN X64

Sqlserver version :

Re: SAS Grid to Sqlserver data upload performance.

SASKiwi — Sat, 18 Jul 2020 23:16:12 GMT

I suggest you work with SAS Tech Support on this one. INSERTBUFF shouldn't cause dropped database connections.