i need to know if there's any way to defrag a database 
Author Message
 i need to know if there's any way to defrag a database
We are trying to improve the performance of our database, and we are
migrating the database from one machine to another. This proccess requires
much time and we are looking for an alternative.
Also, i need to know if there's any way to defrag a database.

Thanks



Tue, 21 Jan 2003 03:00:00 GMT
 i need to know if there's any way to defrag a database

On Fri, 4 Aug 2000 15:05:55 -0400, "Carlos Gallardo"

Quote:

>We are trying to improve the performance of our database, and we are
>migrating the database from one machine to another. This proccess requires
>much time and we are looking for an alternative.
>Also, i need to know if there's any way to defrag a database.

rebuild your clustered indexes...
__________________________________________________
"Nothing is as subjective as reality"

http://www.xs4all.nl/~reinoud
__________________________________________________


Tue, 21 Jan 2003 03:00:00 GMT
 i need to know if there's any way to defrag a database
There's only way to do that : rebuilding clustered indexes.

Carlos Gallardo a crit :

Quote:
> We are trying to improve the performance of our database, and we are
> migrating the database from one machine to another. This proccess requires
> much time and we are looking for an alternative.
> Also, i need to know if there's any way to defrag a database.

> Thanks



Fri, 24 Jan 2003 03:00:00 GMT
 i need to know if there's any way to defrag a database
Carlos,

Is your database fragmented because of numerous space allocations over time or
are the tables fragged? If it's tables rebuild the clustered indexes - do a
reorg if it's supported at you ASE version level. If the db itself is
fragmented, the create a new database, build your tables, bcp the data out and
into the new db, then build your indexes. Build your indexes last or you'll be
doing logged bcps which tke a lot longer and fill up syslogs.

Rick Gebethner

Quote:

> There's only way to do that : rebuilding clustered indexes.

> Carlos Gallardo a crit :

> > We are trying to improve the performance of our database, and we are
> > migrating the database from one machine to another. This proccess requires
> > much time and we are looking for an alternative.
> > Also, i need to know if there's any way to defrag a database.

> > Thanks



Mon, 27 Jan 2003 03:00:00 GMT
 i need to know if there's any way to defrag a database
**** Post for FREE via your newsreader at post.usenet.com ****

Quote:


> >Also, i need to know if there's any way to defrag a database.
> rebuild your clustered indexes...

        I wonder if there is a better way ...

        I am considering rebuilding indexes at a customer site.
        However, they don't have the DDL source. I can easily fix this
        by reverse engineering the schema. Unfortunately, their vendors
        have gone to town with RI constraints et al. So I started looking
        around and thought about using dbcc reindex(). This, however,
        requires that the index be marked suspect. So, the obvious
        question is - has anyone updated the status column in the
        sysindexes table to mark an index as suspect in order to use
        dbcc reindex()? If so, did you note any problems with this
        approach? I can imagine that performance won't be the best
        (unable to use "with sorted_data" clause etc.), but I can
        live with that.

-am

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
                      http://www.usenet.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=



Fri, 31 Jan 2003 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Ways to know you've got the consulting bug

2. Tablespace/table/database reorg/defrag pointers needed

3. to defrag or not to defrag

4. Now I know Australia is down under (in more ways than one)

5. Don't know the field name but do know the column order

6. need to know more about Win95's system security

7. Can't defrag binary data in a table

8. I'm failing three different ways....

9. Ways of calling SP's

10. Need a definitve answer from Microsft or MVP on defrag

11. Different SQL Server's Approaching View in different ways

12. Defrag for datafiles needed


 
Powered by phpBB® Forum Software