Azure Synapse too slow to Open and work on Workspace

Xhevahir Mehalla 25 Reputation points
2024-11-06T09:49:29.67+00:00

Hello-

When loading and accessing Synapse workspace is taking a long time.

Even it opens up after 20 mins - working around the workspace is very slow.

There have been no changes/setting up.

The health status looks fine.

All env within that subscription is experiencing the same issue.

Thanks

Xhev

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,996 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ganesh Gurram 1,025 Reputation points Microsoft Vendor
    2024-11-06T17:43:27.6633333+00:00

    @Xhevahir Mehalla - Thanks for the question and using MS Q&A platform.

    It seems that your Azure Synapse workspace is facing considerable performance challenges. Here are some potential steps and considerations to help diagnose and resolve the issue:

    • Resource Limits: Verify if you are hitting any resource limits (e.g., CPU, memory) in your Synapse environment. You can monitor the resource utilization metrics in the Azure portal.
    • Sometimes, browser extensions or issues can impact performance. Try accessing Synapse from a different browser or in incognito mode. Ensure your local system is not facing performance issues that might be impacting your experience.
    • Network Issues: Check for any network-related issues that might be causing the slowness. Network latency between your location and the Azure data center can impact performance. If you're using a VPN or have firewall rules in place, ensure they are not causing any delays.
    • If you are running heavy queries or jobs, ensure they are optimized for performance. Poorly optimized queries can slow down the entire workspace. Check if there are too many concurrent operations happening that might be causing the slowdown.
    • Review the configuration settings of your Synapse workspace to ensure they are optimized for performance. Clear the browser cache and cookies, and try accessing the workspace again.

    Hope this helps. Do let us know if you have any further queries.  

    ------------- 

    If this answers your query, do click `Accept Answer` and `Yes` for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.