There’s two different types of “fragmentation” in databases… There’s good ol’ file system fragmentation of the database files themselves… This type of fragmentation can be somewhat mitigated / limited by intelligently choosing how your DB auto-grows (if you have that feature enabled, or if it’s available depending on the DB/app itself), etc. You don’t want to defrag the DB files while the database is running. It’s generally safe to defrag the files when the DB is not running. If you’re running multiple DB’s, make sure to stop them all. (And of course, back-up first!)
Then there’s fragmentation within the DB itself. Fragmentation within the tables or indexes themselves can harm performance as much or even more than file system fragmentation depending on the DB…. Checking and eliminating that type of fragmentation depends on the type of DB you’re talking about. JP From: Doug Rooney [mailto:d...@sonomatilemakers.com] Sent: Wednesday, December 16, 2009 12:30 PM To: MS-Exchange Admin Issues Subject: RE: Defragmenting servers OK, so does that mean the databases do not get fragmented, or there is another way to defrag them? I do not support our databases, only the hardware that houses them, but I do support Exchange. Thank You ~Doug Rooney Sonoma Tilemakers IT Manager 7750 Bell Rd. Windsor Ca, 95492 (707) 837-8177 X211 (707) 837-9472 FAX i...@sonomatilemakers.com<mailto:i...@sonomatilemakers.com> From: David.Ricci [mailto:david.ri...@hwinstitute.com] Sent: Wednesday, December 16, 2009 7:21 AM To: MS-Exchange Admin Issues Subject: RE: Defragmenting servers That is where I got it from. So now it is ok so as long as it is not a database "obviously exchange, sql" just file systems. Thank you, David M. Ricci IS Manager The Health & Wellness Institute 291 Promenade Street Providence, RI 02908 T: 401.228.1332 C: 401.256.4933 F: 401.228.1399 www.hwinstitute.com<http://www.hwinstitute.com> david.ri...@hwinstitute.com<mailto:david.ri...@hwinstitute.com> SERVICE. INNOVATION. RESULTS. -----Original Message----- From: Michael B. Smith [mailto:mich...@smithcons.com] Sent: Wednesday, December 16, 2009 10:02 AM To: MS-Exchange Admin Issues Subject: RE: Defragmenting servers Do you remember "way back when"? When NT 3.5 and 4.0 came out, Microsoft told us NTFS didn't need defragging....thus was born a new industry. :-) -----Original Message----- From: Kurt Buff [mailto:kurt.b...@gmail.com] Sent: Wednesday, December 16, 2009 9:58 AM To: MS-Exchange Admin Issues Subject: Re: Defragmenting servers The really old school notion is to have a file system that doesn't need it, like UFS... Heh. On Wed, Dec 16, 2009 at 06:45, David.Ricci <david.ri...@hwinstitute.com<mailto:david.ri...@hwinstitute.com>> wrote: > I was always under the impression that it was bad to defrag a server. > I guess that was an old school notion. > > > > > David M. Ricci > IS Manager > The Health & Wellness Institute > 291 Promenade Street > Providence, RI 02908 > T: 401.228.1332 > C: 401.256.4933 > F: 401.228.1399 > www.hwinstitute.com<http://www.hwinstitute.com> > david.ri...@hwinstitute.com<mailto:david.ri...@hwinstitute.com> > > SERVICE. INNOVATION. RESULTS. > > > -----Original Message----- > From: Michael B. Smith [mailto:mich...@smithcons.com] > Sent: Tuesday, December 15, 2009 5:00 PM > To: MS-Exchange Admin Issues > Subject: RE: Defragmenting servers > > It provides a marginal speed improvement (assuming you defrag > regularly). > > I like MyDefrag (used to be JKDefrag). It's free and it's fast. > > -----Original Message----- > From: mqcarp [mailto:mqcarpen...@gmail.com] > Sent: Tuesday, December 15, 2009 4:47 PM > To: MS-Exchange Admin Issues > Subject: Defragmenting servers > > Does anyone use tools like diskeeper to defrag their nondatabase > servers? Is it recommended? > This e-mail and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. > If you are not the intended recipient, you are hereby notified that > any disclosure, copying, distribution, or taking any action in > reliance on the information contained in this e-mail is prohibited. If > you have received this e-mail in error, please immediately notify our > e-mail administrator at > supp...@hwinstitute.com.<mailto:supp...@hwinstitute.com.>