Post reply

Table Partitioning on Existing Table IN MS SQL 2005

  • April 9, 2009 at 10:01 am

    #201903

    Hi Experts,

    I Have 1 TB database and 2 applications r connecting to the server.

    Application 1 : SAP

    Applicaiton 2 : processing

    Right now we have problem in Application 2 and user are complaining that they have slow response time some times during the week days ...

    Application 2 using only 5 tables , Recently I have rebuild the index onthese 5 tables but not results.

    Can I create partition on exiting tables if so what are the steps I need to take ..does it improve performence ?

    Please let me know if your suggestion s

    Thanks

    Ichbinraj

  • April 9, 2009 at 10:06 am

    #975186

    How many rows do the Five tables hold?

    Are these Five tables also used by the SAP application?

  • April 9, 2009 at 10:12 am

    #975193

    Hi rows information

    A ( Records 38543)

    B (Records 46873)

    C (Records 110857)

    D (Records 36227)

    E (Records 43559)

    Yes these tables are also used by SAP application

    Thanks

    Ichbinraj

  • April 9, 2009 at 10:24 am

    #975206

    Those table row counts are no where big enough to be considering partioning, so I would look at other ways to improve performance such as Indexing and optimizing queries.

    Also if you decide to partition (i wouldn't) then you may have to re-write the code that SAP uses in order to access the partitioned tables which may mean a lot of work/cost.

  • April 9, 2009 at 11:15 am

    #975260

    Do we have any kind of other method to resolve this problem ?

    Thanks

    ichbinraj

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply