SQL Server windows NT service take 99 % ram usage

khaleel shaik

7y42kDatabases & DBA

SQL Server windows NT service take 93 % ram usage , Please any one give me idea for reducing the memory usage.

server ram is 32 gb.

It is taken continueos 93 5 is taken ram usage .

Please give me any one good solution.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jerry Maguire5y ago
Open SQL Management studio and connect and see what databases are there?
Best practices with SQL are to limit it to around 80% of the available RAM if this is a dedicated SQL box.
If it is shared with other stuff then what you assign will be dependant on the needs of the application.
You can set this RAM limit via SQL management studio - just right click on the server once connected and go into properties.

Best,
Jerry M.
+1
Jignesh Kumar7y ago
Hi Khaleel,

Please try below link,
https://serverfault.com/questions/247794/bad-performance-when-sql-server-hits-99-memory-usage
+1
Nirav Gandhi7y ago
SQL Server by default take all available memory(except leave some memory for OS) for Database activity. however, if OS is requiring memory to run some services other than SQL server, OS sends to request SQL server it will release memory or vice-versa

As per database guild lines, please follow below rules:-
If you have dedicated SQL server then follow 80,20 rules

80% memory configure for SQL Sever

20% memory for OS

If you have shared SQL server than identity memory uses by other application

60% memory configure for SQL Server

20% memory for others application

20% memory for OS
Please open SQL server properties and configure memory as per below Image:-

Note:
Please set at least 2GB memory.
Use Activity monitor to identity memory usages.
+1
Manoj Bhoir7y ago
Hi,

SQL Server Windows NT is known as sqlservr.exe process, it is normal that SQL Server consumes as much memory as possible since SQL Server likes to cache data in memory to speed up access. You might have long running queries on SQL Server. Do you find any performance issues?

If SQL Server is not installed on a dedicate production machine and you have other applications on the machine, you could limit the memory usage by configuring Max Server Memory according to your situation.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-2017

In addition, about how to detect DDOS attack and block it, you could refer to the following article:
https://sulich.wordpress.com/2012/06/27/detecting-ddos-attack-in-windows/

+1