Windows tools
Memory - Use Perfmon to determine memory usage and to determine if
expansion is needed. If additional memory is used as AWE memory, verify in the SQL Server
error log that the statement "Address Windowing Extensions enabled" exists.
Note: This topic applies only to on-premises
environments.