September 7, 2009 at 3:40 am
why fragementation occurs ,how to resolve the fragmentation ?
September 7, 2009 at 4:38 am
As the database grows data stops being grouped on the same pages/extents meaning that as you query tables SQL is having to search through a larger amount of pages etc to find the data that you need.
By reindexing tables SQL rearranges the data into more logical page/extants grouping table data together improving speed when querying the data. By setting a sensible fillfactor you can leave space on pages to ensure that as tables grow the data doesn`t fragment quickly.
September 7, 2009 at 5:40 am
ramyours2003 (9/7/2009)
why fragementation occurs ,how to resolve the fragmentation ?
This has been asked multiple times by you in the past in this forum and have been answered too, still same question?
http://www.sqlservercentral.com/Forums/Topic777368-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic777331-146-1.aspx
I wonder u went through the link Gail provided. It clearly explains with example what is fragmentation and how it happens.
September 7, 2009 at 7:35 am
This is the link that Gail provided to you before:
See - http://sqlinthewild.co.za/index.php/2008/10/20/what-is-fragmentation/
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 7, 2009 at 11:18 am
fragmentation in which layer? files on file system or objects in database?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply