SQL Server Performance Forum – Threads Archive
Dynamically Configure SQL Memory
I have some clients whit differents SQLs (7-2000) and they run other application no SQL. I configured Dynamically SQL Memory but with a minimun non cero.After reboot by any cause, memory begans in cero instead minimun value.
I suppose that minimun value means: After a while, SQL take all memory needs but no less than minimun. That’s ok? Another information confuse me: Performance show SQL Total Server Memory, suppose 1Gby stable, but task manager show Sqlserver Total Memory less than 1Gby, about 256Mby and grow but never show similar values. Why? Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
Always go with PERFMON/SYSMON results and if the Total Server Memory counter is stable with no unusual results then I reckon no issue, its working normal. As you’d configured SQL memory to dynamic it will be taken care by system. May check if other applications running parallely during that off-performance period. I don’t say Task Manager is absurd, but its just a handy tool to get instant information, for detailed go with PERFMON. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thanks, Satya I allways use perform/sysmon, but I ask just in case. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
By chance if the doubt raises with TM then use PERFMON for optimum results. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
To answer to your initial question, I think SQL Server waits until it gets the memory needed and stays at the level where minimum memory is configured. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
That would be in case if you specify min & max values and in the dynamic I think it differs. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I monitoring just after reboot, (I do not turn off the monitor in my notebook) and Target is inmediatly go to maximun but Total is growing byte by byte. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
BTW I copy the following from:http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1747
because I supose original problem is done and may be my last post was no reading.
Please remove the original. I find, in one customer, the following situation. Virtual Memory on 1 physical drive RAID 5: 1Gbyte.
I monitor Paging file: %Use, and show about 95%, constant.
Next I made another page file in 2 Physical Drive, RAID 10, 1Gbyte more. Monitor show: %use in Drive 1: 95%, in Drive 2: 2%. Next I reduce virtual memory on drive 1, from 1Gbyte to 2Mby, minimum posible. (I supose more perfomance on RAID 10 than RAID 5)
So configuration was: 2Mb in Drive 1 and 1Gbyte in Drive 2. Monitor Show: %use in Drive 1: 90% in Drive 2: 2%
So I don’t understand nothing. (Of course reboot each time, etc)
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
]]>