May 23, 2012 at 2:02 pm
Currently we have SQL server 2008 standard edition, we are using SSRS and SSIS.
If we later want to upgrade the server to 2012, can we still use standard edition for the purpose of using SSRS and SSIS just like we do in SQL server 2008?
I know there is a business intelligence edition in 2012, but more expensive than standard, so I just don't want something we don't use, but to buy the edition that has equivalent function as 2008 BI features.
May 24, 2012 at 2:03 am
Use the compare editions web page to see what each edition comes with, that way you can make an informed choice on what features of SQL you want and what edition to purchase.
http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx
Yes you can still use SSIS and SSRS in Standard but there are limitations to what they can do over the BI or Enterprise edition, so just make sure you get the right version for your needs.
May 24, 2012 at 3:24 am
It depends a bit on your environment.
If you want to use more memory and CPU power, you're better of with the BI edition.
For example, SSAS can use up to 64GB RAM maximum in standard (OK, that is quite a lot), but with BI edition you can have the OS max.
If you have small cubes, stay with standard. If you're working with terabyte cubes, I would look into BI or Enterprise edition.
If you want to use SSAS Tabular, don't go with standard (it's even not available in that edition), you'll need all the RAM you can find.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 24, 2012 at 9:16 am
Thank you, very helpful
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply