SQL Server Memory Metrics

A very quick post for today, recently I have been working on some code to gather metrics around SQL Server memory, more specifically, how much memory is on your server, your total / target memory and PLE. (If you want to know more about total vs target see this link: https://blobeater.blog/2017/03/01/sql-server-target-vs-total-memory/)

It is currently only 300 lines or so but with 1 execution of a stored procedure you will have the following at your fingertips.


EXEC usp_GlobalMemory

memoryoutput
So for a test,  if I change the server’s max memory setting you should see updated values.

MxMem

outputMemory1

The only thing I need to change is the PLE rule for what is healthy, that might take me some time. However, if there is something you would like to see, let me know, I can then add this on too.

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