Database performance improvement

People:

I work with IBM DB2 and there is a tool called REORGCHK and REORG.

It is used to eveluate the status of tables and indexes(REORGCHK) and in case we run the REORG to fix any fragmentation problem in tables and indexes...

The question is Is there something similar in SQL Server?

I have deleted lots of records and looks like after that the performance of the database is not very good.

Thankswhat version of SQLserver?

Sounds like a rebuild of the index may be needed, it can't hurt to rebuild
after a large delete.

At a low level you could run
DBCC INDEXDEFRAG

Via Enterprise (SQLserver 2000) you can create a maintenance plan to cleanup space and indexes. Just run the wizard to create the optimisation job and run it straight away.

Have Fun|||I have SQL 2000 Server.
Can I run the dbcc command during the day??|||Hi,

If you using SQLserver 2000, the easiest solution is to create a maintenance plan to do this periodically eg once per week.

In Enterprise Manager choose the database -> management
right click on database maintenance plans -> choose new plan

Follow the wizard to create an optimisation maintenance plan.

I tend to create a plan for optimisation and integrity checking and a separate one for back of database / logs.

If your database is really under the weather running the DBCC (or a maintenance doing the same thing) would the highest priority. So running during the day is justified.

Have Fun