Disk Fragmentation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Disk Fragmentation

Author

Topic

peter.mano
Starting Member

6 Posts

Posted - 2010-06-28 : 14:37:27

Suppose if i defragment my user table, along with this disk level fragmentation will also be reduced? Whether table level & disk level fragmentation are different?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-28 : 14:42:47

They are different.

Defragmenting indexes has no effect on disk level fragmentation.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

peter.mano
Starting Member

6 Posts

Posted - 2010-06-28 : 14:49:36

So, even after doing reindex task, suppose if fragmentation levels are higher, next is to check for disk level & go for disk defragment rite..

quote:
Originally posted by tkizer

They are different.

Defragmenting indexes has no effect on disk level fragmentation.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-28 : 15:19:33

We don't ever defragment our database files. Our systems are 24/7, so we can't afford to take the downtime.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources