Post reply

Processing Cube with MS-SQL Agent Job Shcheduled is Very Slow

  • February 13, 2009 at 2:51 pm

    #128740

    Hi, I have a Scheduled Job that process my Cubes, but it is very slow, more than 5 hours

    When we run the same Job from the MS-SQL Agent , but manually it run in about 44 minutes.}

    Do any one have any clue?

    Using ms-sql 2000 and ms-AS 2000

    TIA

  • February 13, 2009 at 3:20 pm

    #943967

    This could be related to what else is the Agent doing and memory use in the box because in 2005 if you run many jobs some will fail. It could also be the reason the Agent in now a 64bits process.

    Kind regards,
    Gift Peddie

  • February 13, 2009 at 3:33 pm

    #943972

    Thanks for the answer, but is the only job working at the same time.

    Any other clue?

    Tia

  • February 13, 2009 at 3:47 pm

    #943982

    Here is what I mean if you are using the Agent to run many tasks then it can get slow.

    We run an Agent job for five hours a day five days a week and the box running the Agent that is the only thing running in it. Yes no database just that Agent Job in one box.

    Kind regards,
    Gift Peddie

  • February 16, 2009 at 12:14 am

    #944342

    Have you created a DTS package that is run from your job? Have you tried to run the DTS package with dtsrun and see if it performs or not?

    http://www.dwexplorer.com
    @dtwegener

Viewing 5 posts - 1 through 4 (of 4 total)

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