-
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
-
Where is data source? On same server? Any difference between those two servers?
-
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.
-
How about server load, hardware spec, network speed, disk i/o and so? Any difference?
-
the new servers are in upgraded environment so better than the old setup
Last edited by Naseem; 02-01-2007 at 02:14 AM.
-
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
-
Forum Rules
|
|