There is no technical reason why not. I run it on my machines like that all
of the time.
It is just that in production you may have to spend some time getting your
memory allocation right because all three can consume heavy amounts of
memory and CPU from time to time (as they are server-based products).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Attila" <Attila (AT) discussions (DOT) microsoft.com> wrote

cause any problems, I was hoping that others would comment based on their
own experiences. Your input would be much appreciated.

Each server application has its own resource allocation technique.

Since you are looking to run all 3 in production on the same box, it might
require by-hand allocation. For example, suppose you have 8GB of memory --
you might want to allocate 3GB to the RDBMS, 2GB to Analysis Services; 2GB
to Reporting Services (and don't forget at least 1GB for the OS and other
related processes running on the box).

For Analysis Services, if you use Analysis Manager and right-click on the
server name, select "Properties..." and then look at the Environment tab you
will see the high and low memory allocation which Analysis Services will
use. This is virtual memory allocation, but unless you are willing to take a
tremendous amount of page faults, it roughly maps to physical memory also.
By default, Analysis Services is installed with high memory set to the
amount of memory on the machine (up to 2GB) and low memory at 1/2 of that
value. See the Analysis Services Operations Guide
(http://www.microsoft.com/technet/pro...n/anservog.msp
x ) under the section "Configuration Management".

The SQL Server RDBMS will, by default, attempt to allocate all physical
memory that it can -- and then back off if the computer page fault rate goes
too high. It keeps backing off until the system stabalizes. While this is OK
for an interactive computer, it isn't good if you are using other server
applications on the same box as this takes time and is variable over when it
runs. So in that case you might decide to tune the RDBMS memory allocation
by-hand. This means setting the memory options maually,see BOL under the
topic "Server Memory Options" for a detailed discussion of how to do this
and the implications.

Reporting Services as a web service uses memory allocation based on its IIS
virtual directory and the IIS web site that it is running under.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Attila" <Attila (AT) discussions (DOT) microsoft.com> wrote

Dave,

What is the recommended server configuration for an organization that wishes to use all three applications in a production environment? Would it be best to have each application installed on a separate server?

Attila


"Dave Wickert [MSFT]" wrote:

I can't answer that in the general case. It is dependent on the resources
used.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Attila" <Attila (AT) discussions (DOT) microsoft.com> wrote

be best to have each application installed on a separate server?