dbTalk Databases Forums  

SQL Standard versus Enterprise

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clients SQL Standard versus Enterprise

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss SQL Standard versus Enterprise in the microsoft.public.sqlserver.clients forum.



Reply
Page 2 of 3 < 1 2 3 >
 
Thread Tools Display Modes
  #11  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: SQL Standard versus Enterprise - 10-07-2008 , 08:39 AM





Most of the differences between EE and Std are less features available to
use in the first place. Some of these features will allow you to do things
faster but many of them are manageability features as well. I suggest you
look thru this link to see which features you require before you worry about
performance. Having said that performance is very much dependant on design
and application needs and it would be useless to perform a test between the
two editions unless it mimicked behavior that you will experience in real
life on your app.

http://www.microsoft.com/sqlserver/2.../editions.aspx


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Tecnica" <abola (AT) nospam (DOT) nospam> wrote

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware
configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis


Reply With Quote
  #12  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM





I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #13  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #14  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #15  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #16  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #17  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #18  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #19  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
  #20  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: SQL Standard versus Enterprise - 10-28-2008 , 02:11 PM


I think in SQL Server 2008 Standard Edition and Enterprise Edition; you do
have perforamce difference as with the functionality you have access to.

Since you will have lots of page views, you could gain advantage from
partitioned tables if your database is large. Also Enterprise edition lets
you have full Database Mirroring which can provide for HA solution.

For example:
- Partitioned Tables and Indexes
- Memmroy
- CPU
- Parallel index operations

Offical List of Feature Compare:
http://download.microsoft.com/downlo...seStandard.pdf
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tecnica" wrote:

Quote:
Hi,

Is there a way to prove, or not, that under the same hardware configuration
with the same databases SQL Server Enterprise is faster than the Standard?
What is the best and faster SQL 2008 version for serving a web site with
more than 1 milion pageviews a day?

Thanks,
Rui Reis

Reply With Quote
Reply
Page 2 of 3 < 1 2 3 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top