0

I have an SQL server 2016,

version: (SP2-CU4-OD) (KB4482972) - 13.0.5239.0 (X64)

The server is a Win 2016, with 64 GB RAM. I have configured max memory for SQL to 54 GB, but it uses less than 1 GB. Data are been migrated from an older SQL version.

Somebody can help me?

Thanks

Improve this question
6
  • 2
    Please add "complete" output of select @@version in the question
    – Shanky
    Jan 21, 2020 at 16:17
  • @shanky wants the full output to see if you are running express because express has a limit of 1410MB(learn.microsoft.com/en-us/archive/blogs/sql_server_team/…)
    – Bob Klimes
    Jan 21, 2020 at 16:52
  • 2
    uses less than 1 GB according to what?
    – Aaron Bertrand
    Jan 21, 2020 at 21:22
  • Hi, the SQL is a standard edition, in task manager I see that instance use less 1 GB, and I have about 58 GB free.
    – Bruno
    Jan 22, 2020 at 8:34
  • 1
    Don't use task manager to monitor memory. Instead, use PMON or the DMV query SELECT counter_name, cntr_value FROM sys.dm_os_performance_counters WHERE counter_name = N'Total Server Memory (KB)';
    – Dan Guzman
    Jan 22, 2020 at 12:10

1 Answer 1

Reset to default
3

Like @Shanky mentioned in the comment, it could be due to Express Edition accidently being installed instead of Standard or Enterprise. Due to the Database size size limit, I don't think you could even restore a large database, so you would notice almost immediately.

As an experiement, have you tried caching a lot of data in memory by doing several large SELECTs to see if it changes? SQL Server is fairly memory-hungry, but by default it doesn't use memory until it needs it, so if nothing has happened since the last restart, there's nothing in memory yet.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.