MSSQL 2014 - maintenance task - what is the default fragmentation level ?

Question

Hi all,

I really like to know what is the default fragmentation % level that SSMS 2014 takes when run a reorg or reindex maintenance task.
In the latest SSMS release I can select the fragmentation % level to consider when I run a reorg index maintenance plan.
In SSMS 2014 there is no option. So I really like to know what is the rule that SSMS apply when we run a reorg index maintenance task?
what is the fragmentation % option that it applies?

thank you for any help

Answer 1

what is the fragmentation % option that it applies?

On older maintenance task there is no limit/check on the fragmentation ratio, the task simply rebuild/reorg all indexes; a reason why only less DBS uses maintenance tasks.

Answer 2

Hi @ilputto ,

Yes. Agree with Olaf.
This is an article about Reorganize/Rebuild SQL Server database index using SQL Server Maintenance Plans.
https://solutioncenter.apexsql.com/how-to-detect-a-high-level-of-sql-server-database-index-fragmentation-and-fix-it-automatically/
Also see this: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Best regards,
Seeya