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).
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.
