Post reply

Issue with specific table accessing having Performance issue

  • April 23, 2014 at 2:55 pm

    #286052

    Hi All,

    Having a DB of 400GB,with 3 .ndf files and don't have any additional file group for indexing, the SP's which are associated with this main table(ExceptionsTrackingTable) having records of 125 Million having an issue.

    The table records shows this.

    table name: ExceptionsTrackingTable

    number of rows: 125285250

    reservedsize : 194574576 KB

    Datasize: 97786344 KB

    Index Size: 96726312 KB

    Ununsedsize : 61920 KB

    Attached the Table schema,Indexes and keys.

    Could you please suggest something which is missed for this table and i need to take care.Any help much appreciated.

  • April 23, 2014 at 6:36 pm

    #1708279

    And what is the problem?

  • April 23, 2014 at 9:25 pm

    #1708293

    I, of course, can't tell for sure but your PK looks pretty well hosed. Is, for example, ActID ever increasing? Why is it a VARCHAR(50)? Is ActID, by any chance, unique unto itself?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

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