Can a 32bit installation of SQL 2005 be upgraded to 64bit installation. OS is already installed for 64bit support, but he wrong version of SQL was installed
SQL 2005 64bit
Hot Topic
- How to mimic replmerg.exe in vb.net
- Can't connect w/Visual Studio 2005
- Can multiple Reporting Services use one SQL Server?
- RS on the Internet - security issues
- Urgent, help with Authentication
- Foreach File Enumerator -
- profiler can't save trace to file
- Copy Database with Microsoft.SqlServer.Management.Smo.Transfer breaks identity columns
- need sample code in vb.net
- Dynamic Filter Not Updating Correctly
SQL Server
- Lost tables and Stored Procedures after installing SP!
- Processing methodology
- Scheduled SQL Server Agent SSIS Package Job Problem
- Unable to install SQL Server 2005 September CTP
- both .net transaction and stored procedure transaction together
- [OLE DB] how to use CCommand::Excute()...
- average of selected members?
- Configuration failing: The path is not of a legal form.
- How to generate a report containing multiple single page reports
- how can I add a unique key column to a table and generate its values automatically?
SQL 2005 64bit
MikeB.
We did a detach of a 2000 32 bit database and attached it to a 64 bit 2005 server. I rebuild the indexes and recompiled all procs, but am still have performance issues. Could the 32bit to 64bit be the problem
James Donnelly
It *could* be that your app performs better on SQL2000 than SQL2005. Also I suppose possible but even less likely is that it performs better on the old 32 bit hardware than the new 64 bit hardware. But the upgrade process itself won't have anything to do with your performance. Does that make sense
In any case, your next obvious step is to dig into performance on the new system. Do you have memory or disk bottlenecks Check your query plans to see if indexes aren't being chosen where they should be. There are a bunch of things along these lines to help you track down the problem. Good luck...
MamaKike
Moving the thread to Setup & Upgrade forum.
I don't believe you can upgrade from 32bit SQL 2005 to 64bit SQL 2005.
Nick Asseloos
Hugh is correct. You cannot upgrade 32-bit SQL Server 2005 to 64-bit. You can detach the databases and perform the uninstall of 32-bit. After installing the 64-bit, you can then attach the databases.
Thanks,
Samuel Lester (MSFT)