crcsupport
asked on
Defragment on SQL server.
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Diskeeper vs Windows default defragment for SQL file defregment?
Which one is better?
Which one is better?
ASKER