Advantages of upgrading 32 bit Windows Server and SQL Server to 64 bit?
Suppose that I have a Windows Server box that operates several server applications along with an SQL Server, with a RAM usage of about 2 GB at peak times.
What would be the advantages of upgrading the Windows Server OS and SQL Server to the corresponding 64 bit versions, with the server applications remaining as 32 bit? The 64 bit versions allow access to more than 4 GB of RAM, but since 4 GB is not being fully utilized would that render the upgrade moot?
Versions: Windows Server 2008 R2, SQL Server 2008 R2 Datacenter Edition
Thanks
sql-server 64-bit 32bit-64bit 32-bit
asked 59 mins ago
SomeoneSomeone
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Suppose that I have a Windows Server box that operates several server applications along with an SQL Server, with a RAM usage of about 2 GB at peak times.
What would be the advantages of upgrading the Windows Server OS and SQL Server to the corresponding 64 bit versions, with the server applications remaining as 32 bit? The 64 bit versions allow access to more than 4 GB of RAM, but since 4 GB is not being fully utilized would that render the upgrade moot?
Versions: Windows Server 2008 R2, SQL Server 2008 R2 Datacenter Edition
Thanks
sql-server 64-bit 32bit-64bit 32-bit
asked 59 mins ago
SomeoneSomeone
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Suppose that I have a Windows Server box that operates several server applications along with an SQL Server, with a RAM usage of about 2 GB at peak times.
What would be the advantages of upgrading the Windows Server OS and SQL Server to the corresponding 64 bit versions, with the server applications remaining as 32 bit? The 64 bit versions allow access to more than 4 GB of RAM, but since 4 GB is not being fully utilized would that render the upgrade moot?
Versions: Windows Server 2008 R2, SQL Server 2008 R2 Datacenter Edition
Thanks
sql-server 64-bit 32bit-64bit 32-bit
asked 59 mins ago
SomeoneSomeone
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Suppose that I have a Windows Server box that operates several server applications along with an SQL Server, with a RAM usage of about 2 GB at peak times.
What would be the advantages of upgrading the Windows Server OS and SQL Server to the corresponding 64 bit versions, with the server applications remaining as 32 bit? The 64 bit versions allow access to more than 4 GB of RAM, but since 4 GB is not being fully utilized would that render the upgrade moot?
Versions: Windows Server 2008 R2, SQL Server 2008 R2 Datacenter Edition
Thanks
sql-server 64-bit 32bit-64bit 32-bit
sql-server 64-bit 32bit-64bit 32-bit
asked 59 mins ago
SomeoneSomeone
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 mins ago
SomeoneSomeone
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 mins ago
SomeoneSomeone
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 59 mins ago
SomeoneSomeone
61
asked 59 mins ago
SomeoneSomeone
61
61
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Someone is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Strongly related: Good reasons to keep 32-bit Microsoft Windows desktop OSes
You are using a 64 Bit OS. Server 2008 R2 was the first to only support 64 Bit CPUs.
"Newer" versions of Windows aren't even designed for 32 Bit. You maybe won't take advantage of anything, but there should neither be any disadvantages. That being said: Upgrade anyway, as Server 2008 R2 SP1 (which I hope you are using) will be EOL from 2020-01-14.
As for SQL Server 32 Bit/64 Bit: Your understanding is correct, if you won't ever need > ~3,75 GB of RAM (or >2 GB per process), you can use the 32 Bit version without problems. But for newer versions there won't be any 32 Bit version to install, as Microsoft switched to 64 Bit only.
answered 30 mins ago
LennieyLenniey
2,60421022
add a comment |
Fundamentally: Yes. Assuming you never make updates that are then 4 bit only - not sure there even IS a 32 bit SQL Server more recent than 2008.
Issues with your question: "The 64 bit versions allow access to more than 4 GB of RAM," - make that 3gb ;) not 4. 1gb is always reserved.
answered 29 mins ago
TomTomTomTom
45.7k541119
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Someone is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f949303%2fadvantages-of-upgrading-32-bit-windows-server-and-sql-server-to-64-bit%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Strongly related: Good reasons to keep 32-bit Microsoft Windows desktop OSes
You are using a 64 Bit OS. Server 2008 R2 was the first to only support 64 Bit CPUs.
"Newer" versions of Windows aren't even designed for 32 Bit. You maybe won't take advantage of anything, but there should neither be any disadvantages. That being said: Upgrade anyway, as Server 2008 R2 SP1 (which I hope you are using) will be EOL from 2020-01-14.
As for SQL Server 32 Bit/64 Bit: Your understanding is correct, if you won't ever need > ~3,75 GB of RAM (or >2 GB per process), you can use the 32 Bit version without problems. But for newer versions there won't be any 32 Bit version to install, as Microsoft switched to 64 Bit only.
answered 30 mins ago
LennieyLenniey
2,60421022
add a comment |
Strongly related: Good reasons to keep 32-bit Microsoft Windows desktop OSes
You are using a 64 Bit OS. Server 2008 R2 was the first to only support 64 Bit CPUs.
"Newer" versions of Windows aren't even designed for 32 Bit. You maybe won't take advantage of anything, but there should neither be any disadvantages. That being said: Upgrade anyway, as Server 2008 R2 SP1 (which I hope you are using) will be EOL from 2020-01-14.
As for SQL Server 32 Bit/64 Bit: Your understanding is correct, if you won't ever need > ~3,75 GB of RAM (or >2 GB per process), you can use the 32 Bit version without problems. But for newer versions there won't be any 32 Bit version to install, as Microsoft switched to 64 Bit only.
answered 30 mins ago
LennieyLenniey
2,60421022
add a comment |
Strongly related: Good reasons to keep 32-bit Microsoft Windows desktop OSes
You are using a 64 Bit OS. Server 2008 R2 was the first to only support 64 Bit CPUs.
"Newer" versions of Windows aren't even designed for 32 Bit. You maybe won't take advantage of anything, but there should neither be any disadvantages. That being said: Upgrade anyway, as Server 2008 R2 SP1 (which I hope you are using) will be EOL from 2020-01-14.
As for SQL Server 32 Bit/64 Bit: Your understanding is correct, if you won't ever need > ~3,75 GB of RAM (or >2 GB per process), you can use the 32 Bit version without problems. But for newer versions there won't be any 32 Bit version to install, as Microsoft switched to 64 Bit only.
answered 30 mins ago
LennieyLenniey
2,60421022
Strongly related: Good reasons to keep 32-bit Microsoft Windows desktop OSes
You are using a 64 Bit OS. Server 2008 R2 was the first to only support 64 Bit CPUs.
"Newer" versions of Windows aren't even designed for 32 Bit. You maybe won't take advantage of anything, but there should neither be any disadvantages. That being said: Upgrade anyway, as Server 2008 R2 SP1 (which I hope you are using) will be EOL from 2020-01-14.
As for SQL Server 32 Bit/64 Bit: Your understanding is correct, if you won't ever need > ~3,75 GB of RAM (or >2 GB per process), you can use the 32 Bit version without problems. But for newer versions there won't be any 32 Bit version to install, as Microsoft switched to 64 Bit only.
answered 30 mins ago
LennieyLenniey
2,60421022
edited 25 mins ago
answered 30 mins ago
LennieyLenniey
2,60421022
answered 30 mins ago
LennieyLenniey
2,60421022
answered 30 mins ago
LennieyLenniey
2,60421022
2,60421022
add a comment |
add a comment |
Fundamentally: Yes. Assuming you never make updates that are then 4 bit only - not sure there even IS a 32 bit SQL Server more recent than 2008.
Issues with your question: "The 64 bit versions allow access to more than 4 GB of RAM," - make that 3gb ;) not 4. 1gb is always reserved.
answered 29 mins ago
TomTomTomTom
45.7k541119
add a comment |
Fundamentally: Yes. Assuming you never make updates that are then 4 bit only - not sure there even IS a 32 bit SQL Server more recent than 2008.
Issues with your question: "The 64 bit versions allow access to more than 4 GB of RAM," - make that 3gb ;) not 4. 1gb is always reserved.
answered 29 mins ago
TomTomTomTom
45.7k541119
add a comment |
Fundamentally: Yes. Assuming you never make updates that are then 4 bit only - not sure there even IS a 32 bit SQL Server more recent than 2008.
Issues with your question: "The 64 bit versions allow access to more than 4 GB of RAM," - make that 3gb ;) not 4. 1gb is always reserved.
answered 29 mins ago
TomTomTomTom
45.7k541119
Fundamentally: Yes. Assuming you never make updates that are then 4 bit only - not sure there even IS a 32 bit SQL Server more recent than 2008.
Issues with your question: "The 64 bit versions allow access to more than 4 GB of RAM," - make that 3gb ;) not 4. 1gb is always reserved.
answered 29 mins ago
TomTomTomTom
45.7k541119
answered 29 mins ago
TomTomTomTom
45.7k541119
answered 29 mins ago
TomTomTomTom
45.7k541119
answered 29 mins ago
TomTomTomTom
45.7k541119
45.7k541119
add a comment |
add a comment |
Someone is a new contributor. Be nice, and check out our Code of Conduct.
Someone is a new contributor. Be nice, and check out our Code of Conduct.
Someone is a new contributor. Be nice, and check out our Code of Conduct.
Someone is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f949303%2fadvantages-of-upgrading-32-bit-windows-server-and-sql-server-to-64-bit%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
