February 25, 2010 at 2:50 am
Hi all,
I just have a quick question, I've been looking at my server memory, and using perf mon I can see that the total server mememory is set to 27gb (as I set it) and that the target server memory is at the same value, so this is good, SQL is addressing all the memory I want it to.
However I was wondering if anyone knows an effective means of seeing how much memory SQL is actually using at a given point, i.e is it using 20GB of the 27GB it has at this point in time? I've had a look at the dmv for memory clerks but that seems to think I'm only using about 5gb, which sounds low.
Any helo would be great thanks.
Nic
February 25, 2010 at 4:05 am
I think I've answered my own question, from all the reading I'm doing, the dmv sys.dm_os_memory_clerks does provide me with the amount of memory currently being used by the instance.
Nic
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply