Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

dedicated server for analysis services Expand / Collapse
Author
Message
Posted Monday, January 20, 2014 4:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 3:50 PM
Points: 43, Visits: 142
I have one business group that creates a ton of cubes via analysis services right now that are on SQL 2008. However, I've recently started moving everything over to SQL2012 so with that said. Do you all run Analysis Services on the same server as all your other SQL databases or do you run this on a separate server? I really don't see the benefit to running it on a separate server than again I'm new to SQL server administration.
Post #1532563
Posted Monday, January 20, 2014 6:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 5:08 AM
Points: 391, Visits: 703
From personal experience it depends but generally I would recommend that it is separate. What else is happening on the box? If you have all of your SQL databases on the same box in may be wise to consider a separate server for SSAS. If SSAS is used heavily and you have large cubes then it would be best on a separate server. There are many factors to consider - volume and velocity of data, query types, concurrency, cost etc.

Have a read of these whitepapers and see what you think:
http://msdn.microsoft.com/en-us/library/hh226085.aspx
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=17303

Plus there is a good forum post here:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a5e37957-3e35-4ffc-96aa-80c9467c2255/put-sql-server-ssas-on-the-same-server-or-different-server?forum=sqlanalysisservices

Good luck.





I'm on LinkedIn
Post #1532610
Posted Wednesday, January 29, 2014 11:50 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:12 AM
Points: 606, Visits: 345
You might be able to get away with having them both on the same server. It depends on what else is going on with the server and the size of your cubes. If your data warehouse is 10 GB and your cube is 5 GB that's one thing. If the data warehouse is 1TB and the cube 500GB then you're probably going to run into issues with resource contention as the SSAS process wants all the CPU/RAM but the Database Engine needs quite a bit as well just to respond to queries SSAS is generating. Capture PerfMon stats and see what's going on during processing.



Post #1536068
Posted Wednesday, February 12, 2014 4:38 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 21, 2014 1:53 AM
Points: 24, Visits: 185
I have a cluster with both database engine and Analysis Services running on them with no problem, but as people have already said it depends on the scale of your operation, resources, disk subsystem etc...

Also to consider is that you'll need to ensure that the Analysis Services and database engine resource allocations are correctly configured. If you don't, you'll start to see contention issues. The SQL max and min server memory settings for the database engine are quite straightforward, however the Analysis Services settings are not so much. See the link for details:

[url=http://technet.microsoft.com/en-us/library/ms174556(v=sql.105).aspx][/url]
Post #1540638
Posted Wednesday, February 12, 2014 9:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
SSRS is usually the first to be scaled out, THEN SSIS, THEN SSAS. Use the Analysis Services Performance and Operations guide to make your final decision.
Post #1540867
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse