Warehouse performance degradation

[mrojze]

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

[Anonymous · Accepted solution]

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