question

dorkygrl avatar image
dorkygrl asked

MSSQL Max Memory setting not showing under OS processes task Manager

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.


memory
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.