Win2008R2 exaggeratedly slow with 256GB RAM and strange behaviours in PVE

[macday]

thx cesar...couldn't you do it with the args: -cpu,.... option in the quemu file ?

 

[cesarpk]

thx cesar...couldn't you do it with the args: -cpu,.... option in the quemu file ?

I guess that these directives are not for include them as arguments.

A question: What kind of data base are you using?

 

[macday]

I´m not using any DB. I just have some time probs and think this would be the cure.

 

[cesarpk]

Cesar,

When windows starts it writes zeros to all the RAM, read on to understand why this is significant.

On the 2.6.32 kernel transparent huge pages is disabled by default.
On the 3.10 kernel they are enabled by default

I'll quote myself from here:http://forum.proxmox.com/threads/15849-Huge-Pages-Support


In the 2.6.32 kernel, that setting is located in:

# cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
always madvise [never]

On 3.10 kernel its in:

# /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never

Be careful with a single VM using tons of RAM.
If the OOM Killer ever kicks in it will be first to get killed.

See Trace Flag 834, it might help improve performance of SQL server: http://support.microsoft.com/kb/920093

Hi e100

I guess that the VM isn't using Huge pages:

[B]cat /proc/meminfo[/B]
MemTotal:       264108924 kB
MemFree:        12819924 kB
MemAvailable:   12774880 kB
Buffers:           21904 kB
Cached:           156204 kB
SwapCached:            0 kB
Active:         247737092 kB
Inactive:          94624 kB
Active(anon):   247693364 kB
Inactive(anon):    29380 kB
Active(file):      43728 kB
Inactive(file):    65244 kB
Unevictable:       66768 kB
Mlocked:           66768 kB
SwapTotal:      20971516 kB
SwapFree:       20971516 kB
Dirty:                68 kB
Writeback:             0 kB
AnonPages:      247720824 kB
Mapped:            80084 kB
Shmem:             60224 kB
Slab:             109132 kB
SReclaimable:      26188 kB
SUnreclaim:        82944 kB
KernelStack:        5152 kB
PageTables:       492868 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:    153025976 kB
Committed_AS:   256433356 kB
VmallocTotal:   34359738367 kB
VmallocUsed:     1219784 kB
VmallocChunk:   34224148424 kB
HardwareCorrupted:     0 kB
AnonHugePages:  247377920 kB
HugePages_Total:       0   [B][COLOR=#ff0000]<------- ¿? ¿? ¿?[/COLOR][/B]
HugePages_Free:        0   [COLOR=#ff0000][B]<------- ¿? ¿? ¿?[/B][/COLOR]
HugePages_Rsvd:        0   [COLOR=#ff0000][B]<------- ¿? ¿? ¿?[/B][/COLOR]
HugePages_Surp:        0   [COLOR=#ff0000][B]<------- ¿? ¿? ¿?[/B][/COLOR]
Hugepagesize:       2048 kB
DirectMap4k:      216000 kB
DirectMap2M:     7077888 kB
DirectMap1G:    263192576 kB

[B]cat /sys/kernel/mm/transparent_hugepage/enabled[/B]
[always] madvise never

[B]cat /proc/sys/vm/nr_hugepages[/B]
0

The PVE node (by GUI) shows that the host has a total RAM available of 251.87 GB.

[B]free -h[/B]
             total       used       free     shared    buffers     cached
Mem:          251G       239G        12G         0B        19M       151M
-/+ buffers/cache:       239G        12G
Swap:          19G         0B        19G

And about of NUMA nodes:

[B]
cat /sys/devices/system/node/node0/meminfo | fgrep Huge[/B]
Node 0 AnonHugePages:  123680768 kB
Node 0 HugePages_Total:     0
Node 0 HugePages_Free:      0
Node 0 HugePages_Surp:      0

[B]cat /sys/devices/system/node/node1/meminfo | fgrep Huge[/B]
Node 1 AnonHugePages:  123699200 kB
Node 1 HugePages_Total:     0
Node 1 HugePages_Free:      0
Node 1 HugePages_Surp:      0

Then, i want that the host do his work and create the Huge pages automatically, but i guess that this behaviour does not exist.

So my question is:
1) How do such behaviour?

2) If isn't possible in a automatic mode, how can i enable it manually?

This is that i want (if automatic mode isn't possible):
Host:
- 8 GB RAM for the PVE host

Guest (MS-Windows server 2008R2 and SQL-Server):
- 8 GB RAM for the Windows server
- 235 GB RAM for the SQL. With the SQL Management, I can assign the space of memory that i want for this application in transparent form of the configuration of the Hugepages enabled in the Host.

Best regards
Cesar