Solved

BI and MSSQL SERVER 2008 R2 Standard

Posted on 2013-06-21
1
312 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now