WDT3 (8/29/2011)
To all -My company is upgrading to SS 2008 R2 as well as a new server and data=storage architecture. By end of the year we will be accessing roughly 4-5 terabytes of data with our reporting platform, which is also upgrading to SSRS. One contractor suggests that we not use SSAS as part of the solution, opting for database sharding for performance. However, I like SSAS.
Should SSAS be part of out solution?
Thanks,
WDT3
You gave us essentially zero details on what the reports look like or the data they access/process, incremental data addition volumes, etc. We cannot provide advice without WAY more information from you.
Is the contractor suggesting non-SSAS solution because they don't have experience in that? Consider their motivation.
SQL Server 2012 columnar indexes may also be useful if you want to make a generational leap to that version.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service