2005 x64

Hi all,
We have a 2-node SQL2005 SP1 cluster running right now connected to an EMC
SAN. We are considering moving to the x64 edition of SQL for performance
reasons. The servers currently have 64 bit CPUs, but are running 32-bit OS
and SQL as well. Can someone share any experiences about x64 environments? I
have heard some reports from users that it is not recommended for production
environments as it is unstable.
Would I need to re-code any of my tables/stored procs/functions etc?
TIA!We've done several implementations of the x64 version in our test, QA
and production environments and haven't experienced any issues. No
recoding should be necessary unless you've incorporated 32-bit API
calls into your SPs/functions.
On Sat, 28 Oct 2006 13:34:27 -0500, <param@.community.nospam> wrote:
>Hi all,
>We have a 2-node SQL2005 SP1 cluster running right now connected to an EMC
>SAN. We are considering moving to the x64 edition of SQL for performance
>reasons. The servers currently have 64 bit CPUs, but are running 32-bit OS
>and SQL as well. Can someone share any experiences about x64 environments? I
>have heard some reports from users that it is not recommended for production
>environments as it is unstable.
>Would I need to re-code any of my tables/stored procs/functions etc?
>TIA!
>|||I am running several production database on x64, without any problems.
param@.community.nospam wrote:
> Hi all,
> We have a 2-node SQL2005 SP1 cluster running right now connected to an EMC
> SAN. We are considering moving to the x64 edition of SQL for performance
> reasons. The servers currently have 64 bit CPUs, but are running 32-bit OS
> and SQL as well. Can someone share any experiences about x64 environments? I
> have heard some reports from users that it is not recommended for production
> environments as it is unstable.
> Would I need to re-code any of my tables/stored procs/functions etc?
> TIA!
>|||Any of those databases clustered?
Did you see a performance lift by moving from x86 to x64?
Thanks
"Theo Verweij" <tverweij@.xs4all.nl> wrote in message
news:u$uG%23Tz%23GHA.3344@.TK2MSFTNGP03.phx.gbl...
>I am running several production database on x64, without any problems.
> param@.community.nospam wrote:
>> Hi all,
>> We have a 2-node SQL2005 SP1 cluster running right now connected to an
>> EMC SAN. We are considering moving to the x64 edition of SQL for
>> performance reasons. The servers currently have 64 bit CPUs, but are
>> running 32-bit OS and SQL as well. Can someone share any experiences
>> about x64 environments? I have heard some reports from users that it is
>> not recommended for production environments as it is unstable.
>> Would I need to re-code any of my tables/stored procs/functions etc?
>> TIA!|||No, no clusters,
and yes, the performance has really improved.
But, to be honest it is almost impossible to tell if this performance
improvement is due to x64.
At this moment we are running on a temporary server.
The old server was a quad 900 Mhz XEON with 2Mb Cache, 8Gb Ram
(@.100Mhz), UW Scsii 3 15k Raid 5, with Win2k Ent anb SQL2000 Ent.
Now we are (temporary) running on a dual 2.8 Ghz XEON with 2Mb Cache, 4
Gb Ram (@.400Mhz) and a Serial ATA 7.2k software mirror, with Win2k3 std
x64 and SQL 2005 Std x64.
The current temporary server outperforms the old one by a factor 2 with
a load of 50 concurrent users (with a lot of inserts and updates), but
almost everything is different between the 2 machines.
The only thing I can say for sure is that we don't have any problems
with the x64 version.
param@.community.nospam wrote:
> Any of those databases clustered?
> Did you see a performance lift by moving from x86 to x64?
> Thanks
> "Theo Verweij" <tverweij@.xs4all.nl> wrote in message
> news:u$uG%23Tz%23GHA.3344@.TK2MSFTNGP03.phx.gbl...
>> I am running several production database on x64, without any problems.
>> param@.community.nospam wrote:
>> Hi all,
>> We have a 2-node SQL2005 SP1 cluster running right now connected to an
>> EMC SAN. We are considering moving to the x64 edition of SQL for
>> performance reasons. The servers currently have 64 bit CPUs, but are
>> running 32-bit OS and SQL as well. Can someone share any experiences
>> about x64 environments? I have heard some reports from users that it is
>> not recommended for production environments as it is unstable.
>> Would I need to re-code any of my tables/stored procs/functions etc?
>> TIA!
>|||Without detailed info, whether or not the others have experienced performance
improvement with x64 probably won't mean a whole a lot to your particular app
since the results are highly workload dependent. If you are considering going
to x64 from x86, I suggest you treat it like any other production
change--test it first in your own environment with your own app before you
make the switch.
Linchi
"param@.community.nospam" wrote:
> Any of those databases clustered?
> Did you see a performance lift by moving from x86 to x64?
> Thanks
> "Theo Verweij" <tverweij@.xs4all.nl> wrote in message
> news:u$uG%23Tz%23GHA.3344@.TK2MSFTNGP03.phx.gbl...
> >I am running several production database on x64, without any problems.
> >
> > param@.community.nospam wrote:
> >> Hi all,
> >>
> >> We have a 2-node SQL2005 SP1 cluster running right now connected to an
> >> EMC SAN. We are considering moving to the x64 edition of SQL for
> >> performance reasons. The servers currently have 64 bit CPUs, but are
> >> running 32-bit OS and SQL as well. Can someone share any experiences
> >> about x64 environments? I have heard some reports from users that it is
> >> not recommended for production environments as it is unstable.
> >>
> >> Would I need to re-code any of my tables/stored procs/functions etc?
> >>
> >> TIA!
> >>
>|||Hi,
My understanding of your issue is that:
You prepared to migrate your SQL Server 2000 cluster to your SQL Server
2005 64 bit cluster and you wanted to know if there is some risk and if it
can lift the performance.
If I have misunderstood, please let me know.
Using 64 bit platform does not mean that the performance can be promoted
evidently, however it leaves a vast space for hardware upgrading. It can
provide higher hardware performance than 32 bit platform potentially, such
as memory capacity.
You can migrate your SQL Server 2000 32 bit cluster to your SQL Server 2005
64 bit cluster and you can take the following steps for the migration:
1. Backup all the databases on the current SQL Server 2000 cluster;
2. Export jobs script to a file;
3. Export users and logins script to a file:
4. Restore databases on the SQL Server 2005 cluster;
5. Create jobs by running the exported jobs script file;
6. Create users and passwords by running the exported script file.
Please refer to:
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133/en-us
It is recommended that you perform a test before bring it to your
production environment.
If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================