SQLServerCentral.com Articles tagged Fragmentation

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

Fri, 20 Apr 2012 06:00:00 UT

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

No Significant Fragmentation? Look Closer…

Wed, 14 Mar 2012 06:00:00 UT

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.

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

Fri, 26 Feb 2010 07:00:00 UT

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.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Keep Your SQL Server Indexes Fragmentation Free

Tue, 22 Sep 2009 06:00:00 UT

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.

Analyze and Fix Index Fragmentation in SQL Server 2008

Thu, 11 Dec 2008 07:00:00 UT

This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation

Predictable Index Fragmentation

Wed, 29 Oct 2008 06:00:00 UT

This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.