Re: long cube processing after migrating jobs to the server

#1

Hopefully you have enabled the system-wide processing log file which records
the specifics of processing in various stages. Look in the AS Performance
Guide for information on how to speed up processing:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
And in the AS Opeations Guide for how to enable the system-wide processing
log file
http://www.microsoft.com/technet/pro.../anservog.mspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"???? ????" <@discussions.microsoft.com> wrote

Quote:

hi all,

we are running a sql server 2k. there is a DWH on the server and a cube
(also, on that server) wich is processed by a dts.

lately we have migraterd few jobs (from a sql 7) to the sql 2k machine.
thease jobs have nothing to do with the dwh or with the cube.

however, after moving the jobs to the sql 2k machine the processing of the
cube takes a very long time:

before oving the jobs- running the cube query via query analyzer took 45
secondes and the cube processing - 30 minutes.

now... running the query - 45 seconds and cube processing - 3.5 hours.

again, the new jobs have nothing to do with the dwh or with the cube.

so..any suggestion will be of help.

thanks,
elad

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: long cube processing after migrating jobs to the server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: long cube processing after migrating jobs to the server - 08-31-2005 , 07:38 PM