Solved

BI and MSSQL SERVER 2008 R2 Standard

Posted on 2013-06-21
1
318 Views
Last Modified: 2013-10-17
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?
0
Comment
Question by:crawfordit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39267087
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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question