community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

In-db workflow not stopping SQL server query

Meteor

Hi everyone

 

We use Alteryx extensively in my organisation.  Most of our data resides in SQL Server 2016.  We picked up that in-db queries that are cancelled by the user do not necessarily cancel on the server.  We had a couple of rogue queries that filled up the temp space even after the user cancelled the workflow.

 

This means that one only notice there is an issue if the server starts taking strain.  

 

Has anyone come across this and is there a solution?  Our users do not have DBA access so they would not monitor their queries to know when this happens.

 

Regards

 

Hein

Moderator
Moderator

Hi @HeinL - I would suggest logging a case with Support so we can dig into this more. Please visit http://www.alteryx.com/support to log a ticket.

Sophia Fraticelli
Premium Support Advisor
Alteryx, Inc.
Labels