it says 'total amount of dynamic memory the server is willing to consume' -
if this is a lot higher that the working set for sql server then its worth
buying some more memory right ? Based on a dedicated SQL Server box.
Env: SQLServer2000 sp1 (windows advanced server
Server has 4 Gb Ram. SQL is taking 2,658MB . In the
performance monitor i saw total server memory and Target
server memory are same.And in my sqlprofiler trace i saw
an entry stating that some events are captured because of
server memory. Is it a memory problem?
procedure cache is taking 502 mb
lock memory 728 mb
used data cache 1771.6 mb
free data cache is 82.2 mb
connection memeory 72.2 mb
75% of the memeory is taken by data cache.
Do i have to manually configure memory because of Total
server memory reched up to target server memory?
6. ODBC API