CODEWITHSUNDEEP
sql-server-2008
rajibdotnet
rajibdotnet

Reputation: 1596

What is the difference between sql server 2008 64 bit and sql server 2008?

Can you please explain what does a SQL Server 64 bit version brings into the table which a regular 32-bit doesnot have? In other words, why should I invest in 64-bit?

Upvotes: 0

Views: 1631

Answers (2)

Diego
Diego

Reputation: 36146

It brings you all the advantages of a 64 bit application has over a 32 bit application. Do you know what that mean?

Mainly it starts on a hardware level by the way the CPU) handles information. For example, a 32 bit CPU can only handle 2^32 bist, which limits it to 2Gb of RAM. The 64-bit can handle 2^64, which is a very large amounts of memory. You can easily conclude that any hardware improvement will positively affect every software that runs over it and SQL Server is no exception.

Upvotes: 2

kemiller2002
kemiller2002

Reputation: 115498

SQL Server 64 bit version brings into the table which a regular 32-bit doesnot have? In other words, why should I invest in 64-bit?

It is the amount of memory that 2008 can use. In a 32-bit version it's limited to only a few gigabytes where the 64bit version can use much much more. In the 32 bit version, the server has to access the hardrive for database information much much more, the 64-bit OS and enough memory allows the server to hold much more of the database in memory, making the queries faster.

Upvotes: 3

Related Questions