.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

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

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

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

View Complete Post

More Related Resource Links

Upgrade SQL Server 2005 Express 32-bit SP1 to SQL Server 2008 Standard on a 64-bit Server for use wi


When installing & configuring MOSS 2007 the default settings were choosen. So now when we try to access the SSMS I get a message "The evaluation period has expired. Please buy the product at the following url.". I do have a product key for SQL Server 2008 standard but when I am trying to perform a edition upgrade it doesn't detect the SQL Server Instance "OFFICESERVERS" so I am unable to upgrade the server. Because of the limitation in size we are unable to create new doc libraries or pages on the SP site.

Here are the details of the environment:

OS : Windows Server 2008 Standard SP1 64-bit

MOSS 2007 version :, Current License : Office SharePoint Server with Enterprise Client Access License

Database : SQL Server 2005 Express SP1 32-bit

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?

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  

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

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 ?

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

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

MS SQL Server 2005 Standard or Enterprise with default encryption

Hi, I wish to know whether or not by default MS SQL Server 2005 Std or Ent edition will encrypt the communication over the network by default? As, when we test out the database activity monitoring solution to capture the SQL traffics from the network, we are unable to see the DB user name and Source Program but SQL statements is able to seen. According to the vendor, it is due to the nature of MS SQL Server 2005 that encrypt the communication by default. But, why is it only encrypted the DB user name and Source Program but not the SQL statement? Can someone provide me the answer? Is that true what the vendor claims?   regards, Teh

SQL Server 2005 standard Edition to SQL Server 2005 enterprise edition



My current version of SQL server is Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to upgrade this to Enterprise edition. I would like to know the below information please

  • step by step instructions on how to perform this upgrade
  • I have databases & replications setup on this server. Will the upgrade have any adverse effects on the current replication setup?

Any help and guidance is truly appericiated. Thanks.

Can I install SQL 2008 on a server running SQL 2005 to install Sharepoint 2010 Enterprise (Productio



Sharepoint 2010 Upgrade Question - A customer is currently running sharepoint 2007 on a 64bit windows 2003 OS with SQL 2005 sp2, they are looking to install/upgrade to Sharepoint 2010 and want to use the current SQL server,for the upgrade a new SharePoint 2010 environment will be built and for a short while they will have two instances of SharePoint running SP2007 and SP2010. The plan is to then manually migrate the data from SP2007 to SP2010 (ENT), the web and application servers will be newly built. From research I think they have three options

1) Upgrade the current SQL 2005(SP2) instance to SQL 2008 R2 standard.

2) Install a new instance of SQL 2008 R2 on the same server and have both SQL 2005 & SQL 2008 running on the same server (Is this an option? Will sharepoint happily run from a SQL server running two SQL instances, do I have to be careful regarding the installation and configuration, could I break the existing sharepoint farm doing this?)

3) Upgrade the current SQL server to SP3 and install a new instance of SQL 2005 SP3 and install SharePoint 2010 Enterprise here, again I have all the questions from point 2 above.

We are thinking of trying option 1, then 2, then 3, and obviously only moving to the next option if we come across a show stopper. H

The Application is performaing very slow after upgrade to SQL Server 2008 x64


Hello All,

I am writing you all after I tried a lot of solutions to resolve my Issue, please find below my issue details..

Task: Upgrade from SQL Server 2000 Ent. Edition to SQL Server 2008 X64 for IA on windows server 2008 Clustered environment (Active\Active)

SQL Server 2008 Servers HW configuration:

  • 24 GB Of Ram
  • 2x Process or dual core
  • SAN storage
  • up to 1 Tera Storage

How do I upgrade and overlay SQL Server 2005 Express with SQL Server 2008 R2


We are upgrading SQL server2005 Express to SQL Server 2008 R2.  We want to replace 2005 Express with 2008 R2 on existing system.  We have lots of questions about how to perform the upgrade safely and pull in our existing databases.  The existing database files are in C:\Program Files\Microsoft SQL Server\MSSQL.1.  Also, we'll want to use the existing instance name to avoid having to reconfigure all of the installed clients at our user's workstations.

Should we uninstall the 2005 Express version first?  Will that keep the existing databases on the system?

Or can we install 2008 R2 while the databases are live under the 2005 Express, or should we shut down 2005 Express first?

Will  2008 R2 use the same data folder or create a new one?  If it uses the same folder will it automatically recognize our existing databases?  If it creates a new one, I suppose we can use the migration Wizard.


Thanks for any help....


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?

Linked server issue on test box, post upgrade 2005 to 2008 R2


In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box.  2005 instance, copied as many things as I could think of from various other instances.  Made a basic linked server to our main cluster, had a repeating job to email me results of a query across that link every few hours.


Everything was working fine until the upgrade finished.  It completed at ~7pm.  The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through.  Checked various things (DB mail was still working, tested fine).  It couldn't access the data across the linked server.  I tried deleting that link and remaking it.  Errors out.  Tried running the same scripts we use to create our standard linked servers, error out.  The only ones that I can set up and function are links to other instances on the same box.

I've looked around at other fixes for this error message and none seem to make any difference.  Log in with Domain cred's, log in with the sa account, no difference.  I can connect from other instances & servers back to this one, just not outbound from this one.  And it worked prior to the upgrade I applied to it.  All other instances on the box are 2005 as well.

Here is the message I ge


Hi. I just upgraded my server from SQL Server 2005 Standard edition to SQL Server 2005 Enterprise edition (http://benchmarkitconsulting.com/colin-stasiuk/2009/06/03/sql-server-2005-edition-upgrade/). Then applied the service pack again. After the computer restart, when i opened the replication monitor to check then effect this upgrade had on my replications, i got below error when i open the Subscription Detail window. any suggeestions/workaround to correct this shall be very much appericiated. Thanks

TITLE: Replication Monitor

Replication Monitor could not open the Detail Window.


Specified cast is not valid. (ReplicationMonitor)



Unable to upgrade from SQL Server 2005 to SQL Server 2008 due to Reporting Server check failure

Hi all,

We were trying to upgrade our SQL Server 2005 tp SQL Server 2008, and bumped into some problem with the reporting server check.

Here were the environmental details:
- Windows Vista SP2 32-bit
- SQL Server 2005 (v 9.0.3077)
- Microsoft SQL Server 2008 Upgrade Advisor v 10.00.1600.22

While performing the Microsoft SQL Server Upgrade Advisor, it reported these problems on the Reporting Service:
PreUpgrade "The system cannot find the file specified." RSVDIRSEXIST
PreUpgrade "The system cannot find the file specified." RSIPADDRESSRESTRICTIONS
PreUpgrade "The system cannot find the file specified." RSCLIENTCERTIFICATES
PreUpgrade "The system cannot find the file specified." RSUSESIIS5
PreUpgrade "The system cannot find the file specified." RSIIS7BACKCOMPAT

SQL server 2005 to 2008 upgrade


I am running the XP operating system.  I tried to upgrade from SQL server 2005 to 2008 because I will be taking a database class at UNCC soon.  The upgrade stopped running and I could not get it to restart. Now when I reboot my computer I get an error message. The message says my SQL server 2005 installation is corrupt and has been tampered with.  I tried uninstalling it but the system will not allow me to. I can continue using the 2005 for the class so I would like to know how I can get it operational with out doing a complete system restore.


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