I have specified a value for the server property max memory. What system view will show me what part of that value is being used? There are several system views dealing with memory but none of the column definitions relate to the max memory server property.
Several sys views show how much physical memory is installed on the machine. Some show available memory without a clear definition if it refers to SQL Server memory or Windows memory. Is there a system view that will allow me to figure out how much if any memory is free? Not sure what the difference between "freee" and "available" is as it appears in task manager. What is the difference?
I want to write queries so that I can be assured my max memory property never starves the OS and yet is as large as it can be and monitor my setting auto magically.
Thanks
Tom G.
No comments:
Post a Comment