| Author |
|
Brian
Joined: 21 Oct 2005
Posts: 209
Location: Puyallup, WA USA
|
 Posted: Mon 09 Nov '09 22:56 Post subject: Defrag WAMP on 2003 R2 |
 |
|
Perhaps this is a rookie question?
On my 2K3 R2 server the C volume no only boot but also Apache, and SQL - and it is about 70% fragmented and has about 33% space available. This volume has never been defragged.
This is an operation on a shoe string budget so while I am cheap, I will pay for what I must pay for if it is necessary.
That all being said, what do YOU recommend as for best practices and software (preferably free or very low cost) regarding defragging this critical volume?
Thanks. |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7371
Location: Germany, Next to Hamburg
|
| Posted: Tue 10 Nov '09 12:50 Post subject: |
|
|
I use a batch script with "Tasks" (don't know if that is correct in the english version means the "cron" job). it runs two times a week to there no so much fragmentation.
| Code: |
@echo off
title automatic defrag
call defrag C: /f
call defrag E: /f
call defrag F: /f
exit
|
Notice: It slows the server a bit down since there is so much disc activity. |
|
| Back to top |
|
Brian
Joined: 21 Oct 2005
Posts: 209
Location: Puyallup, WA USA
|
| Posted: Tue 10 Nov '09 18:33 Post subject: |
|
|
So you have no issues with SQL or any other form of data corruption on a live server?
If I may ask, are you defragging an active server in terms of both traffic and SQL activity? I am concerned about a data corruption...as you can tell.
Thank you for your follow up, it is helpful. |
|
| Back to top |
|
Steffen
Moderator
Joined: 15 Oct 2005
Posts: 3092
Location: Hilversum, NL, EU
|
| Posted: Tue 10 Nov '09 21:54 Post subject: |
|
|
I have a very good experience with Diskeeper, it is defragging auto and no overhead here. Use it already for years you and no fragmentation anymore.
I use Diskeeper 2009 Pro Premier ,
for more info see http://www.diskeeper.com/Diskeeper/home/premier.aspx
Steffen |
|
| Back to top |
|
Brian
Joined: 21 Oct 2005
Posts: 209
Location: Puyallup, WA USA
|
| Posted: Tue 10 Nov '09 22:18 Post subject: |
|
|
Thanks Steffen, this does look like a good solution indeed.
--
Brian |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7371
Location: Germany, Next to Hamburg
|
| Posted: Wed 11 Nov '09 11:40 Post subject: |
|
|
| Brian wrote: | So you have no issues with SQL or any other form of data corruption on a live server?
If I may ask, are you defragging an active server in terms of both traffic and SQL activity? I am concerned about a data corruption...as you can tell.
|
Yes I run the defragmentation on the live server. I have no issue with apache for mysql. With mysql I can tell you only with MyISAM. I haven't tried that with INNODB.
Only thing was that the server slowed a bit down due the disc activity. So I do it when the usage of the server is on the lowest point.
When you use diskeeper or the windows defrag program first time it may take a long time. I remember when I did that first on the company server which had a different administrator before it took 42 hrs for 400 GB.
Thank god now it takes only 30 minutes to 2 hrs once a week. |
|
| Back to top |
|
