March 16, 2009 at 9:28 am
Does anyone perhaps have links to whitepapers, presentations or articles on moving from 32 bit to 64 bit? The risks, benefits and reasons for making the move.
I have a high-level presentation to give next week on the topic, and I'm having trouble finding good material. The presentation's to CIOs and IT managers, not techies.
Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2009 at 11:43 am
Here's an old one: http://qa.sqlservercentral.com/articles/Miscellaneous/overviewof64bitsql/1166/
http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/Adv64BitEnv.doc
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 16, 2009 at 2:35 pm
Does anyone perhaps have links to whitepapers, presentations or articles on moving from 32 bit to 64 bit? The risks, benefits and reasons for making the move.
Hi Gail,
My take is there is no valid reason to run 32bits SQL Server if it is not department server because I have not used 32bits Oracle since 9i. The only time you run into issues is SSIS, SSRS and using Excel or Access. Here is a .NET related link for application level issues and SSIS support article.
So most of the problems are application related.
http://msdn.microsoft.com/en-us/library/ms241064.aspx
http://support.microsoft.com/kb/934653/
Kind regards,
Gift Peddie
March 16, 2009 at 2:39 pm
Can you explain more about the issues with SSIS and SSRS? I know of some problems with SSIS, hadn't run into any SSRS ones.
I agree with you on the 32 bit, it's the room full of CIOs and the like that I have to convince.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2009 at 2:52 pm
In SSRS if you are in Windows 2003 which comes with IIS 6 which runs in only one mode you have to run SSRS in 32bits mode if your company needs to run other application that needs 32bits mode. In SQL Server 2008 Microsoft claim to deploy in file system but most features still require running IIS so you should try to deploy in Windows 2008 which comes with IIS7 which can run in both modes.
SSIS issues relates to moving Excel files which are used by most companies here in Windows 2008 it is better to run Office 2007 because 2003 require MDAC which does not come in Windows 2008 or Vista because Microsoft have changed the data access which is also the reason for problems with Oracle. But that is a different issue.
Planning will help resolve most problems and I almost forgot registry are platform dependent so avoid development that uses registry entries.
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply