cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

sachinbhatt
7-Bedrock

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

1 REPLY 1

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.

Top Tags