August 7, 2003 at 8:46 am
I have 2G physical memory, 1G assigned to SQL, it appears 100% mem usage from Task Manager for sqlserv.exe, 80% mes usage from NetIQ. How to calculate it using SQL tool?
August 7, 2003 at 9:02 am
sysperfinfo gives you the memory used by SQL Server.
There is an utility pslist.exe which shows exactly same as task manager. You can run it within QA with xp_cmdshell to get result into a table.
August 7, 2003 at 10:17 am
is the total of cntr_value suppose to be a memory usage of SQL server ? what's unit, byte or k?
August 7, 2003 at 10:45 am
Counter name is 'Total Server Memeory (KB)'.
August 7, 2003 at 12:06 pm
It appears that Total Server memory(KB) is 12040, Target Server memory(KB) is 854248. What does it mean?
August 7, 2003 at 12:13 pm
Total Server Memory (KB) tells you how much the mssqlserver service is currently using. 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.
But, if Total Server Memory (KB) counter is less than the Target Server Memory (KB) counter, then this means that SQL Server does not have enough memory to run efficiently. If this is the case, you most likely need to add more RAM to your server.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply