January 7, 2009 at 11:39 am
Hello all,
I suggested we don't install AS in our SQL Server because we really don't use AS currently.
Then my boss asked me: Will Database Service functionality will keep intact without installing Analysis Service?
My answer is just those two are totally different services. they are seperated. then my boss said,"well, you never know".
How do you answer this question?
January 7, 2009 at 11:49 am
It depends, what are you doing? We have a currently dead in the water DW project. Our DW development server has the SQL Server Database Engine and SSIS only installed. We have a second development server where we installed the SQL Server Database Engine, SSAS, SSIS, and SSRS.
Both servers work just fine. If you don't need SSAS, don't install it. It is a separate service and the SQL Server Database Engine is not dependent on it.
January 7, 2009 at 12:00 pm
our new server is production server. It will be heavily loaded. In my plan, even though we will develope DW, it should be considered to use a seperated server. not in this server.
the short answer is we don't use any AS functionality currently.
January 7, 2009 at 12:13 pm
Judy (1/7/2009)
our new server is production server. It will be heavily loaded. In my plan, even though we will develope DW, it should be considered to use a seperated server. not in this server.the short answer is we don't use any AS functionality currently.
Based on the above, this is an OLTP database server, correct? Then, yes, you don't need SSAS installed. Also, yes, the DW should also be on its own server when you build it. You may want to install SSAS on the same server you have your DW. I went with a separation, as I did not want IIS installed on the server with the main DW database where we would be doing the staging, data scrubing, and such as data went into the DW. The DW would then populate various DataMarts on the second server, where SSAS, SSRS are also installed and various reporting would be handled there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply