sbs 2003 and defrag

sbs 2003 and defrag
BillShultzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vico1CIOCommented:
What about it?
What do you need to know about defrag?
0
BillShultzAuthor Commented:
First of all, I'm not used to this new UI.  So, I was just trying to do a search but put the search criteria in the wrong part of the UI.  What I'm really trying to find out is the following:
1.  Is there a documented procedure for using the Manual Defragger that comes with SBS 2003?  Do I just execute the defrag?  Do I have to close down SQL Server and Exchange Server services and databases firsdt?  Or is it smart enough to deal with these?
2.  Note that I'm just talking about an external file defrag in #1 above.  I realize that to do an internal defrag for SQL Server and Exchange, I need to use the utilities in those products.  And my understanding is that internal defrags would rarely be done (based upon the activity).
3.  Am I correct in assuming that Executive Software's Diskeeper Server 2007 would handle all defrag functionality automatically, can be scheduled and is very reliable; stable and safe to use even during daytime production?
0
vico1CIOCommented:
I have actually never used the native defrag of SBS. So I won't say that it can or cannot do a good job. But I can tell you that diskkeeper does a good job.
To that YES you are correct assuming that Excecutive Software would handle it.

However I have to ask why do you want to defrag your SBS Server?

I have client using SBS for many years and never had to defrag their system, I am not implying that you don't have to do it but, why, Are you loosing performance on the server?

Vico1
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

BillShultzAuthor Commented:
Yes. I have a client who is seeing a performance issue with a particular function in their LOB app which has a 2.0 GB SQL Server database.  The particular function is definitely doing a DB lookup which appears to be happening slower than the users can type.  Based on a user selected listbox entry, a DB lookup is being done to get data attributes that are used to dynamically build the next data entry fields. The users are entering the data but it appears to be not accepting the beginning characters because it's too slow.

The server itself is a Dell PowerEdge 1800 with 2 hyperthreaded Xeon 2.8 GHrz CPUs, 4 GB memory and a RAID 5 SATA disk array.  

While investigating that problem, I did a defrag analysis of the C: drive which contains the LOB database (I suspect I will move the DB files to another drive).  The analysis found the 32 GB partition to be 44% used with Volume Fragmentation listed as Total Fragmentation = 34% and File Fragmentation = 69%.  Those number seem very, very high and likely to contribute to this performance issue.

I ran a LOB app which does the equivilent of an internal defrag of their database and I hope that helps this problem.  In fact, I set that up as a scheduled nightly job.  But I also think I should look at doing a defrag too.
0
BillShultzAuthor Commented:
Actually, I just realized I made an error in my description of my client's server.  I said it had SATA drives, but it really has SCSI drives running at 10K RPM.  It's my SBS system that has the SATA drives.  Bottom line is that the disk drives themselves shouldn't be responsible for the performance issue.
0
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
I regularly defrag all volumes on every SBS I manage.  There are no problems in doing so.

I do also keep all data files off of the system partition which helps to keep things running more smoothly.  See http://sbsurl.com/movedata for info on that.

Jeff
TechSoEasy
0
BillShultzAuthor Commented:
Jeff --

Thanks for the response.  I actually have moved all the data off the system partition as per that article.  However, when I was reviewing the server setup, I discovered thast the LOB app that has the performance issue is on the system partition.  I must have had a brain cramp when I ran the LOB setup and neglected to move thast one.  Regardless, the partition containing the databases is also requires a defrag.  

Could you just clarify your "no problems" response by noting your method of defrag?  Do you use the SBS system defag or Diskeeper or something else?  Also can you address my original Item 1 questions which were:
Is there a documented procedure for using the Manual Defragger that comes with SBS 2003?  Do I just execute the defrag?  Do I have to close down SQL Server and Exchange Server services and databases first?  Or is it smart enough to deal with these?

Thanks.
0
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
I generally create a maintenance plan for all SQL databases to defrag themselves on a weekly basis.  I then have a scheduled task that runs the standard system defrag on all partitions on a weekly basis as well.  There's no need to close down either Exchange or SQL when running these... it's just that those things don't get defragged.

Jeff
TechSoEasy
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
I should add that I generally run a defrag with ESEUTIL on the Exchange Databases on a quarterly basis.

Jeff
TechSoEasy
0
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.