Post reply

defragment disk for my sql server 2000

  • May 1, 2006 at 1:15 pm

    #168115

    hi, my sql server 2000 is running slow so I would like to defragment my disk, is the right to do this by going to:

    start, programs, accesories, systems tools , disk defragmenter?

     

    also, is there anything i should do before or after i do this, besides backup my databases, and stop and then restart my services after deframentation?

     

    any help will be apreciate it!!

  • May 1, 2006 at 3:48 pm

    #635225

    You have to stop SQL Server in order for the segments used to be properly defragmented.

  • May 2, 2006 at 3:06 am

    #635262

    Also have alook at this thread...

     

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=269738#bm272159


    Thanks Jeet

  • May 2, 2006 at 5:55 pm

    #635483

    Quest Capacity Manager provides an interface to identify fragmented objects, make recommendations to rebuild the objects on-line/off-line based on level of fragmentation, and keeps track of how often objects are getting fragmented. You don't need to rebuild all objects in your database, only the ones that are effecting  performance. For example fragmented objects that have less than 1000 pages don't have any impact on performance.

    http://www.quest.com/capacity_manager_for_sql_server/

    Hassan

     

  • May 3, 2006 at 3:43 am

    #635524

    Largely only datafile fragmentation is critical, assuming you have seperate drives/arrays/disks for data, logs, binaries.

    The backups and tran logs will always fragment, you can't do much about backups but you can attempt to fix your tran log size so that they don't autogrow very often, and if they do by a large amount. Do the same thing to the datafiles, the 19% growth is really bad for causing fragmentation.

    If you're running w2003 defrag manager will actually run with sql server on-line, although performance will be almost non-existent!! For large fragmented mdf files you might do better to stop the service and copy the file to another disk, delete the existing and copy back - this process will remove fragmentation assuming enough free contiguous disk space.

    Try to keep the errorlogs and agent logs away from the tlog and data drives as these fragment badly.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • May 3, 2006 at 8:00 am

    #635612

    thank you so much all of you for your help, have a great day 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply