SQL Server Performance

database maintainance wizard

Discussion in 'Performance Tuning for DBAs' started by boutwater, Mar 3, 2004.

  1. boutwater Member

    I noticed that it is a good idea to defrag the actual data files before using the reorganize function of the database maintainance wizard. How do I go about doing this? Thanks for your help,

    Ben
  2. bradmcgehee New Member

    You can do this with the built-in defrag tool available in Windows, or you can use a third-party tool like Diskkeeper from Executive Software. Be aware that for these tools to work correctly, the SQL Server service must be stopped so that the files are not locked. This means your SQL Server will be down until the defrag completes.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. satya Moderator

    Additionally if you do not want SQL to be down then exclude the SQL involved directories while defraging is in progress. And still I think there will be performance glitch until it finishes the task.

    Review information on this website about db maint. plans on tips page.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page