Aside from features favor partioning, indexed views and also parallel indexing, are tright here any type of actual performance differences in between the Standard and also Enterprise editions of SQL Server 2008?

Also, is the limitation of 4 CPUs relate to 4 cores or 4 physical CPUs?

In our environment we organize a number of databases (exact same schema, different sizes) varying as much as 100GB. We organize between 50 to 100 instances on a fail-over cluster.

Our style uses NHibernate in between our application and the database.

You are watching: Sql server 2008 r2 standard vs enterprise

I incredibly much doubt any kind of single database will flourish even more than 1000GB for the next few years.

The factor I ask is we around to range out to a 2nd cluster and I desire to recognize whether it is worth the additional money for Enterpincrease (it is around 5 times more expensive). We currently are able to execute all of the maintenance we must on the previous version.

The just function I can view that could be helpful is the Resource Governor to ensure some queries do not take as well a lot reresource.

sql-server-2008 performance
Improve this question
edited Aug 27 "11 at 23:49

98.9k99 gold badges104104 silver badges235235 bronze badges
Add a comment |
In addition to the added CPU / Memory support, tright here are a number of features that would boost performance on SQL Enterprise:

1) "Shared" table scans (if one connection is doing a table sdeserve to, and also then a 2nd table scan comes in for that table, the second one deserve to use the results of what the first one is reading, and also then just re-read the components that were missed)

2) Considering indexed views to fulfill various other queries

3) Lock pages in memory: note this is supported in SQL Standard x64 2008 SP1 / 2005 SP3 CU4 and also later on, but calls for a trace flag before SQL 2012

4) More prefetching/read-ahead

5) Parallel / online index operations

However, this stuff is fairly advanced; settle your queries and also your schema first.

Improve this answer
answered Nov 24 "13 at 0:56

Mark SowulMark Sowul
1,7701010 silver badges1414 bronze badges
Add a comment |
Maximum Number of Processors Supported by the Editions of SQL Server(then select the drop dvery own box to go from R2 to 2008)

SQL Server supports the stated variety of processor sockets multiplied by the number of logical CPUs in each socket. For example, the following is thought about a solitary processor for objectives of this table:

A single-core, hyper-threaded processor with 2 logical CPUs per socket.

A dual-core processor through 2 logical CPUs.

A quad-core processor with 4 logical CPUs.

SQL Server is licensed per processor socket, and also not per logical CPU basis.

Improve this answer
answered Jun 22 "11 at 18:01

5,40244 gold badges3535 silver badges5050 bronze badges
Add a comment |

Your Answer

Thanks for contributing a solution to Server Fault!

Please be sure to answer the question. Provide details and also share your research!

But avoid

Asking for help, clarification, or responding to various other answers.Making statements based on opinion; ago them up through recommendations or personal experience.

To learn more, view our tips on composing good answers.

See more: Why Did Carol Burnett Tug On Her Earlobe, Carol Burnett Ear Pull

Draft saved
Draft discarded

Sign up or log in

Sign up utilizing Google
Sign up using Facebook
Sign up using Email and Password

Post as a guest

Email Required, yet never shown

Message as a guest


Required, yet never before shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our regards to business, privacy policy and cookie policy

Not the answer you're looking for? Browse other concerns tagged sql-server-2008 performance or ask your very own question.

The Overcirculation Blog
Featured on Meta
What are the performance differences between Rhelp 0,1,5,6,10
Blackberry Enterprise Server 5.0 and also SQL server 2008
Server Performance Issue - Server 2008, SQL 2008 and Hyper-V
SQL Server EXPRESS 2008 R2 crippling performance issues
SQL Server 2008 Web VS SQL Server 2008 Enterprise
Windows Server 2008 performance tuning for SQL Server 2008 Enterpclimb OLAP?
Difference in between "SQL server 2008 standard" and "SQL server 2008 traditional for tiny business"?
Performance differences in between Windows Server Enterpclimb and Datacenter?
HDD: performance distinctions in between 7.2k SATA and also 15k SAS
Hot Netjob-related Questions even more warm questions

Inquiry feed
Subscribe to RSS
Question feed To subscribe to this RSS feed, copy and paste this URL right into your RSS reader.

Server Fault
Company kind of
Stack Exadjust Netjob-related
website design / logo © 2021 Stack Exadjust Inc; user contributions licensed under cc by-sa. rev2021.9.2.40142

Server Fault functions ideal through JavaScript permitted

Your privacy

By clicking “Accept all cookies”, you agree Stack Exadjust can keep cookies on your gadget and disclose information in accordance via our Cookie Policy.