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.