var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Database performance improvement
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.
what 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
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.
database performance improvement
I have SQL 2000 Server.
Can I run the dbcc command during the day??
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.