SQL Server windows NT service take 99 % ram usage

Question

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.

Nirav Gandhi · Answer

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.

Manoj Bhoir · Answer

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/

Jerry Maguire · Answer

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.

Jignesh Kumar · Answer

Hi Khaleel, Please try below link, https://serverfault.com/questions/247794/bad-performance-when-sql-server-hits-99-memory-usage