Index Physical Statistics

The Index Physical Statistics report is telling me to rebuild or reorganize a
few indexes on some of my tables, and I did. The report still tells me to
rebuild or reorganize a few indexes. Should I be concerned that the report
still tells me to do what I just did?
Hi Curtis
Can you be more specific about what report you are referring to? Is it
giving you any additional information about the indexes that it is telling
you to rebuild?
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:376470F8-C429-4327-82B4-BDD2FEAE2ADC@.microsoft.com...
> The Index Physical Statistics report is telling me to rebuild or
> reorganize a
> few indexes on some of my tables, and I did. The report still tells me to
> rebuild or reorganize a few indexes. Should I be concerned that the report
> still tells me to do what I just did?
|||The report is part of the management studio.
It also tells me:
Avg Fragmentation (%) 13
# Fragments 8
Avg Pages Per Fragment 4
#Pages 31
"Kalen Delaney" wrote:

> Hi Curtis
> Can you be more specific about what report you are referring to? Is it
> giving you any additional information about the indexes that it is telling
> you to rebuild?
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Curtis" <Curtis@.discussions.microsoft.com> wrote in message
> news:376470F8-C429-4327-82B4-BDD2FEAE2ADC@.microsoft.com...
>
>
|||If your tables are small, then don't worry about its suggestion to
rebuild/reorg.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:81785ED5-988F-4EC3-BB23-7CF16511F592@.microsoft.com...
The report is part of the management studio.
It also tells me:
Avg Fragmentation (%) 13
# Fragments 8
Avg Pages Per Fragment 4
#Pages 31
"Kalen Delaney" wrote:

> Hi Curtis
> Can you be more specific about what report you are referring to? Is it
> giving you any additional information about the indexes that it is telling
> you to rebuild?
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://sqlblog.com
>
> "Curtis" <Curtis@.discussions.microsoft.com> wrote in message
> news:376470F8-C429-4327-82B4-BDD2FEAE2ADC@.microsoft.com...
>
>
|||Only 32 pages. MS recommends not to worry about fragmentation unless you have at least 1000 pages.
The report should take that into consideration, but apparently doesn't.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:81785ED5-988F-4EC3-BB23-7CF16511F592@.microsoft.com...[vbcol=seagreen]
> The report is part of the management studio.
> It also tells me:
> Avg Fragmentation (%) 13
> # Fragments 8
> Avg Pages Per Fragment 4
> #Pages 31
> "Kalen Delaney" wrote:
|||You should look at the number of pages before deciding to rebuild an index.
For very small tables, not only will fragmentation not hurt you, but it will
be almost impossible to get rid of.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:81785ED5-988F-4EC3-BB23-7CF16511F592@.microsoft.com...[vbcol=seagreen]
> The report is part of the management studio.
> It also tells me:
> Avg Fragmentation (%) 13
> # Fragments 8
> Avg Pages Per Fragment 4
> #Pages 31
> "Kalen Delaney" wrote: