Skip to main content
8-Gravel
November 22, 2022
Solved

Is the response time of SQL server queries impacted by "outside" processes?

  • November 22, 2022
  • 1 reply
  • 872 views

Can the speed (response time) of a query done in a DBMS such as an SQL Server be impacted by what's going on in the system where the server is running? This article suggests that the response time is likely to increase when a few Windows programs that regularly inspect and clean the system, as well as analyze data received from the network, are operating. Is that correct?

Thanks.

Best answer by VladimirRosu_116627

Of course. Anything that runs in the machine that hosts your server can impact anything running in that machine, since they use the same resources effectively (CPU, IO, network bandwidth). Anti-viruses especially impact stuff since they use system hooks to inspect things.

1 reply

19-Tanzanite
November 24, 2022

Of course. Anything that runs in the machine that hosts your server can impact anything running in that machine, since they use the same resources effectively (CPU, IO, network bandwidth). Anti-viruses especially impact stuff since they use system hooks to inspect things.