May 30, 2008 at 4:01 am
Hi,
I've SQL Server 2005 Dev Edition and Windows Server 2003 ENT SP2.
in the task manager i see that the server use 3.5GB out of 6GB,but when i arrange the process to see whom takes all the memory i see that the sqlservr.exe takes 120MB(he is the biggest).
do i've memory leak or my task manager is counterfeit?
THX
May 30, 2008 at 2:01 pm
If I understand you correctly, what you're seeing is just the memory use of the SQL Server service (120 Meg), vs the total amount taken by the server (3.5 Gig). The bigger number can include memory that SQL Server has been told to hold on to, regardless of whether it's using it or not.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2008 at 12:37 am
Hi,
the max/min server memory on the SQL was not set(is the default).
the AWE is not set beacuse this is DEV edtion in 64BIT system.
all my SQL servers that i'm responsible of how accurate MEM use in the task manager(for example 2.5G mem,1.5G mem and so forth).
THX
June 2, 2008 at 12:55 pm
If you didn't know that an awe enabled sql server doesn't show memory in task manager you'd fail a job interview as a DBA Use master..sysperfinfo, or sys.dm_db_performance_counters to see actual memory being used.
You can also see other memory use in other dmvs. I have some rdl's you can download which will show how buffer and precedure cache memory is used ( needs sp2 )
http://www.grumpyolddba.co.uk/monitoring/Creating%20Custom%20Reports%20for%20the%20DBA.htm
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply