|
Home > Archive > MS SQL Server OLAP > August 2005 > long cube processing after migrating jobs to the server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
long cube processing after migrating jobs to the server
|
|
| אלעד שלום 2005-08-31, 8:24 pm |
| 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
| |
| Dave Wickert [MSFT] 2005-08-31, 8:24 pm |
| 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/pr...n/ansvcspg.mspx
And in the AS Opeations Guide for how to enable the system-wide processing
log file
http://www.microsoft.com/technet/pr...n/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@online.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 in message
news:D345350D-1FB4-42EC-B022- 35E24F7D9463@microso
ft.com...
> 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
|
|
|
|
|