fragmentation and defragmentation

Question

fragmentation and defragmentation

mohan.bndr

SSCrazy

Points: 2360
More actions
April 5, 2012 at 8:23 am

#271588

Hi,
I want to know about fragmentation and defragmentation. Please can any say what is fragmentation and defragmentation and when we use and purpose of this etc.
Thanks in advance.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Did you try Google or Books Online? Lots of info available.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Andy Hyslop SSCrazy Eights Points: 9198 More actions · Answer 2

Third hit on google

Fragmentation[/url]

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

mohan.bndr (4/5/2012)
I want to know about fragmentation and defragmentation. Please can any say what is fragmentation and defragmentation and when we use and purpose of this etc.

I'm curious. What prompted you to ask this question?

It's worded so broadly that it feels like an interview or homework question, which is why people are responding with "look it up yourself" responses.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

First Google result:

http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

GSquared SSC Guru Points: 260824 More actions · Answer 5

Fragmentation in the database world usually refers to index fragmentation. It happens (usually) because of inserts/updates/deletes of the data that's being indexed. It can slow down use of the table that's being indexed when it gets fragmented, so defragmenting it is about speeding that up.

There's a lot more to the subject. Like when/where/why on defragmentation, and when not/why not as well. There are ways to determine if fragmentation is happening, how much of it there is, and whether it's impacting performance or not.

Are you just trying to get basic definitions, or do you need to go into it in more detail?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Mac1986 SSCertifiable Points: 6216 More actions · Answer 6

No worries. I also learned everything online only. I'm not amused by your question. I agree it can be read online. Anyways here a nice link. hope you will have good understanding on Indexex and their ways for maintenance.

http://www.sql-server-performance.com/2011/index-maintenance-performance