Meaning of SQL Server:Memory Manager / Target Server Memory object in Perfmon for sql7

Meaning of SQL Server:Memory Manager / Target Server Memory object in Perfmon for sql7

Post by Andy Bal » Thu, 30 Nov 2000 04:00:00



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.

Andy.

 
 
 

1. Total Server Memory = Target Server Memory

hi,

Env:  SQLServer2000 sp1 (windows advanced server
active/passive cluster)

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?

Thanks
kris

2. NewEra Spell Check

3. Total Memory & Target Memory Relationship

4. VB 3 / ODBC and SQL Anywhere 5.0.03

5. Max Server Memory and Min Server Memory

6. ODBC API

7. SQL Server seems to leak memory until complete out of memory

8. SQL 7 pulling from Progress DB?

9. SQL Server 6.5 eating up swap memory, not real memory

10. SQL Server memory in task manager...

11. Memory Leak with SQL Server DMO Job object

12. Analysis Server Error: Memory Error [Failed to reallocate Memory]

13. Missing Perfmon Counter SQL2K on W2K after memory upgrade