SQL Server memory suggested value for Virtual / Max server
發表於 : 2013年 3月 11日, 17:11
1. Virtual Memory : Greater than 8G for any physical memory sizes (example: 64G physical memory, Virtual Memory 8G)
Difference: NOT MEMORY DUMP
2. Max Server Memory:
Physical Max Server
2GB 1500
4GB 3200
6GB 4800
8GB 6400
12GB 10000
16GB 13500
24GB 21500
32GB 29000
48GB 44000
64GB 60000
72GB 68000
96GB 92000
128GB 124000
Difference: NOT MEMORY DUMP
2. Max Server Memory:
Physical Max Server
2GB 1500
4GB 3200
6GB 4800
8GB 6400
12GB 10000
16GB 13500
24GB 21500
32GB 29000
48GB 44000
64GB 60000
72GB 68000
96GB 92000
128GB 124000