Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Fragmentation Rss

Search for any content tagged fragmentation

   Items 1 to 6 of 6   
 

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...
By Kenneth Igiri 2012/04/20 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 6,262 reads

No Significant Fragmentation? Look Closer…

If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.  Read more...
By Additional Articles 2012/03/14 | Category: fragmentation
Rating: (not yet rated)  Rate this |   Briefcase | 2,892 reads

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.  Read more...
By Additional Articles 2010/02/26 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,092 reads

Keep Your SQL Server Indexes Fragmentation Free

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.  Read more...
By Additional Articles 2009/09/22 | Source: DevX | Category: indexing
Rating:  Rate this |   Briefcase | 4,988 reads

Analyze and Fix Index Fragmentation in SQL Server 2008

This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation  Read more...
By Additional Articles 2008/12/11 | Source: SQL Server Performance | Category: fragmentation
Rating:  Rate this |   Briefcase | 2,449 reads

Predictable Index Fragmentation

This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.  Read more...
By Craig Outcalt 2008/10/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,429 reads
   Items 1 to 6 of 6