db fragmentation

[Dale Palmer]

HELP,
I was expanding a device when I got the error message that the db was to fragmented.

I ran sp_coalesce_fragments and it reduced the number of fragments by 5.

I think this is only a quick fix and require the procedure for defraging the db.

Can anyone help ?

Dale Palmer

[Craig]

It appears from Tecnet that it did not have to do with database fragmentation like on a table level, but it had to do with the fact that you appear to have increased the database 32 or 33 times.

If the sp worked ok, Tecnet says you are ok. How many fragments did it reduce the sysusages table for for that database? I am curious......


------------
Dale Palmer at 9/14/99 10:39:36 AM


HELP,
I was expanding a device when I got the error message that the db was to fragmented.

I ran sp_coalesce_fragments and it reduced the number of fragments by 5.

I think this is only a quick fix and require the procedure for defraging the db.

Can anyone help ?

Dale Palmer