Results 1 to 6 of 6

Thread: Cube processing takes time

  1. #1
    Join Date
    Aug 2006
    Posts
    5

    Cube processing takes time

    Hi,
    cube processing is taking more time in a new server while same cubes takes less time in another server.
    the cubes are processed through DTS package
    can anybody help finding out the possible reasons for this.
    Regards
    Naseem

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Where is data source? On same server? Any difference between those two servers?

  3. #3
    Join Date
    Aug 2006
    Posts
    5
    we had db server and Analysis server on different machines , the DTS package is in the DB server which connects to the anaylysis server to processes the cubes.
    this setup has been moved to two new servers.
    the time taken in the old servers up takes lessthan half the time to complete than the new servers the data is same at both the setups.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    How about server load, hardware spec, network speed, disk i/o and so? Any difference?

  5. #5
    Join Date
    Aug 2006
    Posts
    5
    the new servers are in upgraded environment so better than the old setup
    Last edited by Naseem; 02-01-2007 at 02:14 AM.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    With same version of sql and AS? I'll set perfmon in this case to check cpu, disk i/o and network i/o.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •