Defrag individual index partition

I would like to defrag individual index partition instead all index partitions on a partitioned table in sql server, with a previous software used, in order to reduce the index contention.

0 nestor castro over 3 years ago

Hello mchuc

Please open a case so one of our ApexSQl engineers can help you in this regard.

Thank you !!
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel
0 mchuc over 3 years ago in reply to Armando R.

Hello Armando

Thank you for your answer, I just read the article and not fit in my situation, actually I have an partitioned table with 5 indexes, one of them have 25 partitions, with a previous Tool we can defrag only partitions needed.

Regards
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Armando R. over 3 years ago

Hello,

Thank you for choosing Quest's ApexSQL products.

Our tool ApexSQL Defrag is able to rebuild indexes as you describe, please follow this article for more details:

Resolve SQL Server instance index fragmentation – Rebuild and Reorganize indexes

Hope this information is helpful for you.

If you happen to need more assistance please let me know.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel