数据操作查询是否会影响服务器中数据库的性能 [英] Does data manipulation query affect performance of databases within a server

问题描述

i想知道我是否使用数据操作查询（例如插入，删除，选择）

会影响同一服务器内另一个数据库的操作。在同一服务器内的数据库中是否存在性能问题。

i would like to know if i use data manipulation queries (such as insert ,delete,select)

with a database does it affect the operations of another database within the same

server.Is there performance issue within databases within the same server.

推荐答案

嗯......是的，可能。



唯一现实的答案是它取决于 - 因为如果您的查询使用资源，服务器是具有有限资源（处理和内存）的计算机，那么它们不可用于其他Sql连接上的其他操作。如果您的查询使用了大量资源，那么这可能会影响同一服务器中的其他数据库，就像您编写的应用程序独占PC的处理器和RAM一样，它将影响其他情况。



在SQL环境中，如果有几个用户在您的数据库上运行类似的长时间运行查询，那么将开始阻塞其他操作。但这将取决于何时发生，它不一定是一致的。

Well...yes, possibly.

The only realistic answer is "it depends" - because the server is a computer with finite resources (both processing and memory) if your query is using resources, then they aren't available for other operations on other Sql Connections. If your query is using significant resources, than that could impact on other databases within the same server, just as if you write an app that monopolises the processor and RAM of your PC it will affect what else happens.

And in an SQL environment, if you have several users running similar long-running queries on your DB, that will start to clog other operations. But it will depend on when it all happens, it won't necessarily be consistent.

这篇关于数据操作查询是否会影响服务器中数据库的性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！