Database Reference
In-Depth Information
Possible external
memory problems.
Troubleshoot in
windows OS.
Memory counters
deviating from
baseline?
Memory: Available
MBytes low?
Yes
Yes
No
No
Possible external
virtual memory
problems.
Troubleshoot in
Windows OS.
Relax.
Paging File: % Usage peak or
Paging File: % Usage are high?
Yes
No
You have internal
memory pressure.
Identify large
consumers using
sys.dm_os_memory
_brokers.
In DBCC MEMORYSTATUS is
COMMITED above TARGET?
Yes
No
You have internal
memory pressure
other than buffer.
Identify large
consumers using
sys.dm_os_memory
_clerks.
Process: Private bytes is high?
Yes
No
Check for memory
errors in windows
log and SQL server
log.
Check for VAS
memory problems.
Figure 2-6.
Memory bottleneck resolution chart
