MS SQL中查询的优先级 [英] Priority of a query in MS SQL

问题描述

有没有办法告诉MS SQL一个查询不是太重要，它可以（应该）花费时间吗？

Is there a way to tell MS SQL that a query is not too important and that it can (and should) take its time?

同样有一种方法

推荐答案

不在SQL 2008以下的版本中。在SQL Server 2008中有资源调控器。使用它，您可以基于登录的属性（登录名，应用程序名称等）将登录分配给组。然后可以将组分配给资源池和限制或限制。资源可以应用于这些资源池

Not in versions below SQL 2008. In SQL Server 2008 there's the resource governor. Using that you can assign logins to groups based on properties of the login (login name, application name, etc). The groups can then be assigned to resource pools and limitations or restrictions i.t.o. resources can be applied to those resource pools

这篇关于MS SQL中查询的优先级的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！