Hi,

We have an azure synapse analytics dedicated sql pool, and something strange is happening with it.

Basically I run a simple SQL Select Statement like the following between business hours (08:00 AM to 18:00 PM) and results return instantly.

SELECT *
FROM Prs.SalesOrderLine

, 
When I try running the same query in the evening (22:00 PM) it just hangs and I have to force it to cancel and I get the below error message:

Msg 111202, Level 16, State 1, Line 2
111202;Query QID3399532 has been cancelled.
Query was canceled by user.

Any ideas what could be happening? I am bit disappointed with Azure Synapse Analytics to be honest.

Thanks

​Hi,We have an azure synapse analytics dedicated sql pool, and something strange is happening with it.Basically I run a simple SQL Select Statement like the following between business hours (08:00 AM to 18:00 PM) and results return instantly.  SELECT *
FROM Prs.SalesOrderLine  , When I try running the same query in the evening (22:00 PM) it just hangs and I have to force it to cancel and I get the below error message:Msg 111202, Level 16, State 1, Line 2111202;Query QID3399532 has been cancelled.Query was canceled by user.Any ideas what could be happening? I am bit disappointed with Azure Synapse Analytics to be honest.Thanks  Read More

​