?
Solved

WOW 2005 Vs 64on64

Posted on 2010-01-09
6
Medium Priority
?
208 Views
Last Modified: 2012-05-08
In SQL Server 2005, what is the benefit of having a WOW version (32SQL on 64OS) over a 64on64 Setup? or Vice versa..

Both can access more physical memory. So, apart from that, what other constraints or points should be thought of, to determine which bit version of SQL should be considered and used? I assume WOW is going to be cheaper than the 64on64 option.

thanks
0
Comment
Question by:anushahanna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26276935
As I mentioned in the other question, WOW is a feature supported by OS..
It helps you to run 32 bit applications in a 64 bit environment thus providing the additional option to run both 32 and 64 bit applications..
Without WOW, you wont be able to run 32 bit applications in a 64 bit machine..

In 64 bit machines, its recommended to go for 64 bit applications for better performance and memory resource usage and if its not available, then you can go for 32 bit applications..

Hope this clarifies.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 26278665
Jegan, you mention the benefit of WOW over 32on64 (for SQL install) is better perf and mem usage. My question is 32 bit also can use the better memory usage feature of 64bit OS. So how does the mem features of 64 bit SQL different.and compliment the 64 bit OS?

so, can you please explain what aspects of performance are increased by 64 bit SQL compared to a 32 bit SQL?

thanks
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 26280101
>> My question is 32 bit also can use the better memory usage feature of 64bit OS.

Not exactly. 32 bit applications can understand or utilize the resources internally using 32 bits only..
They wont use 64 bits for their operations and hence the performance increases while it runs under 64 bits or 64 on 64..

>> can you please explain what aspects of performance are increased by 64 bit SQL compared to a 32 bit SQL?

http://www.teratrax.com/articles/sql_server_64_bit.html

And hope this comment clarifies you further..

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_25042490.html#a26280092
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Author Comment

by:anushahanna
ID: 26282976
Thanks.
So if we have WOW64,
*we still need to enable AWE to use more than 4GB of physical memory
*Only the buffer pool can access the extra memory on WOW64, and query plans caching will happen only in the first 4 GB,
right?
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 2000 total points
ID: 26283131
>> *we still need to enable AWE to use more than 4GB of physical memory

Not required as the OS tells SQL Server the actual memory available in the server.
32 bit OS will not be able to recognize memory more than 4 GB in a machine whereas 64 bit OS recognizes it and tells the application that it is available..

But its recommended to enable AWE for a longer run as per some articles and testings..

*Only the buffer pool can access the extra memory on WOW64, and query plans caching will happen only in the first 4 GB, right?

As explained above, it would be able to utilize more than 4 GB till available memory..
Hope this clarifies..
0
 
LVL 6

Author Comment

by:anushahanna
ID: 26350068
Thanks for clarification.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question