SQL Server Performance

Utilities to handle data fragmentation issue

Discussion in 'Performance Tuning for DBAs' started by georgej, Apr 9, 2007.

  1. georgej New Member

    Are there any utilities to take care the issues of data fragmentation, especially on SAN storage disks?
    Thanks for recommendation,

    georgej, Apr 9, 2007
    #2

  2. MohammedU New Member

    For disk fragmentation check with your SAN vendor where for table/data fragmentation... sql server has commands you can use them...

    Check books online for syntax of the following commands..

    DBCC DBREINDEX
    DBCC INDEXDEFRAG

    Microsoft SQL Server 2000 Index Defragmentation Best Practices
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
    MohammedU, Apr 9, 2007
    #2

  3. Luis Martin Moderator

    Luis Martin, Apr 9, 2007
    #2

  4. satya Moderator

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20599 too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
    satya, Apr 9, 2007
    #2

Share This Page