system Table for Index Fragmentation info for Azure Synapse sqlpool.

Maitra-v, Anirban 141 Reputation points
2022-03-09T18:47:43.453+00:00

Hi,

Is there any system Table for Index Fragmentation info for Azure Synapse sqlpool.
I got some documentation for SYS.DM_DB_INDEX_PHYSICAL_STATS , but it seems it is not the correct one.

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,457 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 79,141 Reputation points Microsoft Employee
    2022-03-10T11:47:07.73+00:00

    Hello @Maitra-v, Anirban ,

    Thanks for the question and using MS Q&A platform.

    As per the official Microsoft documentation, system Table for Index Fragmentation does not apply to a dedicated SQL pool in Azure Synapse Analytics. For information on index maintenance for a dedicated SQL pool in Azure Synapse Analytics, see Indexing dedicated SQL pool tables in Azure Synapse Analytics.

    181869-image.png

    For more details, refer to Optimize index maintenance to improve query performance and reduce resource consumption.

    Hope this will help. Please let us know if any further queries.

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

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful