Condusiv Technologies Blog

Condusiv Technologies Blog

Blogging @Condusiv

The Condusiv blog shares insight into the issues surrounding system and application performance—and how I/O optimization software is breaking new ground in solving those issues.

The Ins and Outs of SQL Defragmentation

by Michael 24. August 2010 08:14

IT Pro, Brad McGehee knows SQL, and writes about it frequently. He's even started several websites and blogs dedicated to SQL. A few years ago, he co-authored a paper with me where I discussed fragmentation of the SQL database files (.mdf, .ldf) commonly referred to as external fragmentation, and Brad discussed using DBCC statements to address what is commonly referred to as internal fragmentation.  You can read that article here.

On his current SQL blog, SQL Aloha, he ran a survey asking how DBAs handled internal fragmentation. Here are the results: 

You can read his full post here.

In addition to the script he links to, there are other good third party options out there to address that internal fragmentation including Idera's SQL defrag manager and Norb Technologies SQL Defrag Studio.

PS: while on the subject, here's another recent article on the subject 

 

Tags: , , ,

Comments are closed

RecentComments

Comment RSS

Month List

Calendar

<<  October 2019  >>
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

View posts in large calendar