Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Hardware configuration

    Hi Friends,
    This is my first post here. Hope for a good response from the gurus ;-)
    here it is....
    We have a medium size database (upto 50 tables) out of which one table is a massive. It gets populated online at very high speed (> 20,000 records a day) so it grows quite large in month. Now the problem is when it grows to that extent in a month at the end of 2 months any query fired on it takes toooo long to execute (to the magnitude of 10 minutes ). We have following hardware configuration

    1. 1.2 GHz Pentium 4
    2. 40 GB HDD
    3. 384 mb RAM.

    What should be the server configuration to boost the performance of the database??

    Regards,
    Vishal.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Hardware configuration

    It may not be your hardware configuration. How often do you Reorg the database?

  3. #3
    Join Date
    Nov 2003
    Posts
    2

    Re: Hardware configuration

    Currently we only backup the table( The Big one) and trim it to achieve the speed. Is this what U R talking about?? Is there any thing else we need to do in order to reorg the db??

  4. #4
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    after 2 months you should have something like 1200000 recrods yes?

    what sort of data is in these records?

    what indexes do you have on the table?

    what are the searches being performed?

    I imagine that if you applied some suitable indexes and possibly did some restructuring you should have not problems with this amount of data.

    Yes, eventually it will slow as more data comes on board but no where near the 10 mins you are talking about.....

  5. #5
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    What rokslide mentioned will help greatly. But Reorg is a quick fix to boost performance for a db with large amount of reads and writes because it rearrange the data and index pages. To do a reorg just simply use Database Maintenance Plan Wizard and check the Reorganize Data and Index Page. Execute the plan once a month, it will greatly help the performance of your database.

Posting Permissions

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