SQL Server Performance

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 24, 2007.

  1. Anonymous New Member

    This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level scan performed. - Pages Scanned................................: 86 - Extents Scanned..............................: 12 - Extent Switches..............................: 12 - Avg. Pages per Extent........................: 7.2 - Scan Density [Best Count:Actual...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/24/1719.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1719" width="1" height="1">
  2. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » Rebuild Credit - Credit Card Mint Visa | Google Groups
  3. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » GENERATING WEB TRAFFIC
  4. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » E-Focus Network (M) Sdn. Bhd. : Web Design Malaysia | Web Hosting
  5. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » Hibernian Direct About Annual Renewal
  6. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » Rebuild some fragmented indexes - problem with Extent Scan
  7. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » RTACA Bird List
  8. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » Rebuild Credit - Credit Secured Mastercard Card | Google Groups
  9. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » AkhaWeeklyJournal : Messages : 294-323 of 506
  10. Anonymous New Member

    Pingback from 8web Internet Solutions » Blog Archive » Webmarketing RSS Marketing NewsMastering Global Promotion

Share This Page