64-bit vs. 32-bit Architectures - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external - OnBase/Database-Reference-Guide/Foundation-23.1/Database-Reference-Guide/Performance/Optimizing-Performance/64-bit-vs.-32-bit-Architectures - 2025-08-21

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License
ft:locale
en-US

Whenever possible, it is always recommended to utilize a 64-bit operating system for the database server. When purchasing a new version of SQL Server or Oracle, or when upgrading an existing solution, it is also recommended to utilize the 64-bit edition of the RDBMS. This is because, in a 32-bit environment, the operating system is not able to directly address memory above 4 GB. In a 64-bit environment, the operating system is able to address memory beyond 4GB.

For SQL Server on a 32-bit OS, the maximum amount of directly addressable memory is limited to 2 GB. Additional memory can be addressed using switches, but this adds overhead as the operating system has to manage access to that memory.