This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am currently facing an issue where My Alteryx designer automatically runs a long SQL query when i just connect to a DB from my workflow. My IT team frequently email me saying i am running Long SQL(Which i am not!) and is affecting the DB health. However, when i close Alteryx designer the problem resolves.
Thanks, i have checked the Auto Configure and it certainly did reduce the SQL running frequently but it hasn't completely stopped i am afraid. My colleague did not check the Auto Configure and apparently our IT team found no long queries from my colleague.
Is this anything to do with SQL drivers version? I have SQL driver version 11( SQL 2014) and my colleague is running on SQL 2008.
I have also attached my driver configuration which allows to create temp stored procedure for prepared SQL , may be this is causing the issue?
It is a very Strange behavior coming just out of my Alteryx designer.