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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.