Hello,
we are in the process of migrating from MSSQL Server 2012 to MSSQL 2017.
I have a new install MSSQL 2017 / windows 2016. Total memory on the server 32 GB and for MSSQL assigned 24GB. ( done under Server Properties -> Memory )
Windows server 2016
Memory allocated to MSSQL 2017 24500 MB
Memory available 32767 MB
Processors 4
Swap space 22GB
if browse to Task Manager -> Processes --> MSSQL server 2017 process only shows 1 GB of Memory.
Compared the old server MSSQL 2012 where the memory is configured exactly the same but
Microsoft Windows NT 6.1 (7601)
Memory allocated to MSSQL 24500 MB
Memory available 32767 MB
Processors 4
Swap space 33GB
under processes we are able to view that 24GB of memory is assigned to MSSQL.
As a test we run one query that finishes in 1 Min on MSSQL 2012 and takes 5 min to complete on new MSSQL 2017. Basically i think the way MSSQL 2017 manages Memory might be a bottleneck.
Did anyone have similar experience? Can you please share or suggest what I can do to at least make performance match MSSQL 2012. Thanks in advance.