?
Solved

SQL standard and enterprise edition

Posted on 2012-03-15
8
Medium Priority
?
291 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 1500 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

777 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