System tables fragmentation

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • matt
    #1

    System tables fragmentation

    can you defrag system tables. They appear in my dbcc showcontig
    report. Some are worse than other but if it where a user table I
    would defrag it. However the reindex commands doesnt work on system
    tables.... Any ideas.

    Thanks Matt.
    Tags: None
    • Paul S Randal [MS]
      #2
      Re: System tables fragmentation

      There's no supported way to defrag system tables. Why do you think you need
      to remove fragmentation in them?

      Regards.

      --
      Paul Randal
      Dev Lead, Microsoft SQL Server Storage Engine

      This posting is provided "AS IS" with no warranties, and confers no rights.

      "matt" <matt@perfectda ta.co.nz> wrote in message
      news:39e680eb.0 411151657.580aa 259@posting.goo gle.com...[color=blue]
      > can you defrag system tables. They appear in my dbcc showcontig
      > report. Some are worse than other but if it where a user table I
      > would defrag it. However the reindex commands doesnt work on system
      > tables.... Any ideas.
      >
      > Thanks Matt.[/color]


        Comment

        Previous template Next
        Working...