August 15, 2008 at 9:42 am
I've got two instances of SQL server 2000 on single computer (4 CPU, 7 Gb memory). One of the instances works on hight load but use only 100Mb as I can see in the TaskManager
Memory Settings has minimum memory 4Gb maximum 6Gb
August 15, 2008 at 10:31 am
Task manager is not necessarily accurate for SQL Server memory, especially if you have AWE enabled.
Use Perfmon and look at process(sqlservr): working set or SQL Server buffer manager:Total server memory
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2008 at 11:35 am
To GilaMonster:
Can they have much difference between the Task Manager and real usage?
Just for my curiosity. Do you mean we should not trust the data in the Task Manager?
August 15, 2008 at 11:41 am
Task manager doesn't show AWE memory. I think there's a bit more to it as well.
I personally don't trust it for SQL memory. Other stuff's ok.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 17, 2008 at 1:43 am
How can I differ two instances in the PerfMon?
August 17, 2008 at 2:57 am
The two instances should be listed separately under the Process object. Identifying which is which is a little more tricky
As well as the memory counters, add the counter "ID Process" This gives the process's ID. For the SQL instances, this value will match with the one listed in the SQL error log:
2008-08-17 10:51:16.09 Server Server process ID is 1308.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply