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
Printable View
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
With same version of sql and AS? I'll set perfmon in this case to check cpu, disk i/o and network i/o.