BI and MSSQL SERVER 2008 R2 Standard

We are running MSSQL SERVER 2008 R2 Standard. BI had become a hot topic. I was doing research into BI and Standard ED of MSSQL server, and ran across some facts that the Standard ED does not handle BI all that well. In fact running it can cause performance issues with the MSSQL Server. The time frame stated was that with in a month a users will be complaining about slowness with the reports and polling data.

Does anyone know if this is true?
crawforditAsked:
Who is Participating?
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
Where did you read that?  Standard edition should perform the same as Enterprise, regardless what you're doing with it.

There are some limitations though but the biggest ones are related to supported functionality, not performance.  Have a look at the following page for a good overview: Features Supported by the Editions of SQL Server 2008 R2
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.