How to monitor Windows Server memory usage

In the last blog entry:

Configuring SQL Server memory for ConfigMgr 2012

I’ve covered how to configure SQL Server to not monopolize Server memory. Thought it would be useful to further define how to monitor the memory usage and provide a real life example.

For monitoring, here are a few options:

– System Operations Manager 2012

– Performance Monitor – either dynamic, or log activity

– Task manager

For a quick check on how well a server is managing its memory stack, I’ll usually just open Task Manager and select the Performance tab.

In the following real world example; this dedicated SQL Server had a total of 98GB of memory installed, and SQL Server had been allowed to use 96GB of memory. If you check the Physical Memory (MB) section, you can see that this server is only showing 33 MB! of Free memory. Finally, check the highlighted “Physical Memory” (bottom), showing Physical Memory: 99%. Page file is being used in this scenario.

image

Recommendation was to add additional memory, then adjust the SQL Server max memory setting.

Advertisements
This entry was posted in SQL Server, SQL Server 2012. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s