Service center indicate SLOWSQL of a query that is used in the preparation. (6530 ms). When I use Azure Date Studio I have my resultset in 1000 ms. Why is there a difference in time?
Hi,
For both queries, data set is same?
Yep, for both the data set is the same.
Hello
Network Latency: Service Center might have more network delay.
Server Load: The server might be busy with other tasks.
Query Execution Plan: The database might choose a different plan for each tool.
Overhead: Service Center might have extra processing overhead.
Caching: Azure Data Studio might use cached data
I hope it's helps!
Thanks This can be a start of a solution.