I've got SQL Server tables set up in Metadata and they work fine. The trouble is, my SQL Server DBA is complaining that we have dozens of apparently "orphaned" SQL Server processes that are left by the users of SAS Studio. How do I make SAS Studio clean up the connections?
How are your SQL Server data sources set up in metadata - are they pre-assigned or not? If they are pre-assigned you should also add the defer = yes option so database connections are only created if the data source is opened.
No. Just disconnecting your workspace SAS session and reconnecting should do the trick. You may want to check with your SQL Server DBA as well to see if there is a server connection timeout he can set. I'd suggest something like 24 hours.
Where I work we close all SAS workspace sessions at 2am so we can replicate our SAS environment. This will also drop all database connections.
Checked with my DBA this morning and we still have lots of stray connections. The person who signed on has a connection to a test database he never even uses We have large statisticl modeling jobs that run overnight, so closing SAS workspace might be a little dicey for us. I'm wondering about the "Whether to automatically drop utility connections" option? I'll do some more research.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.