Solved

defragging our SQL server

Posted on 2013-05-30
6
442 Views
Last Modified: 2013-05-31
I run tasks on our SQL database to rebuild indexes periodically, but it just dawned on me that I never run the Windows Defragging utility on the actual server.  I am using Windows 2003 server.  

If I use this utility regularly, would it make a significant difference in the performance of the SQL database?  Are there any dangers to using it?  The database is only about 8GB in size
0
Comment
Question by:al4629740
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39208732
the Windows defragger does not actually impact the SQL fragmentation as the defragger has no knowledge of SQL data storage.
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39208787
There's no real need.  I can imaging a case where the databases have been set up horribly (small auto-grows and auto-shrink turned on - ugh!) and the way they grew was oddly spread out so that disk fragmentation occurred, but it is very unlikely.

Have you run disk defrag on your DATA and/or LOG drives and just done an analysis to see how fragmented they were?

My gut says don't defrag.  *IF* your fragmentation is really bad, say 40% or higher, then I would think about it.  You can run disk de-frag anytime, even on open files, but performance goes to the crapper while its running.
0
 

Author Comment

by:al4629740
ID: 39209861
How do I run defrag just on the Data?
0
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 250 total points
ID: 39209871
Most DBAs store their DATA and LOG files on separate drives.  Your asking of the question makes me think this is not the case for you (and that you have both on the same drive, which is bad).  You can only defrag an entire drive (which I'm thinking you already know).
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 250 total points
ID: 39210222
>>How do I run defrag just on the Data?

you just need to reindex and the data will be defragged.
0
 
LVL 23

Expert Comment

by:nemws1
ID: 39211486
Thanks for the points
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

728 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