Answer the question
In order to leave comments, you need to log in
Why is SQL Server 2008 actively using the swap file?
Good afternoon Colleagues!
Tell me, please, I'm suffering with such a machine:
Win2008 ent x86 64 giga RAM. It has SQL Server 2008 installed with a bunch of databases from 1 to 11 gigs.
The RAM limit in SQL Server is set to 45 gigs.
I observe just such a picture:
It seems that somehow everything is displayed incorrectly. In the list of processes, there is no process with a size of 20 gigs, (sqlservr.exe ~ 300mb) Swap is already 20 gigs ... The RAM is also 20 gigs less.
This is the first time I've come across such strangeness... It doesn't look like a memory leak either.
Advise where to dig!
UPD: Situation after 10 hours.
UPD2: Process Explorer
Answer the question
In order to leave comments, you need to log in
sql server commits its pages in memory and they shouldn't go into swap.
About memory, you need to look in the server configuration, there is not only the maximum, but also the minimum value for the memory used.
Task manager is not used to monitor sql server, use at least Resource Monitor.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question