Processing measure groups together using same dimensions

Hi,

2 separate measure groups of a cube are being processed with 2 separate SSIS packages and these measure groups use same dimensions of the cube. SSIS packages are used to handle the partitions. Would there be a conflict if the SSIS packages both attempt to Process the same dimensions (update/full process) at the same time?

How does Analysis Services 2005 handle this? Does one wait for the other and then the 2nd package skips the Dim process or reprocesses it?

In such cases, is there a need to have a SSIS package that processes only the dimensions 1st and then the other 2 packages start off parallely to process the 2 measure groups without touching the dims.

Regards

You can process the dimension first in one step and after this processing have succeded you can process the two measure groups partitions in parallell.

Your last alternative sounds correct.

Regards

Thomas Ivarsson.

Process: %processor time

Hi,
I am monitoring the above counter on a 4 processor box
and have 2 questions:
(1) the value for 2 instances (there are 5 all together)
is ~200, so how is this a %? Is this to be read as 200/4
so 50%?
(2) the instances are listed as sqlservr #1, sqlservr #2
etc - how can I resolve this to the instance name?
TIA,
Mary
Mary,
1: Yes, divide the total percent by the number of instances. Double check
with Task Manager.
2. What operating system are you using? On Windows XP, Perfmon separates the
counters by instance name.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Mary" <anonymous@.discussions.microsoft.com> wrote in message
news:112801c4f721$51e21910$a501280a@.phx.gbl...
> Hi,
> I am monitoring the above counter on a 4 processor box
> and have 2 questions:
> (1) the value for 2 instances (there are 5 all together)
> is ~200, so how is this a %? Is this to be read as 200/4
> so 50%?
> (2) the instances are listed as sqlservr #1, sqlservr #2
> etc - how can I resolve this to the instance name?
> TIA,
> Mary
|||Thanks Ron,
I'm using Win 2000 Server. The counters are separated by
instance name for most things, but for Process they are
not - they appear as a numbered list in the bottom right-
hand corner.
Thanks,
Mary

Process: %processor time

Hi,
I am monitoring the above counter on a 4 processor box
and have 2 questions:
(1) the value for 2 instances (there are 5 all together)
is ~200, so how is this a %? Is this to be read as 200/4
so 50%?
(2) the instances are listed as sqlservr #1, sqlservr #2
etc - how can I resolve this to the instance name?
TIA,
MaryMary,
1: Yes, divide the total percent by the number of instances. Double check
with Task Manager.
2. What operating system are you using? On Windows XP, Perfmon separates the
counters by instance name.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Mary" <anonymous@.discussions.microsoft.com> wrote in message
news:112801c4f721$51e21910$a501280a@.phx.gbl...
> Hi,
> I am monitoring the above counter on a 4 processor box
> and have 2 questions:
> (1) the value for 2 instances (there are 5 all together)
> is ~200, so how is this a %? Is this to be read as 200/4
> so 50%?
> (2) the instances are listed as sqlservr #1, sqlservr #2
> etc - how can I resolve this to the instance name?
> TIA,
> Mary|||Thanks Ron,
I'm using Win 2000 Server. The counters are separated by
instance name for most things, but for Process they are
not - they appear as a numbered list in the bottom right-
hand corner.
Thanks,
Mary

Process: %processor time

Hi,
I am monitoring the above counter on a 4 processor box
and have 2 questions:
(1) the value for 2 instances (there are 5 all together)
is ~200, so how is this a %? Is this to be read as 200/4
so 50%?
(2) the instances are listed as sqlservr #1, sqlservr #2
etc - how can I resolve this to the instance name?
TIA,
MaryMary,
1: Yes, divide the total percent by the number of instances. Double check
with Task Manager.
2. What operating system are you using? On Windows XP, Perfmon separates the
counters by instance name.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Mary" <anonymous@.discussions.microsoft.com> wrote in message
news:112801c4f721$51e21910$a501280a@.phx.gbl...
> Hi,
> I am monitoring the above counter on a 4 processor box
> and have 2 questions:
> (1) the value for 2 instances (there are 5 all together)
> is ~200, so how is this a %? Is this to be read as 200/4
> so 50%?
> (2) the instances are listed as sqlservr #1, sqlservr #2
> etc - how can I resolve this to the instance name?
> TIA,
> Mary|||Thanks Ron,
I'm using Win 2000 Server. The counters are separated by
instance name for most things, but for Process they are
not - they appear as a numbered list in the bottom right-
hand corner.
Thanks,
Mary