November 21, 2014 at 6:42 am
My employer is looking at upgrading our BI solution, currently based on SQL 2005 and provided by the core vendor which supports our business. The new platform will be the same vendor's solution but based on SQL 2012.
The catch is that my employer announced a large merger recently, which will roughly double the size of the DW plus the number of rows being imported via ETL every processing cycle. Add to that both companies' culture of acquisition and I can project the BI scale doubling again over the life of this BI product.
The vendor's requirement sheet, sent to us before the merger announcement, called for a single SQL 2012 server which would host the DW but also run SSAS and SSIS. My concern is that a one server solution won't scale to double its current size, let alone 4X.
I'm starting to to do research for a presentation outlining the scalability concerns of running the BI solution for a multi billion dollar corporation off a single SQL server hosting the DW, SSIS and SSAS. Who are the SMEs in SQL BI scaling? Any good recommendations for white papers, blogs, etc about scalability in the SQL Server business intelligence space? Would SQL CAT be a good (free) resource for scalability and architecture issues?
Thanks,
Andre Ranieri
November 21, 2014 at 12:14 pm
This SSAS Performance Guide from MS might be a start for you:
http://msdn.microsoft.com/en-us/library/dn749781.aspx
HTH,
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply