Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 934
  • Last Modified:

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?
0
crcsupport
Asked:
crcsupport
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
there is sql defrag for indexes;
windows defrag wont work unless the sql service is down
0
 
Vijaya Reddy Pinnapa ReddyCommented:
0
 
crcsupportAuthor Commented:
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.
0
 
crcsupportAuthor Commented:
Diskeeper vs Windows default defragment for SQL file defregment?
Which one is better?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now