SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Sql server upgrade fro m2003 to 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

poratips
Posting Yak Master

104 Posts

Posted - 07/10/2013 :  08:13:29  Show Profile  Reply with Quote
Hi,
We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to be prepared and how to do as I will doing very first time.

Hello,
We have sql 2003 - on windows 2003 server with 4 CPU and 4 GB Memory.
We have almost 12 Databases and biggest DB is around 250 GB which is also feed by Replication DB as subscriber and Publisher resides on 3rd party.

1) What should be the new hardware and server we should configure?
2) What other things we need to consider?
3) What's the proper steps to migrate/upgrade DB?

Thanks,

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 07/10/2013 :  09:05:49  Show Profile  Reply with Quote
quote:
Originally posted by poratips

Hi,
We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to be prepared and how to do as I will doing very first time.

Hello,
We have sql 2003 - on windows 2003 server with 4 CPU and 4 GB Memory.
We have almost 12 Databases and biggest DB is around 250 GB which is also feed by Replication DB as subscriber and Publisher resides on 3rd party.

1) What should be the new hardware and server we should configure?
2) What other things we need to consider?
3) What's the proper steps to migrate/upgrade DB?

Thanks,



Sounds like you are talking about upgrading from Windows Server 2003 to Windows Server 2008, because there is no version of SQL Server labelled "SQL 2003". SQL Versions are SQL 2000, SQL 2005, SQL 2008 and so on.

I can't comment much about what you need to do to upgrade the Windows Server system. But, if you are upgrading your SQL Server installation, there are lot of resources on MSDN, including an upgrade advisor which you can download here: http://www.microsoft.com/en-us/download/details.aspx?id=11455
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/11/2013 :  00:05:42  Show Profile  Reply with Quote
James,
Thanks for pointing out, I am upgrading from Sql server 2005 to sql server 2008 on windows server 2003, we also thinking to virtulization.

Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 07/11/2013 :  09:09:10  Show Profile  Reply with Quote
Checkout the URL that I posted earlier. Microsoft makes upgrading really easy and predictable with all the tools and guidance they are offering. (Well, I shouldn't say any upgrade is "easy")
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/11/2013 :  16:20:57  Show Profile  Reply with Quote
Thanks James.
I have also downloaded Sql Upgrad Advisor and run it.
I am looking more from your experience to implement and build new server hardware.

Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/15/2013 :  08:06:13  Show Profile  Reply with Quote
I appreciate if you have better tips from your experience which help me.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 07/15/2013 :  08:25:35  Show Profile  Reply with Quote
I don't have many experiences to relate, because couple of times when I have done the upgrade, they went smoothly without a hitch. In addition to going through the documentation Microsoft provides, couple of things you do want to make sure you do are:

1. Take backup of all your databases (and restore them somewhere so you know you can successfully restore) before you start the upgrade.
2. If you have any vendor databases, make sure that they have certified their products for the newer version of SQL Server.
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/15/2013 :  23:10:15  Show Profile  Reply with Quote
Thanks James, Right now we are taking back up and in process to restore to make sure it.
We are also talking with Vendor and other 3rd party software company that they e supporting newer version.

Could you please let me know that Server virtualization is good or stand alone server hardware is good?
and also 8 core/CPU is enough?


Thanks and appreciate your response!
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/17/2013 :  17:36:19  Show Profile  Reply with Quote
Please let m know as we are planning to upgrade sql 2008 and need to decide which one is optimum and how many processor will be enough?

Thanks.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/17/2013 :  20:00:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
We can't answer how many processors you'll need. Every environment has its own needs.

Virtualization is okay in lots of cases. Standalone server or clusters are good in other cases.

You really need to tell us more about the application and database for us to help. The vendor/3rd party software company should be able to help you with some of this as they should have minimum hardware specs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/18/2013 :  14:09:04  Show Profile  Reply with Quote
Thanks Tara.
We have almost 15 DB, one of the replication DB is big - 280 GB, others are small ranging from 10 to 25 GB, currently we ae running sql 2005 standard edition on windows 2003, 4 CPU, 4 GB Memory (too low).
We are thinking to upgrade sql 2008R2 - enterprise edition but still not sure what should be the ideal CPU - processor, MEM configuration and Virtualization v/s physical server option will be benefitial?

Thanks for your feedback?

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/18/2013 :  15:12:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
Do you currently have a hardware bottleneck that you've seen in PerfMon?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 07/19/2013 :  08:21:04  Show Profile  Reply with Quote
Not much, sometimes I see Parallelism and memory issue but not that big as I am confused exactly what I should for bottleneck. Buffer Cache Hit Ratio is 99% all the time, CPU mostly under 70%.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/19/2013 :  13:19:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
How about Page Life Expectancy throughout the day? How about Average Reads and writes per second for logical disks? What is the average CPU throughout the day? I'd be concerned about 70% unless that's just peaks.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000