• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

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.
0
marrowyung
Asked:
marrowyung
  • 5
  • 3
1 Solution
 
marrowyungAuthor 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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
marrowyungAuthor Commented:
emoreau,

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

DBA100.
0
 
marrowyungAuthor 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
 
marrowyungAuthor 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
 
marrowyungAuthor Commented:
This can't answer my need but thanks for given me this information.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now