SQL standard and enterprise edition

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.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
are your transactions simple inserts or more complex operations using SP, triggers, large indexes, suspect clustered index, ... ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

marrowyungSenior Technical architecture (Data)Author Commented:
emoreau,

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

DBA100.
0
marrowyungSenior Technical architecture (Data)Author Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
>>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
marrowyungSenior Technical architecture (Data)Author Commented:
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
marrowyungSenior Technical architecture (Data)Author Commented:
This can't answer my need but thanks for given me this information.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.