>Thanks Kevin,
>I've been looking at the SQL BI offering but having trouble getting an approximate price to see if it is a runner, any idea how much it would run for 1 site with a regular server (1-2 processor probably 4-8 core).
>~M
Do you know if you're looking at the BI license for SQL or the Enterprise license? (And are you looking at SQL 2012 or 2014)
OK, so you have one box. Approximately how many users do you have, how many (roughly) will run concurrently, what's the size of your biggest tables (I.e. a billion rows, 100 million rows, etc) and how often would your reporting/analytic data need to be updated (on demand/real-time, every 30 minutes, twice a day, etc.)
These aren't the only factors but we can start with those.