Hello,
We are running the Achilles R package against a MS SQL Server. Some tables such as Observation and Drug Exposure are large (500M rows). The server had 85G of RAM. We tend to get stuck at metric #515 and #2002. We have upgraded RAM and it helped a bit. However, the queries are still long running and do not complete. These metrics had previously been running in about 8 minutes, but in subsequent months, are stuck running for 20+ hours at which point the process was killed. Our dataset grows, but very incrementally. We have done analysis on indexes extensively, but it hasn’t made an improvement. I saw some other similar posts on here from a few years ago, and the work-around was to run the queries manually in SQL Server Management Studio. Has anyone else encountered this type of issue? Any pointers on what else to try?