Forum Discussion

Sujay1185's avatar
Sujay1185
Copper Contributor
Feb 20, 2024

Fragmentation report running for long time

We have client SQL database 2012 with 5 TB of data and we are trying to run the fragmentation report for index rebuild but the report query is running for almost 2 hours and we need to kill the sessi...
Sujay1185's avatar
Sujay1185
Copper Contributor
Mar 19, 2024
In the same fragmentation issue, I have created a automated job in SQL agent to run the index rebuild job on daily basis but it keep on failing for the last 1 week stating the process ended. So to rebuild the index do we need space in Data drive were the .MDF files resides. The current free space is 1 TB out of 5.16TB. Please let me know do we have suggestions to run the index rebuild job without failure.
Sujay1185's avatar
Sujay1185
Copper Contributor
Mar 19, 2024
In addition to the above query I could see so many Heap indexes available in the tables and can we recommend to drop and create as clustered index instead. Let me know the suggestions
  • Sujay1185's avatar
    Sujay1185
    Copper Contributor
    Mar 20, 2024
    Can please someone help me on this above query

Resources