Database Reference
In-Depth Information
The /3GB switch should not be used for systems with more than 16GB of physical memory, as explained in the
following section, or for systems that require a higher amount of kernel memory.
SQL Server 2014 on 64-bit systems can support up to 8TB on an x64 platform. It no longer makes much sense to
put production systems, especially enterprise-level production systems, on 32-bit architecture.
Addressing Fragmentation
While fragmentation of storage may not sound like a performance issue, because of how SQL Server retrieves
information from disk and into memory, a page of information is accessed. If you have a high level of fragmentation,
that will translate itself straight to your memory management since you have to store the pages retrieved from disk
in memory as they are, empty space and all. So, while fragmentation may affect storage, it also can affect memory.
I address fragmentation in Chapter 17.
Summary
In this chapter, you were introduced to the Performance Monitor and DMOs. You explored different methods of
gathering metrics on memory and memory behavior within SQL Server. Understanding how memory behaves will
help you understand how your system is performing. You also saw a number of possible resolutions to memory issues,
other than simply buying more memory. SQL Server will make use of as much memory as you can supply it,
so manage this resource well.
In the next chapter, you will be introduced to the next system bottleneck, the disk and the disk subsystems.
 
Search WWH ::




Custom Search