slow CommitTran | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

slow CommitTran

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