Taking Advantage of 64-Bit SQL Server
In this chapter you have learned about the limitations of the 32-bit architecture. These drawbacks limit both virtual memory and physical memory. Both of these limits have been known to cause problems with SQL Server users. The virtual memory limitation can restrict the number of connections into SQL Server because of running out of virtual memory. The physical memory limitation can restrict the amount of SQL Server buffer cache and procedure cache. For large databases you might require large amounts of SQL Server cache in order to perform optimally.
Real World: Size Matters
The amount of SQL Server memory that ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
