How to fix issue D disk save Database hang up due to 100% performance

Question

Hi,

Now i facing a issue related to the MSSQL2016. The SQL save data inspection but now some time hang up and I had to checked that D disk save Database performance run 100%.

The PC save Database run under domain policy then use antivirus software Crowdstrike Falcon Sensor.

Now i dont know how to check what the process scanning or security of Antivirus software affect MSSQL2016.

When hang up, we see SQL server windows NT 64bit Top in Processes

Lets me know if Microsoft have any idea for this issue

My email: ******@fuji-smt.com.sg

Thanks

Answer 1

I see you are complaining about SQL Server consumption of resources, but on the image you shared SQL Server is consuming close to 2 GB of RAM. However, the recommended amount of RAM for all SQL Server 2016 editions (with exception of Express Edition) is 4 GB of RAM. SQL Server is designed to make heavy used of computer resources like memory, IO subsystem and CPU.

In the images you shared I see the consumption of memory, CPU, IO subsystem is not above 50%, so the server is not under contention.

Installing antivirus software on a SQL Server server may impact performance and stability, please read Microsoft guidelines about this topic on this documentation. In addtion, If the server is using mechanical disks the impact on performance of antivirus activity may be greater when compared to SSD drives.

Answer 2

In addition to Alberto's post, you should add the folders where you have you SQL Server databases to the exclusion list for the anti-virus.