SQL Server Performance

slow CommitTran

Discussion in 'Analysis Services/Data Warehousing' started by dxd, Jun 28, 2005.

  1. dxd New Member

    Our program is very slow (taking a few of hours) in doing the last two
    steps (CommitTran or CloseServer) of the following code segment. Any clue? Thanks
    ----------------------
    dsoDB.BeginTrans
    processing each partitions incrementally.
    dsoDB.CommitTrans
    dsoServer.CloseServer
    ------------------------

    Background:
    The OLAPData has about 20 cubes.
    Each cubes has 13 partitions (by separated by Month)
    SQL Server 2000 (Enterprise), Sp3
    CPU 4 or 8, 8 GB Ram.
    While doing CommitTran and CloseServer, we can see that the
    Memory used by the processingProgram is dropping very very slowly (from over 1GB).
  2. satya Moderator

    Other options are setup profiler to trace it or use 'display estimated execution plan' in query analyzer to see what happens.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page