I am one of the designer SMEs, but do not know much about server. We have a new server admin who knows nothing about designer and is still learning about server himself. I'm hoping to be able to help him troubleshoot what I suspect is a server issue.
Problem: One of the databases we report from is a MS SQL Server DB with AD credentials. They upgraded the DB through regular maintenance a few months ago changing the name. We updated our workflows with the new DB name in the connection and they run as expected. Our admin created a new connection on the server as well. The DSNs all match accordingly. Since this change was made reports that use to run in minutes on the server now take hours to run causing a backlog and queuing other workflows for hours. Some workflows are failing altogether with no real error message related to the workflow. I pull some of the long running offenders down and run them on my computer and again they run in minutes.
Questions: Are there multiple ways for setting up MS SQL Server connections on the Alteryx server? Is one better than the other? If the incorrect set up is chosen, can it impact how the workflow runs?
I will be meeting with the server admin this morning to review the connection and talk about other possible issues. There is only so much optimization of workflows that can be done!
TIA!
