Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    73

    Unanswered: 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.

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Sydney,Australia
    Posts
    44
    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
    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

  3. #3
    Join Date
    May 2002
    Posts
    73

    database performance improvement

    I have SQL 2000 Server.
    Can I run the dbcc command during the day??

  4. #4
    Join Date
    Jul 2002
    Location
    Sydney,Australia
    Posts
    44
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •