A
A
Andrey2016-10-16 00:56:56
System administration
Andrey, 2016-10-16 00:56:56

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:
39f0905047d04ca19e0ac439b831489e.png
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.
e81d9b50a49041c2b4c532369f776d41.png9d77e6a52a594d7f90fd85c75dedcfb9.png
UPD2: Process Explorer
650750a1ca9e4389ab8511ee0c56ba97.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
E
Edward, 2016-10-17
@edb

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 question

Ask a Question

731 491 924 answers to any question