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.

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.