Hello, often when a team member needs to select a larger data set from MS SQL over to SAS I will see a wait type indicator in SQL "async_network_IO" which essentially is "Waiting for network". At this time other sql databases (non-sas) and overall performance will degrade on the server due to the large network overhead and data transfer. example: a. select * from mytable b. select a,b, c, d, n(100+ columns) from my table (needed to recreate in SAS as a data set) Data is moved from large tables (100-200gb in sql) over the network to SAS. a. The end machines are not enabled for jumbo frames b. SQL works in packets of 4092 bytes size, default non-jumbo fram back is 1492/1500 bytes. (4kb split to 1kb) I have tried changing the packet size via libname statement which has no effect. Also tried newer SQL "natural" drivers to no avail. Any other ideas to reduce network io issues? My concern is SAS is not reading the data fast enough to keep up with the network and SQL. Any libname optimizations? LIBNAME myschema ODBC NOPROMPT = "Driver=SQL Server Native Client 11.0; Server=myserver; Database=mydb; dbsliceparm=all; threads=yes CPUCOUNT=8; READBUFF=131072; DBOMMIT=32768; INSERTBUFF=131072; ROWSET_SIZE=32768; Trusted_Connection=Yes;" Schema=myschema;
... View more