I want to check my SQL database for fragmentation and defrag it. A Solarwinds tech indicated I should follow this Reorganize and Rebuild Indexes , but it assumes 1 table at a time. Anyone have any SQL experience that can help apply this to all tables? I want to automate this SQL maintenance.
I have been using these scripts. https://ola.hallengren.com/
Here is another site that has helped. https://www.brentozar.com/
See this Critical index fragmentation detected during database maintenance - SolarWinds Worldwide, LLC. Help and Support
You can check to see if there is fragmentation by going to c:\programdata\solarwinds\logs\orion\swdebugmaintenance.log go to the bottom and it will tell you if you have fragmentation.
Thanks for the quick response. I will take a look at those scripts.
Thanks for the quick response. I have run a script that checked for fragmentation in addition to getting alerts from the built in db maintenance job that fragmentation does exist and is high. I will look for this file too.
