April 7, 2010 at 12:35 am
Hi, We want to install an Analysis Services in our enterprise needs, can I install it as a new service side by side with current database engine cluster or does it better to install it on a new server, what can be the pros and cons?
Thanks
April 7, 2010 at 12:51 am
One of the big considerations is licensing. Another consideration is performance. In my current environment we have SSIS, SSAS,SSRS, and SQL Server installed on the same server in several instances. Some servers don't require those additional services.
It will depend largely on business needs, volume, and load required by the servers.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2010 at 1:04 am
it is fine but I would still keep the SSAS and DB file on different sets of disk and make sure to set the memory correctly for each so they are not going after the same set of memory.
that being said since CPUs have multi cores and multi threading in some cases it may be the cheaper route to just have a 2nd server. (I would suggest it) typically a new server with memory can be cheaper than trying to get larger memory sticks to accommodate the added needs of both services running
April 7, 2010 at 1:09 am
I think the consideration for memory and cpu is one of those "it depends" situations. Memory is so cheap these days. And if you are buying a new server, I would max it out right from the get go (cheaper in the long run if you think there is any chance you will need it).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2010 at 2:01 am
Hi Jason, thanks for the replies, in our environment our primary consideration is performance, our database engines are consolidated so each have a high workload, do I have a trouble in the future if I have a standalone AS server for AS needs in our enterprise, I mean is AS suitable for consolidation?
How do you set different memory sets for AS and DB, by setting min max server memory?
April 7, 2010 at 10:55 am
You could consolidate it. You would need to take your time with it and plan.
I don't see there being any real hindrance other than the additional licensing and hardware cost.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply