Memory consumed by SQL Server 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Memory consumed by SQL Server 2000

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2008-09-25 : 13:14:31

Hi All

What is the best way to find out the memory consumtion by sql server.

The server has 2GB of RAM. Please suggest me which is the correct way to know the memory being used by SQL Server?

The following are the statistics I collected.

In Task Manager - 1.72 GB (SQLSRVR.exe)

Perfmonitor
------------
Target server memory (KB) = 1675256
Total Server Memory (KB) = 1675256

DBCC MEMORYSTATUS
-----------------
Stolen 8816
Free 90
Procedures 139906
Inram 0
Dirty 1226
Kept 0
I/O 0
Latched 174
Other 57732

Commited 207944
Target 207944
Hashed 59132
InternalReservation 362
ExternalReservation 0
Min Free 64
Visible 207944

TotalProcs 39275
TotalPages 139906
InUsePages 68496

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-25 : 13:28:43

Task Manager is fine plus Total Server Memory (KB) in PerfMon.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources