Solved

SQL standard and enterprise edition

Posted on 2012-03-15
8
284 Views
Last Modified: 2012-03-28
Dear SQL expertist,

Right now we are considering the different in throughput in SQL 2008 standard and enterprise edition.

Any case present the different between 2 x edition?

DBA100.
0
Comment
Question by:marrowyung
[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
  • 5
  • 3
8 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 37724330
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37728305
I got this already:

http://msdn.microsoft.com/en-us/library/cc645993.aspx

This one is from MS web site and I knew that :

http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=0CDsQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F2%2FD%2FF%2F2DF66C0C-FFF2-4F2E-B739-BF4581CEE533%2FSQLServer2008EnterpriseandStandardFeature%2520Compare.pdf&ei=NtZhT-SPAYG1gwe20Oj8Ag&usg=AFQjCNEKWvM9ENvIXf9_cahdywmOgv11HA&sig2=UnFgc9F2N3Q9-q_P7TSIsQ

But what is Enhanced read-ahead scan? larger buffers when reading from physical disk and the select performance will be better?

The reason I ask this is, our application suppose to process 7500 transcations/15 minutes and we are using standard edition on Windows 2008 R2 Cluster, we don't know why we can't archieve that small amount of transcation only !!

So I expect something wrong on the edition of SQL server we are using.

DBA100.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 37728855
are your transactions simple inserts or more complex operations using SP, triggers, large indexes, suspect clustered index, ... ?
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 1

Author Comment

by:marrowyung
ID: 37745642
emoreau,

Basically more select (clustered index seek for example), and less join (CPU intensive)

DBA100.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37745654
BTW,

if we don't know and probably POC is a way to test it and see if it really is the version of SQL server affect it, any way to install SQL 2008 Enterprise edition on the same server as the standard edition? of course I will turn off the standard edition edition instance.

Can we just install the enterpirse edition on top of the existing SQL standard 2008, Windows 2008 R2 cluster and uninstall it once it is tested ?

DBA100.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 37746454
>>Can we just install the enterpirse edition on top of the existing SQL standard 2008, Windows 2008 R2 cluster and uninstall it once it is tested ?

I never tried that. I would rely on a VM to test a different edition of a product.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37762445
emoreau,

We can't do this and the result from the UPDATED BOX can't run the load test !

we only have few choice:

1) Upgrade to enterprise edition and see if it can handle larger transaction.
2) Change hardware and see why transcation can't increase any more.
0
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 37776084
This can't answer my need but thanks for given me this information.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

734 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