July 23, 2004 at 8:50 am
I have a small, simple, non-changing dimension pointed to a table of 4 (yes, four) rows. The DTS step to incrementally process this dimension regularly takes 5 minutes. As far as I can tell, there is no AS processing going on, only user queries. SQL Server is fine, there are no blocked queries, and no heavy CPU or I/O Any suggestions on where to start the diagnostics effort? Here is the package log info. There are 2 large, glaring pauses, but I don't know what I can do about them. Suggestions?
Thanks,
Larry
7/23/2004 8:15:03 AM 899 Initiating transaction in Database 'MyOLAPDB'
7/23/2004 8:15:04 AM 899 Processing Dimension 'MyDimension' Start Time 8:15:04
7/23/2004 8:15:04 AM 899 Initializing Dimension 'MyDimension'
7/23/2004 8:17:16 AM 899 Dimension 'MyDimension' EXECUTE 'SELECT col1, col2, col3 from MyTable'
7/23/2004 8:17:16 AM 899 Complete Processing Dimension 'MyDimension'. Endtime 8:17:16 AM Duration 0:02:12 Rows Processed: 4
7/23/2004 8:17:16 AM 899 Committing transaction in Database 'MyOLAPDB'
7/23/2004 8:20:16 AM 899 Committed transaction in Databaes 'MyOLAPDB'
Larry
July 26, 2004 at 7:25 am
Never seen anything like that before. Do all your dimensions take an age to run?
I would suggest making sure you have all the service packs installed. Then delete the dimension table in case something is wrong with it and recreate. also, drop the dimension and recreate it as well.
July 26, 2004 at 6:12 pm
Have you got process logging on your AS machine? It may help to compare the start and ends times of the actuall processing on the AS box with whats reported in DTS.
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply