dbTalk Databases Forums  

AS2005: Multiple developpers with Source Safe and 1 OLAP Server...

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


Discuss AS2005: Multiple developpers with Source Safe and 1 OLAP Server... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default AS2005: Multiple developpers with Source Safe and 1 OLAP Server... - 02-08-2006 , 09:13 AM






Hi,

This is my setup:
I'm using Visual Source Safe for my version control for my AS2005 cubes.
I have only 1 AS2005 server.
So all the developpers use the same target server.

everytime a developper deploy the cubes or part of the solution (like 1
dimension) there is a warning because the version on the server is different
(due to a previous deployment by another dev.)
Installing AS on each dev. station consume some resources on each station.

Do you think this setup is good? or not recommanded?
does installing multiple instance on the server is better?
anyone can share his experience for a team development around AS2005 cubes?

thanks.

Jerome.



Reply With Quote
  #2  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: AS2005: Multiple developpers with Source Safe and 1 OLAP Server... - 02-08-2006 , 09:06 PM






It probably makes sense to give each developer separate instance if not
possible installing AS on each dev machine.

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


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
Hi,

This is my setup:
I'm using Visual Source Safe for my version control for my AS2005 cubes.
I have only 1 AS2005 server.
So all the developpers use the same target server.

everytime a developper deploy the cubes or part of the solution (like 1
dimension) there is a warning because the version on the server is
different (due to a previous deployment by another dev.)
Installing AS on each dev. station consume some resources on each station.

Do you think this setup is good? or not recommanded?
does installing multiple instance on the server is better?
anyone can share his experience for a team development around AS2005
cubes?

thanks.

Jerome.





Reply With Quote
  #3  
Old   
Jéjé
 
Posts: n/a

Default Re: AS2005: Multiple developpers with Source Safe and 1 OLAP Server... - 02-08-2006 , 09:58 PM



I want to centralize my AS server for multiple reasons:
* cost to upgrade each dev. desktop to support all the tools (client;
server; office...)
* processing time: slow other the 100mbps network; better other the 1Gbps
server(s) side; also my server use more memory, better disks (Raid 0+1) and
better CPUs (new AMD Opteron dual core x64) - Processing 40 millions of test
rows (shared in multiple cubes) takes 10minutes on the server...

but giving 1 instance by developper... what is the overhead?
How AS manage and release the memory when there is multiple instances?
(I mean 5 dev instances; maybe more)


"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> wrote

Quote:
It probably makes sense to give each developer separate instance if not
possible installing AS on each dev machine.

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


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:%23ld6CJMLGHA.2416 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi,

This is my setup:
I'm using Visual Source Safe for my version control for my AS2005 cubes.
I have only 1 AS2005 server.
So all the developpers use the same target server.

everytime a developper deploy the cubes or part of the solution (like 1
dimension) there is a warning because the version on the server is
different (due to a previous deployment by another dev.)
Installing AS on each dev. station consume some resources on each
station.

Do you think this setup is good? or not recommanded?
does installing multiple instance on the server is better?
anyone can share his experience for a team development around AS2005
cubes?

thanks.

Jerome.







Reply With Quote
  #4  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: AS2005: Multiple developpers with Source Safe and 1 OLAP Server... - 02-09-2006 , 11:24 AM




"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:
I want to centralize my AS server for multiple reasons:
* cost to upgrade each dev. desktop to support all the tools (client;
server; office...)
* processing time: slow other the 100mbps network; better other the 1Gbps
server(s) side; also my server use more memory, better disks (Raid 0+1)
and better CPUs (new AMD Opteron dual core x64) - Processing 40 millions
of test rows (shared in multiple cubes) takes 10minutes on the server...

but giving 1 instance by developper... what is the overhead?
How AS manage and release the memory when there is multiple instances?
(I mean 5 dev instances; maybe more)


"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> wrote in message
news:elmrNXSLGHA.3064 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
It probably makes sense to give each developer separate instance if not
possible installing AS on each dev machine.

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


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:%23ld6CJMLGHA.2416 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi,

This is my setup:
I'm using Visual Source Safe for my version control for my AS2005 cubes.
I have only 1 AS2005 server.
So all the developpers use the same target server.

everytime a developper deploy the cubes or part of the solution (like 1
dimension) there is a warning because the version on the server is
different (due to a previous deployment by another dev.)
Installing AS on each dev. station consume some resources on each
station.

Do you think this setup is good? or not recommanded?
does installing multiple instance on the server is better?
anyone can share his experience for a team development around AS2005
cubes?

thanks.

Jerome.









Reply With Quote
  #5  
Old   
Edward Melomed [MSFT]
 
Posts: n/a

Default Re: AS2005: Multiple developpers with Source Safe and 1 OLAP Server... - 02-09-2006 , 11:42 AM



By having multiple instances you can provide each developer with an isolated
environment.

The price for that is:

you will have to adjust memory limits for each instance.

Same dimension if exists on each instance will be loaded multiple times.



The bottom line. If your can afford ( you hardware has capacity ) running
multiple instances, it cleaner approach.

If the data and dimension sizes are substantial and you are seeing
processing and query performance is suffering, you should bring all
developers back to the single instance.



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


"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:
I want to centralize my AS server for multiple reasons:
* cost to upgrade each dev. desktop to support all the tools (client;
server; office...)
* processing time: slow other the 100mbps network; better other the 1Gbps
server(s) side; also my server use more memory, better disks (Raid 0+1)
and better CPUs (new AMD Opteron dual core x64) - Processing 40 millions
of test rows (shared in multiple cubes) takes 10minutes on the server...

but giving 1 instance by developper... what is the overhead?
How AS manage and release the memory when there is multiple instances?
(I mean 5 dev instances; maybe more)


"Edward Melomed [MSFT]" <edwardm (AT) norely (DOT) micrsoft.com> wrote in message
news:elmrNXSLGHA.3064 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
It probably makes sense to give each developer separate instance if not
possible installing AS on each dev machine.

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


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:%23ld6CJMLGHA.2416 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi,

This is my setup:
I'm using Visual Source Safe for my version control for my AS2005 cubes.
I have only 1 AS2005 server.
So all the developpers use the same target server.

everytime a developper deploy the cubes or part of the solution (like 1
dimension) there is a warning because the version on the server is
different (due to a previous deployment by another dev.)
Installing AS on each dev. station consume some resources on each
station.

Do you think this setup is good? or not recommanded?
does installing multiple instance on the server is better?
anyone can share his experience for a team development around AS2005
cubes?

thanks.

Jerome.









Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.