search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.29k stars 21.47k forks source link

The view dbo.vTableSizes never returns results. #118071

Closed mljohn111 closed 11 months ago

mljohn111 commented 11 months ago

[Enter feedback here]

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

mljohn111 commented 11 months ago

I executed this view with a where clause for a schema that contains ~100 tables. The query ran for almost 2 hours and never returned any results.

WilliamDAssafMSFT commented 11 months ago

Ensure that index maintenance occurs on a regular basis and after large data changes. Do that, then try the vTableSizes again.

If you have any deeper technical questions, this may not be the best forum, as this space is for documentation updates. I recommend Microsoft Q & A (Azure Synapse Analytics), Azure Synapse Analytics feedback, Microsoft Support, or your support partners. If this persists, open a support ticket. This isn't the space for technical support.

Regardless, thanks again for this feedback, your suggestions help improve our documentation.

please-close

WilliamDAssafMSFT commented 11 months ago

assign:WilliamDAssafMSFT