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!