Production DBAs roles in different groups under a DB Manager

I am curious to know how some of the big organizations have their DB org
structure from an Operations perspective
Can someone let me know how its done in your organization and how it has
helped ? I am looking for the different groups under say a director/manager
of database operations ?
Thank youWe are spilt into 3 groups: Adabase, DB2, and SQL server. One of the DB2
guys dabbles a bit in SQL (maybe assist with migrations, easy data
transfers, etc.) which has been nice on busy days.
I was on the phone yesterday though with a company that is also split into 3
groups: Development, QA, and Production. I would guess this greatly reduces
the amount of people that need security rights to production boxes.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:evgwOD3XGHA.4484@.TK2MSFTNGP02.phx.gbl...
> I am curious to know how some of the big organizations have their DB org
> structure from an Operations perspective
> Can someone let me know how its done in your organization and how it has
> helped ? I am looking for the different groups under say a
director/manager
> of database operations ?
> Thank you
>

Production DBAs roles in different groups under a DB Manager

I am curious to know how some of the big organizations have their DB org
structure from an Operations perspective
Can someone let me know how its done in your organization and how it has
helped ? I am looking for the different groups under say a director/manager
of database operations ?
Thank youWe are spilt into 3 groups: Adabase, DB2, and SQL server. One of the DB2
guys dabbles a bit in SQL (maybe assist with migrations, easy data
transfers, etc.) which has been nice on busy days.
I was on the phone yesterday though with a company that is also split into 3
groups: Development, QA, and Production. I would guess this greatly reduces
the amount of people that need security rights to production boxes.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:evgwOD3XGHA.4484@.TK2MSFTNGP02.phx.gbl...
> I am curious to know how some of the big organizations have their DB org
> structure from an Operations perspective
> Can someone let me know how its done in your organization and how it has
> helped ? I am looking for the different groups under say a
director/manager
> of database operations ?
> Thank you
>

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.

ProcessAdd processing hangs

I'm trying to do an incremental process of a cube that has 3 measure groups. The first measure group is fairly straightforward, run-of-the-mill measures. The other 2 are distinct counts of an ID.

When running the incremental process (ProcessAdd), the status seems to complete, and then everything just hangs. I can't find anything that the server is doing, but it won't return. This happens in BIDS using debug, management studio wizard, and management studio XMLA execution windows.

Sometimes I can get the first measure group to return... Once the 3rd returned. The 2nd has never worked.

Thoughts on what's happeneing? Does anyone know how to see what's going on in the background? I have a SQL trace going and a trace on the SSAS server, and nothing seems to be going on...

Thanks!
-DougI have a similar issue occurring. I have an SSIS package that uses an analysis services task to incrementally update the most recent partition in three measure groups. It hangs everytime when run under the SQL agent Job engine, however, it processes fine through the SSIS debugger in BIDS.

I think I'm going to try submitting the XMLA statement directly from the job rather than going through SSIS. Did you ever figure out the issue you were seeing?|||

Try and run Profiler against Analysis Server and see if there is any activity is goign on.

Make sure you've got latest service pack installed. And lastly: if the problem still persists, contact product support services and report it.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

ProcessAdd processing hangs

I'm trying to do an incremental process of a cube that has 3 measure groups. The first measure group is fairly straightforward, run-of-the-mill measures. The other 2 are distinct counts of an ID.

When running the incremental process (ProcessAdd), the status seems to complete, and then everything just hangs. I can't find anything that the server is doing, but it won't return. This happens in BIDS using debug, management studio wizard, and management studio XMLA execution windows.

Sometimes I can get the first measure group to return... Once the 3rd returned. The 2nd has never worked.

Thoughts on what's happeneing? Does anyone know how to see what's going on in the background? I have a SQL trace going and a trace on the SSAS server, and nothing seems to be going on...

Thanks!
-DougI have a similar issue occurring. I have an SSIS package that uses an analysis services task to incrementally update the most recent partition in three measure groups. It hangs everytime when run under the SQL agent Job engine, however, it processes fine through the SSIS debugger in BIDS.

I think I'm going to try submitting the XMLA statement directly from the job rather than going through SSIS. Did you ever figure out the issue you were seeing?|||

Try and run Profiler against Analysis Server and see if there is any activity is goign on.

Make sure you've got latest service pack installed. And lastly: if the problem still persists, contact product support services and report it.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.