DB REORG

Is there a concept similar to DB reorganization in SQL
Server? The reason I am asking this is because batch
updates have doubled in it's turnaround time. Looking at
indexes, everything is fine. I thought that, perhaps,
data should be reorganized in appropriate pages and free
space.
If you have other suggestions, I would be interested in
them.
Thanks in advanceIt depends of exactly what you mean with REORG. First, read in Books Online about below commands:
DBCC SHOWCONTIG
DBCC DBREINDEX
DBCC INDEXDEFRAG
Then (a must :-) ), read below great whitepaper on the subject:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:0caf01c4a580$58557910$a601280a@.phx.gbl...
> Is there a concept similar to DB reorganization in SQL
> Server? The reason I am asking this is because batch
> updates have doubled in it's turnaround time. Looking at
> indexes, everything is fine. I thought that, perhaps,
> data should be reorganized in appropriate pages and free
> space.
> If you have other suggestions, I would be interested in
> them.
> Thanks in advance|||Thanks for your help.
You have mentioned index defragmation. What about data
table defragmation?
>--Original Message--
>It depends of exactly what you mean with REORG. First,
read in Books Online about below commands:
>DBCC SHOWCONTIG
>DBCC DBREINDEX
>DBCC INDEXDEFRAG
>Then (a must :-) ), read below great whitepaper on the
subject:
>http://www.microsoft.com/technet/prodtechnol/sql/2000/main
tain/ss2kidbp.mspx
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"RG" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0caf01c4a580$58557910$a601280a@.phx.gbl...
>> Is there a concept similar to DB reorganization in SQL
>> Server? The reason I am asking this is because batch
>> updates have doubled in it's turnaround time. Looking
at
>> indexes, everything is fine. I thought that, perhaps,
>> data should be reorganized in appropriate pages and free
>> space.
>> If you have other suggestions, I would be interested in
>> them.
>> Thanks in advance
>
>.
>|||This is why I asked what you mean by fragmentation and reorganization. Are you referring to re-claim
free space in your pages? Or making the data more contiguous?
Also, please consider that a table without a clustered index is a heap table. There is no order to
speak about here.
And for a table with a clustered index, the heap pages of the clustered index are your data pages.
I.e., to reorg such, you reorg the clustered index.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:02aa01c4a592$7efe9bc0$a401280a@.phx.gbl...
> Thanks for your help.
> You have mentioned index defragmation. What about data
> table defragmation?
>
>>--Original Message--
>>It depends of exactly what you mean with REORG. First,
> read in Books Online about below commands:
>>DBCC SHOWCONTIG
>>DBCC DBREINDEX
>>DBCC INDEXDEFRAG
>>Then (a must :-) ), read below great whitepaper on the
> subject:
>>http://www.microsoft.com/technet/prodtechnol/sql/2000/main
> tain/ss2kidbp.mspx
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"RG" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:0caf01c4a580$58557910$a601280a@.phx.gbl...
>> Is there a concept similar to DB reorganization in SQL
>> Server? The reason I am asking this is because batch
>> updates have doubled in it's turnaround time. Looking
> at
>> indexes, everything is fine. I thought that, perhaps,
>> data should be reorganized in appropriate pages and free
>> space.
>> If you have other suggestions, I would be interested in
>> them.
>> Thanks in advance
>>
>>.|||All of the tables in question have clustered index. I am
looking to have the data stored contiguously because they
are pivotal tables in batch processing. In addition, I
would like to make sure I have my 10% free space per page
as batch is performing updates to these tables.
Thanks again
>--Original Message--
>This is why I asked what you mean by fragmentation and
reorganization. Are you referring to re-claim
>free space in your pages? Or making the data more
contiguous?
>Also, please consider that a table without a clustered
index is a heap table. There is no order to
>speak about here.
>And for a table with a clustered index, the heap pages of
the clustered index are your data pages.
>I.e., to reorg such, you reorg the clustered index.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"RG" <anonymous@.discussions.microsoft.com> wrote in
message
>news:02aa01c4a592$7efe9bc0$a401280a@.phx.gbl...
>> Thanks for your help.
>> You have mentioned index defragmation. What about data
>> table defragmation?
>>
>>--Original Message--
>>It depends of exactly what you mean with REORG. First,
>> read in Books Online about below commands:
>>DBCC SHOWCONTIG
>>DBCC DBREINDEX
>>DBCC INDEXDEFRAG
>>Then (a must :-) ), read below great whitepaper on the
>> subject:
>>http://www.microsoft.com/technet/prodtechnol/sql/2000/ma
in
>> tain/ss2kidbp.mspx
>>--
>>Tibor Karaszi, SQL Server MVP
>>http://www.karaszi.com/sqlserver/default.asp
>>http://www.solidqualitylearning.com/
>>
>>"RG" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:0caf01c4a580$58557910$a601280a@.phx.gbl...
>> Is there a concept similar to DB reorganization in SQL
>> Server? The reason I am asking this is because batch
>> updates have doubled in it's turnaround time. Looking
>> at
>> indexes, everything is fine. I thought that, perhaps,
>> data should be reorganized in appropriate pages and
free
>> space.
>> If you have other suggestions, I would be interested
in
>> them.
>> Thanks in advance
>>
>>.
>
>.
>|||That is just fine. All the information you need is in the sections in Books Online for the commands
I mentioned in my first post, and also make sure you read the KB article I posted an URL to in tat
same first post.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RG" <anonymous@.discussions.microsoft.com> wrote in message
news:031d01c4a597$ec30ea90$a401280a@.phx.gbl...
> All of the tables in question have clustered index. I am
> looking to have the data stored contiguously because they
> are pivotal tables in batch processing. In addition, I
> would like to make sure I have my 10% free space per page
> as batch is performing updates to these tables.
> Thanks again