Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Possible memory leak on sql 2k5 SP2
Phenno
Member Posts: 630
Hi All...
We have a customer running Navision on sql 2k5 SP2, win2k3 (x86). Latelly they reported slow Navision so I started digging and found some strange counter values that looks like memory leak...
Server has ~10GB RAM, and is set with PAE switch.
SQL Server is not with AWE at this moment only for a reason of stable system. Maximum memory set to 4GB (yes, it can use only 2GB ).
Navision DB is ~25GB large, 4.0 SP3 (originated from SP1).
When I checked performance counter i can see that:
Everything works fine until SQL Total Memory hits Target Memory (1,7GB). In that moment, Commited Bytes counter gones wild and in 20 seconds tops at 8,8GB line (thus Available Memory goes done and stops at 1,5 GB approx).
But, Private, virtual bytes do not show this increase.
Further more, I noticed nonpage pool rised in that moment, but only up to 40MB (from 37MB till that moment) and top nonpage TAG is Mmdl, part of MDL.
The similar behaviour was with AWE turned on except it than commits up to 98% free memory and hangs system totally, thus the descision to turn off AWE temporarely.
So the question is, what could be the reason for memory to eat all committed bytes in several seconds and can this be considered as memory leak?
We have a customer running Navision on sql 2k5 SP2, win2k3 (x86). Latelly they reported slow Navision so I started digging and found some strange counter values that looks like memory leak...
Server has ~10GB RAM, and is set with PAE switch.
SQL Server is not with AWE at this moment only for a reason of stable system. Maximum memory set to 4GB (yes, it can use only 2GB ).
Navision DB is ~25GB large, 4.0 SP3 (originated from SP1).
When I checked performance counter i can see that:
Everything works fine until SQL Total Memory hits Target Memory (1,7GB). In that moment, Commited Bytes counter gones wild and in 20 seconds tops at 8,8GB line (thus Available Memory goes done and stops at 1,5 GB approx).
But, Private, virtual bytes do not show this increase.
Further more, I noticed nonpage pool rised in that moment, but only up to 40MB (from 37MB till that moment) and top nonpage TAG is Mmdl, part of MDL.
The similar behaviour was with AWE turned on except it than commits up to 98% free memory and hangs system totally, thus the descision to turn off AWE temporarely.
So the question is, what could be the reason for memory to eat all committed bytes in several seconds and can this be considered as memory leak?
0
Comments
For me it showed that VMware was taking rather large part od memory from this server, showing that in commited bytes and available memory but not in any other standard memory counter, excepts mentioned VM counter.