How best to profile memory usage over time for SQL server instance memory allocation?

Jody Davis
Jody Davis used Ask the Experts™
on
I have SQL 2008 and SQL 2012 on Server 2008/2012 VMs. I'm a relative SQL novice. I'm looking to profile memory usage over time per instance to better apply memory to my VMs. I'm thinking weeks at a time would be optimum, but i'll take what i can get. I'd prefer built-in tools - but i'm NOT looking for Activity Monitor/what usage i have at a particular moment - i want to profile over time so i can better apply mem needed, and not overuse my memory allocation.

Don't wanna buy anything, prefer built-in and open to freeware, but prefer built-in. Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
I would suggest you to start looking at Perfmon counters to track the Memory usage of your SQL Server.
More info below:
https://blogs.msdn.microsoft.com/teekamg/2007/11/06/sql-server-memory-related-performance-counters/

To answer your question, you can monitor Memory Object: Available Bytes to meet your requirement..
Jody DavisSystems Engineer

Author

Commented:
Thanks, that's a great start. Could i bother you for a site that would walk me through the creation of the profiling?
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Sure, this would be a good start..
https://onlinehelp.tableau.com/current/server/en-us/perf_collect_perfmon.htm
Instead of the perfmon counters mentioned in this link, just use the Memory Object: Available Bytes: under SQL Server to capture the Available Memory, save it to the collector set as mentioned and then do your analysis..
Jody DavisSystems Engineer

Author

Commented:
Very helpful.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Thanks, glad to assist..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial