Forum Discussion

mrojze's avatar
mrojze
Helper II
2 years ago
Solved

Warehouse performance degradation

Hi all,

I have a project running on a TRIAL capacity. We have a wharehouse that stopped responding to any query.

A table with 5 rows will not come back.

We did query the sys.dm_exec_sessions view and we see lots of open sessions in running status.

We are able to edit and commit DF pipelines.

 

We tried switching trial capacities but that didn't help.

Any clue how to troubleshoot this?

 

Thanks,

Martin

data warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI mrojze ,

    Which mode are you assigned license to the workspace? If you mean fabric capacity, have you checked the data warehouse and capacity status to confirm if they are paused? AFAIK, fabric contents will not available if the hosted capacity are suspended.

    Pause and resume your capacity - Microsoft Fabric | Microsoft Learn

    Pause and resume in Synapse Data Warehouse - Microsoft Fabric | Microsoft Learn

    New requests: Once a capacity is paused, users cannot execute new SQL statements or queries. This also includes activity on the Fabric portal like create operations, loading data grid, opening model view, opening visual query editor. Any new activity attempted after capacity is paused returns the following error message Unable to complete the action because this Fabric capacity is currently paused.

    Regards,
    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI mrojze ,

    Which mode are you assigned license to the workspace? If you mean fabric capacity, have you checked the data warehouse and capacity status to confirm if they are paused? AFAIK, fabric contents will not available if the hosted capacity are suspended.

    Pause and resume your capacity - Microsoft Fabric | Microsoft Learn

    Pause and resume in Synapse Data Warehouse - Microsoft Fabric | Microsoft Learn

    New requests: Once a capacity is paused, users cannot execute new SQL statements or queries. This also includes activity on the Fabric portal like create operations, loading data grid, opening model view, opening visual query editor. Any new activity attempted after capacity is paused returns the following error message Unable to complete the action because this Fabric capacity is currently paused.

    Regards,
    Xiaoxin Sheng