SQL Server Performance

Newbie Question about defrag, please help me!!!

Discussion in 'Performance Tuning for Hardware Configurations' started by halmeida, Oct 4, 2006.

  1. halmeida New Member

    Hi!!!

    I am a newbie and need to learn MSSQL because our third-party application runs on it and now we have performance issues and I have detected fragmentation on our server raid disks.

    Since the first application was installed, we never have defragmented the disks and now Windows Defrag, reports a high level of fragmentation in all volumes.

    So my question is:

    Must I stop all services in order to Run Windows Defrag?
    If I can buy a commercial version of a software such as Diskeeper Enterprise for Servers, because they do not need to stop the services using its technology.

    Or, If you recommend another software please tell me.


    Thanks for any information.

    Heberson Sette de Almeida
  2. thomas New Member

    Yes, you must stop SQL Server unless you buy 3rd party software that can do this.
  3. joechang New Member

    in many cases, if you can shut down SQL
    with properly configured disks
    it can be faster to backup the db
    reformat the partition where data normally resides
    then restore

    but, realisitically, if your third party app is slow
    i would not leap to this conclusion without proper complete analysis
  4. countcet New Member

    Where is your application installed? Is it on the same server as SQL?

  5. bradmcgehee New Member

    Diskkeeper 10 is a third party program that will defrag open SQL Server data files. I use it all the time. If you do use it, be sure to schedule it so that it only runs during less busy times of the day.

    -----------------------------
    Brad M. McGehee, SQL Server MVP

Share This Page