Database Maintenance on a SQL 7 Database

I have a client that I just took on who is running SQL 7. Their database
isn't too big - about 400mb. They are telling me that the performance isn't
nearly as good as it once was. They have been using this database for about 6
years now. I don't believe they have been doing any kind of maintenance on
the database except for backing it up. Can anyone tell me what I should be
doing to this database on a routine basis? Also, they tell me that it is
mainly saving data that takes a very long time. Could this be due to the fact
that maintenance hasn't been performed on this database in it's entire
existence? Thank you.Hi Jeff
You could look at using a maintenance plan and go through the wizard to
specify your index maintenance, or you could write your own more targetted
process using DBCC SHOWCONTIG, DBCC INDEXDEFRAG and DBCC DBREINDEX the
action you take depending on the level of fragmentation reported (you can use
the example in SQL 2000 books online DBCC SHOWCONTIG as the basis for such a
process).
John
"Jeff" wrote:
> I have a client that I just took on who is running SQL 7. Their database
> isn't too big - about 400mb. They are telling me that the performance isn't
> nearly as good as it once was. They have been using this database for about 6
> years now. I don't believe they have been doing any kind of maintenance on
> the database except for backing it up. Can anyone tell me what I should be
> doing to this database on a routine basis? Also, they tell me that it is
> mainly saving data that takes a very long time. Could this be due to the fact
> that maintenance hasn't been performed on this database in it's entire
> existence? Thank you.