marrowyung
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
are your transactions simple inserts or more complex operations using SP, triggers, large indexes, suspect clustered index, ... ?
ASKER
emoreau,
Basically more select (clustered index seek for example), and less join (CPU intensive)
DBA100.
Basically more select (clustered index seek for example), and less join (CPU intensive)
DBA100.
ASKER
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.
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.
>>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.
I never tried that. I would rely on a VM to test a different edition of a product.
ASKER
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.
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.
ASKER
This can't answer my need but thanks for given me this information.
ASKER
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.