Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
4 Solutions
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
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
 
anushahannaAuthor Commented:
Thanks for your input.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now