| Author |
Topic |
|
pvandermn
Starting Member
8 Posts |
 Posted - 2008-07-10 : 16:04:56
|
| We are migrating our environment, currently running 32 bit development and production servers. I plan to upgrade to 64 bit SQL production and am wondering two things...1. Can I keep my development server as is for now and run the database with 80 compatibility in SQL 2005? Do I forgo performance in SQL 2005 if I leave it at 80?2. If I upgrade my development server to 2005, can I mix 64 bit on the Prod server and 32 bit on the Dev server? In other words, is the database itself different in 64 bit?3. I have a third failover server that I hoped to use an older server for, which has a 32 bit CPU. Can I do engage the failover function between the new 64 bit SQL 2005 server to a 32 bit SQL 2005 server? Thank you. |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-07-10 : 16:20:40
|
| In regards to question #1 - yes you a can run your database in 80 on 2005. I would recommend changing that to 90 after you review and change any functionality coded against 80 that will not work in 90.In regards to question #2 - unlike Oracle, you can mix and match different editions of servers to an extent. As far as deploying functions, tables, views, etc... it's all the same. I am not sure about backups and restores so someone else can chime in here.In regards to question #3 - I think both of your servers need to be the same architecture in a cluster environment. |
 |
|
|
pvandermn
Starting Member
8 Posts |
Posted - 2008-07-10 : 16:36:27
|
| Thank you, tfountain. In q#1, will I take a performance hit by leaving them as compatibility 80? |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-07-10 : 16:42:19
|
quote:
Originally posted by pvandermn
Thank you, tfountain. In q#1, will I take a performance hit by leaving them as compatibility 80?
I have seen some cases where there wasnt much difference.. I have also seen scenarios where they had to immediately change the mode to 90 within a week of upgrade to 2005..so you need to test your app before you do to the upgrade..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-07-10 : 16:44:38
|
| Also for question 3, if you are doing mirroring for failver you can do 32/64 mix.. for clustering as rfountain mentioned they need to be of same build..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-07-10 : 16:46:18
|
| I'm not really sure if you will take a performance hit (at least a noticable one) but that will also depend on what feature you are using I would assume. If you do, it most likely won't be any less than what you are getting now that's for sure.The biggest concern I would be worried about is being able to not utilize some new features that must run in compat mode 90.If it's any help, when we first migrated to 2005, we stayed in compat mode 80 for some time until all the features being used in our system where updated/replaced. Personally, I did not notice a difference in performance when we switched to 90. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-07-10 : 16:51:42
|
| Also, for more detailed differences you can check out this link - http://msdn.microsoft.com/en-us/library/ms178653.aspx. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-10 : 17:00:15
|
| Of course , there is difference in performance in 32-bit an 64-bit. Company change from 32-bit to 64-bit as it can utilize maximum operating system memory. Also it better to have same architecture if you do database mirroing so your mirror can handle same load easily. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-11 : 23:47:01
|
| >> I am not sure about backups and restores so someone else can chime in here.They are same in 32 or 64-bit, you can backup from 32-bit then restore on 64-bit and vase versa. |
|
|
|
|
64 bit and 32 bit, 80 and 90 compatibility