DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Can I defrag SQL Server?

Hybrid View

  1. #1
    Terry Guest

    Can I defrag SQL Server?


    I have a Win2k server with MSSQL 2k running. In running my normal maintenance
    on the server I noticed that the physical drive that all the SQL files sit
    on - is in serious need of defragmentation. Is it advisable to run defrag
    on this drive? Can I run it when MSSQL is running? Can I expect to see
    any type of performance enhancement or degradation after defragmentation?

    Thanks again, you guys are great.

    Terry


  2. #2
    David Satz Guest

    Re: Can I defrag SQL Server?

    I am far more a developer than admin, but this article might help:

    http://www.sql-server-performance.co...tuning_w2k.asp

    and

    http://www.sql-server-performance.co...gmentation.asp
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions

    "Terry " <snakbrat@yahoo.com> wrote in message
    news:3f16fd46$1@tnews.web.devx.com...
    >
    > I have a Win2k server with MSSQL 2k running. In running my normal

    maintenance
    > on the server I noticed that the physical drive that all the SQL files sit
    > on - is in serious need of defragmentation. Is it advisable to run defrag
    > on this drive? Can I run it when MSSQL is running? Can I expect to see
    > any type of performance enhancement or degradation after defragmentation?
    >
    > Thanks again, you guys are great.
    >
    > Terry
    >




  3. #3
    Daniel Reber Guest

    Re: Can I defrag SQL Server?

    Check out DBCC SHOWCONTIG in BOL. It has a nice example on how to defrag
    all indexes in all tables using DBCC INDEXDEFRAG.

    Dan


    "David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote in message
    news:3f170540@tnews.web.devx.com...
    > I am far more a developer than admin, but this article might help:
    >
    > http://www.sql-server-performance.co...tuning_w2k.asp
    >
    > and
    >
    > http://www.sql-server-performance.co...gmentation.asp
    > --
    > HTH,
    > David Satz
    > Principal Web Engineer
    > Hyperion Solutions
    >
    > "Terry " <snakbrat@yahoo.com> wrote in message
    > news:3f16fd46$1@tnews.web.devx.com...
    > >
    > > I have a Win2k server with MSSQL 2k running. In running my normal

    > maintenance
    > > on the server I noticed that the physical drive that all the SQL files

    sit
    > > on - is in serious need of defragmentation. Is it advisable to run

    defrag
    > > on this drive? Can I run it when MSSQL is running? Can I expect to see
    > > any type of performance enhancement or degradation after

    defragmentation?
    > >
    > > Thanks again, you guys are great.
    > >
    > > Terry
    > >

    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center