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

ilputto 21 Reputation points
2021-09-02T11:48:35.987+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 42,386 Reputation points
    2021-09-02T12:35:35.517+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,451 Reputation points
    2021-09-03T02:37:46.783+00:00

    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

    0 comments No comments