DBCC showcontig

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
Hi, can you show an output of DBCC command?
"jumblesale" <mcgants@.gmail.com> wrote in message
news:1158146780.765411.233730@.e3g2000cwe.googlegro ups.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
>
|||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.co...gmentation.asp
Thanks
Hari
SQL Server MVP
"jumblesale" <mcgants@.gmail.com> wrote in message
news:1158146780.765411.233730@.e3g2000cwe.googlegro ups.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
>
|||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.

DBCC showcontig

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,
jHi, 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
>|||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.com/rd_index_fragmentation.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
>|||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.sql

DBCC showcontig

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,
jHi, 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
>|||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...agmentation.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
>|||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.

DBCC Consistency Errors after copying the backup file

Hello,
I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy) it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.
Has anybody come acrross this? How do you copy your backup files?
Any tip will be really appreciated.
Noel
Looks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed
<zerg2k@.yahoo.com> wrote in message
news:1163603641.098898.40150@.m7g2000cwm.googlegrou ps.com...
> Hello,
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy) it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
> Has anybody come acrross this? How do you copy your backup files?
> Any tip will be really appreciated.
> Noel
>

DBCC Consistency Errors after copying the backup file

Hello,
I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy) it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.
Has anybody come acrross this? How do you copy your backup files'
Any tip will be really appreciated.
NoelLooks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed
<zerg2k@.yahoo.com> wrote in message
news:1163603641.098898.40150@.m7g2000cwm.googlegroups.com...
> Hello,
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy) it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
> Has anybody come acrross this? How do you copy your backup files'
> Any tip will be really appreciated.
> Noel
>

DBCC Consistency Errors after copying the backup file

Hello,
I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
my source database with *no errors*, then I take a full database backup
and copy(xcopy,robocopy) it to another server and restore it there.
Very often I am getting DBCC consistency errors when I run the CHECKDB
on the remote (backup) server.
Has anybody come acrross this? How do you copy your backup files'
Any tip will be really appreciated.
NoelLooks strange .Perhaps during the copy process the file is getting
corrupted.
At my company we backup the db , then compres .BAK file by WINRAR and then
copy it. If you have VLDB , consider using third party tool like Litespeed
<zerg2k@.yahoo.com> wrote in message
news:1163603641.098898.40150@.m7g2000cwm.googlegroups.com...
> Hello,
> I am facing a problem that is *very* odd. I am runing DBCC CHECKDB on
> my source database with *no errors*, then I take a full database backup
> and copy(xcopy,robocopy) it to another server and restore it there.
> Very often I am getting DBCC consistency errors when I run the CHECKDB
> on the remote (backup) server.
> Has anybody come acrross this? How do you copy your backup files'
> Any tip will be really appreciated.
> Noel
>