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

SSAS vs Database Sharding Expand / Collapse
Author
Message
Posted Monday, August 29, 2011 10:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 28, 2012 9:26 PM
Points: 22, Visits: 44
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
Post #1166978
Posted Monday, August 29, 2011 1:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 3:50 PM
Points: 292, Visits: 1,623
4-5 TB, is pretty trivial for a year's worth of data. Any decently architected cube set (SSAS) should be just fine. I'm alwasy skeptical of the latest buzz word, so I'd be curious to know what that contractor means by Sharding. As far as I know SQL Server only offer partitioning, currently. And SQL Azure, offers sharding, but, I think, that is managed at the back-end and is not user controllable.
Post #1167140
Posted Monday, August 29, 2011 2:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 28, 2012 9:26 PM
Points: 22, Visits: 44
Lamprey3,

Thanks for your reply.

Sharding is a $2.50 word for distributing data into multiple databases based upon some sort of logic that improves reporting performance.

I have been researching SSAS recently and I like the product very much. I want to offer my users some carefully-controlled, ad-hoc reporting capability and I am thinking SSAS can help a lot.

I don't want to fail to make SSAS part of our final, reporting platorm simply because the contractor was not familar with SSAS or wants to be called every time we need new output.

WDT3

Post #1167187
Posted Tuesday, February 7, 2012 7:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 21, 2012 9:04 AM
Points: 4, Visits: 6
Would this webinar on database sharding help?

http://vimeo.com/26742356

-Mike
Post #1248676
Posted Wednesday, February 8, 2012 7:20 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 4,346, Visits: 6,155
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 at GMail
Post #1248955
Posted Wednesday, February 8, 2012 9:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 28, 2012 9:26 PM
Points: 22, Visits: 44
Kevin,

I didn't provide report details, because the reports have not yet been designed. We are collecting details on requirements now.

I was looking for general opinions from, hopefully, experienced SQL folks as to how well SSAS performs. I have experimented with the product using relatively small tables containing simulated data. I like the designer interface. The way things are built, in SSAS, seems to me to be very intuitive. If it perfoms reasonably well with large tables, it will be a viable solution.

Thanks anyway, for taking the time to respond.

WDT3
Post #1249160
Posted Thursday, February 9, 2012 5:51 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 4,346, Visits: 6,155
If you really need very large scale SSAS size/performance I would definitely stick with the newest edition of SQL Server you can move to. They have improved scalability and manageability significantly in the last few editions, and I think this continues in SQL 2012. Do note however, that much of the BI underpinnings is changing significantly in the latest version of the SQL Server ecosystem.

Best of luck with your project - sounds like fun! Drop me a line if you need some help with the relational engine side of things, or a second (NON-SSAS) pair of eyes. I couldn't SSAS my way out of a paper bag with both ends open, but I can make the relational engine spin like a top!


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1249639
Posted Thursday, February 9, 2012 8:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 28, 2012 9:26 PM
Points: 22, Visits: 44
Kevin,

Thanks so much. This is exactly the type of advice I need right now.

It is very likely that I will be needing some paid consultation on this. If you will send me your email address, we can connect outside of the forum.

My email is: btidwell3@comcast.net

Thanks,

WDT3
Post #1249766
Posted Tuesday, February 21, 2012 7:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 21, 2012 9:04 AM
Points: 4, Visits: 6
Kevin here are a couple of great datatbase sharding videos from dbshards.com

http://vimeo.com/26742356

http://www.slideshare.net/rightscale/rightscale-webinar-scaling-your-database-in-the-cloud
Post #1255249
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse