Defragment on SQL server.

Posted on 2012-09-14
Last Modified: 2012-09-14
I haven't run defragment on SQL server, but after reading, it seems that defragment increases performance if the MDF file size is big.
So, I like to run defragment on the server, but don't know if there's any better tool to run online or should I take down the server to run it.
The other question, how often do you guys run defragment on sql server?
Question by:crcsupport
    LVL 75

    Accepted Solution

    there is sql defrag for indexes;
    windows defrag wont work unless the sql service is down
    LVL 9

    Assisted Solution

    LVL 1

    Author Comment

    Yes, I'm willing to take down the server and run defragment. I don't know how much it will take, though. Also after file degragment, I'll run rebuilding index.
    LVL 1

    Author Comment

    Diskeeper vs Windows default defragment for SQL file defregment?
    Which one is better?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now