SQL 64 bit

What is the impact of moving
32bit SQL Ent Ed on 32 bit OS Ent Ed to
32bit SQL Ent Ed  on 64 bit OS?

How much more significant does it become if it is 64 SQL Ent Ed on 64 OS Ent Ed ?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
if you have 64 bit SQL Server, then all operations of SQL Server will be carried out in 64 bits thereby improving the performance aspect of it..

Other than performance, you wont gain anything in addition compared to 32 bit SQL in 64 bit OS..
0
 
Andrej PirmanCommented:
As far as I did it, the only great benefit is that you can use lots of RAM in 64-bit versions. We also had SQL application on 32-bit server, and when we moved to 64-bit with 16 GB RAM, nothing changed, no improvements in speed, no improvements to the clients.
...until our SQL programmer optimised databases, stored procedures etc, so they benefit of using almost over 12 GB of RAM constantly. Also, we needed to reconfigure client applications to use .NET connectivity, and our application became light speed fast.

So, my guess is, if you do not have a good SQL admin and programmer, which knows how to use 64-bit and RAM, then you won't benefit much by migrating to 64-bit platform. Unless your SQL is RAM hungry and you will double or triple existing RAM on 64-bit platform.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
anushahannaAuthor Commented:
Labsy, I believe it is automatic that 64 bit helped your system use up the rest of the 12 GB efficiently for SQL. Can any of the other experts confirm that please?

Aneesh,
yes i have seen that. It talks about compatability, primarily.

I was hoping to hear expert's experience in moving 32 bit SQL to 64 bit OS and if they found it satisfactory, or if they would rather recommend changing SQL itself to 64 bit also..

thanks.
0
 
kbtechnicalCommented:
I'm running 64 bit SQL 2005 enterprise edition on a 2003 64bit server with 16 gig of memory.  

One of the things to watch with SQL 64bit ent edition is that it will take all available memory.  I noticed that the server would lag and stutter during the day and people would freeze.  When i looked at memory usage it would be using 14-15 gig of memory leaving almost nothing for the system.  I locked the SQL to 12gig of memory and everything has been fine.  resolved the user locking issue.  Evidently this is an issue with the 64bit Enterprise version of sql taking all available memory.  I followed the instructions on MS's site on how to lock it to 12gig.

As far as I know the 32bit version does not have this issue.  Just something to be aware of if you move up to 64bit sql on a 64bit system

0
 
anushahannaAuthor Commented:
kbtechnical, after you put the maxmem setting, is the operation 'normal' & same as it used to be when you had 32 bit sql under 32 bit os? Is there any different, positive or negative about the change, other than the memory..
0
 
kbtechnicalCommented:
@anushahanna

I don't really have a direct comparison as the hardware and software were changed at the same time and the new server hardware was so far above the old server i really can't make a comparison between 32 and 64.
 I can tell you that limiting SQL to 12 out of 16 gig made a big difference in overall network performance.  I did not see any degradation in SQL performance, I actually saw some improvement.  Users were no longer complaining that they were getting hung up in screens when more than 10 users were in the system.  We started doing transaction logging with no performance hit.

Also, alot of little annoyances that i was dealing with every day seemed to go away.  Remote users were not getting hung, dropped or losing mapped drives and I didn't have as many hung print jobs

At one point SQL had 15.5 gig out of 16 gig of memory.

Limiting SQL really stabilized the network and let me get onto other projects.

From what I have read this is only and issue on 2005 64bit Ent SQL on 64bit OS's  

   
0
 
anushahannaAuthor Commented:
kbtechnical,
yes because you changed the hardware also, it is hard to say what helped, if at all. Did you see any difference(improvements) in counters like Page Life Expectancy or any other mem counters, after moving to 64 bit.?
0
 
kbtechnicalCommented:
@anushahanna

at the point that I was brought into the project the 64bit DB was scheduled to go live in 2 weeks and I was trying to cleanup some of the other things that were done and were not working before i got there.  I was under the gun and didn't really get the chance to do any comparisons.  sorry I can't be any more help with the counters
0
 
anushahannaAuthor Commented:
Thanks for your input.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.