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
Share
Improve this question
Follow
edited Aug 27 "11 at 23:49
*

Chopper3Chopper3
98.9k99 gold badges104104 silver badges235235 bronze badges
Add a comment |
2
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.


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

Mark SowulMark Sowul
1,7701010 silver badges1414 bronze badges
Add a comment |
1
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.


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

jftugajftuga
5,40244 gold badges3535 silver badges5050 bronze badges
0
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
Submit

Post as a guest


Name
Email Required, yet never shown


Message as a guest


Name
Email

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
Related
30
What are the performance differences between Rhelp 0,1,5,6,10
0
Blackberry Enterprise Server 5.0 and also SQL server 2008
2
Server Performance Issue - Server 2008, SQL 2008 and Hyper-V
1
SQL Server EXPRESS 2008 R2 crippling performance issues
1
SQL Server 2008 Web VS SQL Server 2008 Enterprise
1
Windows Server 2008 performance tuning for SQL Server 2008 Enterpclimb OLAP?
4
Difference in between "SQL server 2008 standard" and "SQL server 2008 traditional for tiny business"?
0
Performance differences in between Windows Server Enterpclimb and Datacenter?
11
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.