Hi, I have a SqlAnyWhere 10 server running with appr. 37 databases on a Windows 2008R2 64bit server. The server runs nice for some days but then connections will not close even if the Client closes the application that holds the connection. Have anyone experienced and solved this?
asked 26 Feb '14, 07:11
Yes. See this question.
Using a value of '1' for MAX_QUERY_TASKS is also a workaround for this issue - this will take effect for all new logins to the server. Existing logins will not be affected until they reconnect.
SET OPTION PUBLIC.MAX_QUERY_TASKS = 1;