locked
Database enquiry RRS feed

  • Question

  • we have a database in Nestle Egypt it's capacity is 62GB we are working on the following environment :

    SQL server 2000 with ERP program I Scala which manufactured by EPICOR CORP,

    our platform server is windows2003 enterprise edition.

    we are facing a delay in the Database respond, so we got an idea to divide and archive the old data base.

    we decided to devide the database by years : example: 2001-2007 then 2008-current

    then the Scala "the EPR software " Consultant refused to make this division according to may be we face a risk and they suggest to make a balance to the new database from all the years later and to create a database from 0 record..

    so we need your advice about this issue

    your immediate answer really highly appreciated

    awaiting your reply.

    Thanks

     

    Tuesday, May 18, 2010 1:43 PM

Answers

  • "then the Scala "the EPR software " Consultant refused to make this division according to may be we face a risk and they suggest to make a balance to the new database from all the years later and to create a database from 0 record.."

    Total up old records and get rid of them? That is a very silly answer.

    Are you able to partition by year?

    Tuesday, May 18, 2010 2:59 PM
    Answerer

All replies

  • "then the Scala "the EPR software " Consultant refused to make this division according to may be we face a risk and they suggest to make a balance to the new database from all the years later and to create a database from 0 record.."

    Total up old records and get rid of them? That is a very silly answer.

    Are you able to partition by year?

    Tuesday, May 18, 2010 2:59 PM
    Answerer
  • What version of SQL Server are you using? Standard or Enterprise?  You'll need Enterprise for partitioning as suggested above.

    Also, it may be a silly question, but before you look at splitting the data out, what analysis have you done on the performance issues?

    Is it across the board?  Specific screens / stored procedures?

    Clive
    http://www.sqlsvrdba.com
    Tuesday, May 18, 2010 10:12 PM