|
Home > Archive > MS SQL Server > October 2006 > DBCC showcontig
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jumblesale 2006-10-24, 6:28 pm |
| Hello,
I have a very fragmented database and am running dbcc dbreindex but
getting a very odd issue.
When running DBCC SHOWCONTIG before and after reindexing the tables,
there is no difference in the statistics. The scan fragmentation levels
(in fact all of the statistics) are exactly the same.
How can this be?
I've also run the indexdefrag command and it gives exactly the same
results before and after.
Am i doing something very wrong??
Cheers in advance,
j
| |
| Uri Dimant 2006-10-24, 6:28 pm |
| Hi, can you show an output of DBCC command?
"jumblesale" <mcgants@gmail.com> wrote in message
news:1158146780.765411.233730@e3g2000cwe.googlegroups.com...
> Hello,
> I have a very fragmented database and am running dbcc dbreindex but
> getting a very odd issue.
> When running DBCC SHOWCONTIG before and after reindexing the tables,
> there is no difference in the statistics. The scan fragmentation levels
> (in fact all of the statistics) are exactly the same.
> How can this be?
> I've also run the indexdefrag command and it gives exactly the same
> results before and after.
> Am i doing something very wrong??
>
> Cheers in advance,
> j
>
| |
| Hari Prasad 2006-10-24, 6:28 pm |
| Hi,
Based on the SHOWCONTIG result; take a look into Scan Density, Login scan
and Extend scan fragmentation.
Read this article; this help you to analyze more:-
http://www.sql-server-performance.c...ti
on.asp
Thanks
Hari
SQL Server MVP
"jumblesale" <mcgants@gmail.com> wrote in message
news:1158146780.765411.233730@e3g2000cwe.googlegroups.com...
> Hello,
> I have a very fragmented database and am running dbcc dbreindex but
> getting a very odd issue.
> When running DBCC SHOWCONTIG before and after reindexing the tables,
> there is no difference in the statistics. The scan fragmentation levels
> (in fact all of the statistics) are exactly the same.
> How can this be?
> I've also run the indexdefrag command and it gives exactly the same
> results before and after.
> Am i doing something very wrong??
>
> Cheers in advance,
> j
>
| |
| JXStern 2006-10-24, 6:28 pm |
| On 13 Sep 2006 04:26:20 -0700, "jumblesale" <mcgants@gmail.com> wrote:
>Hello,
>I have a very fragmented database and am running dbcc dbreindex but
>getting a very odd issue.
>When running DBCC SHOWCONTIG before and after reindexing the tables,
>there is no difference in the statistics. The scan fragmentation levels
>(in fact all of the statistics) are exactly the same.
>How can this be?
>I've also run the indexdefrag command and it gives exactly the same
>results before and after.
>Am i doing something very wrong??
Do you have any clustered indexes on the tables involved?
J.
|
|
|
|
|