Solved

SQL standard and enterprise edition

Posted on 2012-03-15
8
270 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
  • 5
  • 3
8 Comments
 
LVL 69

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 69

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
 
LVL 1

Author Comment

by:marrowyung
ID: 37745642
emoreau,

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

DBA100.
0
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

 
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 69

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

746 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

12 Experts available now in Live!

Get 1:1 Help Now