Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OS-Level defragmentation?

0 views
Skip to first unread message

Linn Kubler

unread,
May 26, 2010, 11:32:37 PM5/26/10
to

Hi,

I've often wondered about OS-Level defraging my data disks of my SQL Server
2005 server. Is it recommended, is there anything I should be looking out
for? How often should it be done? Things like that.

Any suggestions?

Thanks in advance,
Linn


Erland Sommarskog

unread,
May 27, 2010, 5:36:29 PM5/27/10
to
Linn Kubler (lku...@chartwellwisc2.com) writes:
> I've often wondered about OS-Level defraging my data disks of my SQL
> Server 2005 server. Is it recommended, is there anything I should be
> looking out for? How often should it be done? Things like that.

Hopefully: almost never.

But that presumes that you grow data files in a planned and order manner.
If you just say "CREATE DATABASE mydatabase" and then never make any
adjustments, your database will grow in small small steps, and this
can lead to considerable disk fragmentation.

But if you create your databases with good sizes from the beginning,
and grow them in an ordered fashion in maintenance windows, there
should not be much fragmentation.


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0 new messages