June 9, 2003 at 9:52 am
Does anyone know how to find just how much total memory SQL Server 2000 is using through a transact-SQL statement(s)?
Thanks,
Jeff
"Keep Your Stick On the Ice" ..Red Green
June 9, 2003 at 10:05 am
select counter_name, cntr_value from sysperfinfo where counter_name like 'Total Server Memory%'
June 9, 2003 at 1:07 pm
Use system proc xp_msver
Exec Master..xp_msver
MW
MW
June 9, 2003 at 1:31 pm
would that query with 'maximum workspace memory' be the memory in use.
quote:
select counter_name, cntr_value from sysperfinfo where counter_name like 'Total Server Memory%'
June 9, 2003 at 1:37 pm
According to perfmon definition, 'maximum workspace memory' is the total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.
June 9, 2003 at 2:44 pm
his question appeared to read how much server memory is in use, not available.
quote:
According to perfmon definition, 'maximum workspace memory' is the total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.
June 9, 2003 at 8:09 pm
Danschl
Please double check the definition of 'Total server memory' from performance monitor. You also can refer to following tips.
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
Quote
"Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how much the mssqlserver service is currently using. The second counter, SQLServer:Memory Manager: Target Server Memory (KB), tells you how much memory SQL Server would like to have in order to operate efficiently. If your SQL Server has enough memory, then these two counters will be identical."
June 13, 2003 at 9:48 am
Try
DBCC memorystatus
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply