defragging our SQL server

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
al4629740Asked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
>>How do I run defrag just on the Data?

you just need to reindex and the data will be defragged.
0
 
Éric MoreauSenior .Net ConsultantCommented:
the Windows defragger does not actually impact the SQL fragmentation as the defragger has no knowledge of SQL data storage.
0
 
nemws1Database AdministratorCommented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
al4629740Author Commented:
How do I run defrag just on the Data?
0
 
nemws1Connect With a Mentor Database AdministratorCommented:
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
 
nemws1Database AdministratorCommented:
Thanks for the points
0
All Courses

From novice to tech pro — start learning today.