al4629740
asked on
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
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
the Windows defragger does not actually impact the SQL fragmentation as the defragger has no knowledge of SQL data storage.
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.
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.
ASKER
How do I run defrag just on the Data?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the points