https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-Guide-reading-from-MS-SQLServer/m-p/920017#M44441 <P>Running your SAS client tools in the same cloud environment as your SAS servers is a no brainer for improving performance. The shorter the data pipe the faster it will be.</P> Tue, 12 Mar 2024 20:31:29 GMT SASKiwi 2024-03-12T20:31:29Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-Guide-reading-from-MS-SQLServer/m-p/919733#M44421 <P>After moving SAS EG and source databases to Azure, everythig goes slow unless when reading SAS dataset.<BR />We use MS SQL Server as our preferred data storage and link the data source with ODBC. Some libraries are preassigned.<BR />It really consume lot for time to read and scroll in those tables from SAS EG.<BR /><BR />So..</P><P>We decided to run SAS EG in Azure Virtual Desktop (AVD).&nbsp; Great success.<BR />Now opening SQL Server tabels and scrolling goes really fast. Almost no latency (lag) at all.</P> Mon, 11 Mar 2024 09:41:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-Guide-reading-from-MS-SQLServer/m-p/919733#M44421 ToreB 2024-03-11T09:41:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-Guide-reading-from-MS-SQLServer/m-p/920017#M44441 <P>Running your SAS client tools in the same cloud environment as your SAS servers is a no brainer for improving performance. The shorter the data pipe the faster it will be.</P> Tue, 12 Mar 2024 20:31:29 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-Guide-reading-from-MS-SQLServer/m-p/920017#M44441 SASKiwi 2024-03-12T20:31:29Z