.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server 2008 performance: Decision to spend budget to upgrade to enterprise edition

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi, Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party and we can’t change/modify database objects and they seem to be designed fine. The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition. I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations” and “Enhanced Read-ahead and Scan”: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx  How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”? Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with faster CPU and RAM? Thank you, Max

View Complete Post

More Related Resource Links

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

how many open connection is recommended to leave - in sql server 2008 Enterprise Edition

hi i have my C# program that work with sql-server 2008 Enterprise Edition i have 40 users that connect to this database. i dont close the connection. how many open connection is recommended to leave ? or is it better to close connection ? thank's in advance

Problem with upgrade from SQL 2008 Express to SQL Server 2008 Enterprise

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

How to install Sql server 2008 Enterprise edition in windows 7 (32 bit system)

am install Sql server 2008 SP1 But same Problem again Plz Give me Reply Plzzzzzzzzzz Which edition Support in windows 7?

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

SQL Server 2008 trial edition upgrade process



What is the upgrade path from the trial edition to the registered Enterprise edition?


can I just type in a number somewhere, or do I need to do a complete reinstall?


how can I find out exactly how many days left in the trial?

Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.

Upgrade SQL Server 2008 Standard Edition to 2008 R2

I'm trying to find the right down load to use to upgrade SQL Server 2008 Standard Edition to Standard Edition R2.  This is the first upgrade I've done for SQL Server and I can't find any download for R2 that is specifically for Standard Edition.  Can anyone point me in the right direction please?

Unable to "upgrade" SQL 2008 Enterprise to Standard Edition - Error: the credentials you provided fo


I already tried changing the logon account for SQL services and still receive the error.

Please help.

SQL Server 2008 R2 -Windows 7 Enterprise edition



Can i install SQL Server 2008 R2 64bit enterprise edition on windows 7 enterprise edition machine??


SQL Server 2008 R2 Enterprise edition -Win 7 enterprise machine


Can i load SQL server 2008 R2 enterprise edition on Windows 7 Enterprise edition 64 bit OS machine??


Is there no way to upgrade from SQL Server 2008 Standard to SQL Server 2008 Enterprise with MSDN?

There are no Product Keys for MSDN copies?  I'm in the SQL Upgrade wizard and it needs a Product Key to upgrade?

Problem while installing SQL Server 2008 Enterprise Edition on Window server 2003 x64 OS


I am trying to install SQL Server 2008 Enterprise Edition on Windows Server 2003 x64 OS.

I have followed below steps:

  • Installed .NET Framwork 3.5 SP1 on the system.
  • Installed Windows Installer v4.5
  • then tried to execute the setup.exe of SQL Server 2008.

Am getting below error:

"Microsoft .NET Framework 3.5 Installation has failed."

"SQL Server 2008 requires .NET Framework to be installed."

Please suggest me on how to proceed further with this installation.





Error in installing SQL Server 2008 enterprise/Developer edition.


Hi, I am trying to install sqlserver 2008 enterprise edition.

I hv already installed vs-2010 professional.

OS-windows7 Ultimate

Throwing error like :


Please help...........


SQL Server 2003 Enterprise to SQL server 2008 developer edition


Hi Experts,

   I want to change SQL Server 2005/2008 Enterprise to SQL server 2005/2008 developer edition, without uninstall the Product.

Please Help urgent bases.






SQL Server 2008 enterprise upgrade failed: Illegal characters in path.


My production upgrade from SQL Server 2005 to 2008 just went down. This is a single x64 server installation the log reported the strange set of problems:


2011-04-13 10:14:48 AS: Result: (Utility) Success
2011-04-13 10:14:48 AS: Action: Set Admin Rights For Folder(F:\SSAS\AS_TEMP\|)
2011-04-13 10:14:48 Slp: Sco: Attempting to set directory full path
2011-04-13 10:14:48 Slp: Sco: Attempting to normalize directory path F:\SSAS\AS_TEMP\|
2011-04-13 10:14:48 Slp: Prompting user if they want to retry this action due to the following failure:
2011-04-13 10:14:48 Slp: ----------------------------------------
2011-04-13 10:14:48 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2011-04-13 10:14:48 Slp: Inner exceptions are being indented
2011-04-13 10:14:48 Slp: 
2011-04-13 10:14:48 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2011-04-13 10:14:48 Slp:   Message: 
2011-04-13 10:14:48 Slp:     Illegal characters in path.
2011-04-13 10:14:48 Slp:   Data: 
2011-04-13 10:14:48 Slp:    DisableRetry = true
2011-04-13 10:14:48 Slp:   Inner exc

sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend