Need to execute database maintenance in multiple threading (session)

• sharky

  Default port

  Points: 1494

  More actions

  April 19, 2018 at 9:19 am

  #1987549

  Look at Ola Hallengren's maintenance scripts.:
  https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  April 19, 2018 at 2:31 pm

  #1987604

  When you rebuild an index it updates statistics as well.

• anujkumar.mca

  SSChasing Mays

  Points: 621

  More actions

  April 20, 2018 at 10:00 am

  #1987696

  Ols Hallengren's script doesn't provide multi-threading solution.