脱机数据库是否减少了服 [英] does offline database reduces server load
问题描述
Hello All,
我有一台服务器,其中存储了15-20个大型数据库。其中一些没有使用。
我想让它们离线而不是删除它们。
我的问题是,一旦我将数据库脱机,它就会发布服务器上的一些负载?
如果我减少服务器上的在线数据库数量,我的查询会运行得更快吗?
(我认为服务器上托管的数据库越多,服务器就越慢将是)
谢谢
Hello All,
I have a server on which 15-20 large databases are stored.Some of them are not in use.
I am thinking to make them offline instead of deleting them.
My question is , once i take database offline will it release some load on server?
Will my queries run faster if i reduces number of online databases on server?
(i think more number of databases hosted on server , slower the server will be)
Thanks
推荐答案
如果服务器不足硬件,使数据库脱机确实减少了服务器负载到某个外部网。
if servers is low on hardware, making database offline does reduces server load up to some extenet.
我同意Maciej Los这里。数据库是否未被使用无关紧要。
I agree with Maciej Los here. It doesn't matter if the databases are unused.
将如果我减少服务器上在线数据库的数量,我的查询运行得更快?
Will my queries run faster if i reduces number of online databases on server?
这取决于。取决于在服务器中托管的数据库中访问/查询的用户数量。取决于您发送的查询。
That depends. Depends on how many users are accessing/querying in your database hosted in the server. Depends on the query you sent.
(我认为服务器上托管的数据库越多,服务器就越慢)
(i think more number of databases hosted on server , slower the server will be)
这也取决于。示例:在服务器1中,您有4个数据库,但其中3个未使用,有16个用户访问数据库。在服务器2中,您有2个数据库,两个都使用,有16个用户访问每个数据库。您觉得哪个服务器速度较慢?
That also depends. Example: In server 1, you have 4 databases but 3 of them are unused, with 16 users accessing the database. In server 2, you have 2 databases, both of them are used, with 16 users accessing each database. What server do you think is slower?
一旦我拿数据库离线它会在服务器上释放一些负载吗?
once i take database offline will it release some load on server?
我们在谈论什么'负载'?工作量或空间?
What 'load' are we talking about? The workload or the space?
我认为数据库未使用并不重要。重要的是他们占有多少个地方。
我建议你去缩小 [ ^ ]数据库和分离 [ ^ ]他们到制作副本。之后,从服务器中删除分离的数据库(如果它们确实未使用)。您可以随时附加它们。
请使用谷歌句子:SQL Server性能
进一步的信息。
I think it's not important that the databases are unused. It's important how many place they occupy.
I would suggest you to shrink[^] the databases and detach[^] them to make a copies. After that remove detached databases from server (if they are really unused). You'll be able to attach them anytime you want.
Please, use Google with sentence:SQL Server perfomance
fo further information.
这篇关于脱机数据库是否减少了服的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!