活动监视器Activity Monitor

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

活动监视器显示有关 SQL ServerSQL Server 进程的信息,并了解这些进程如何影响 SQL ServerSQL Server的当前实例。Activity Monitor displays information about SQL ServerSQL Server processes and how these processes affect the current instance of SQL ServerSQL Server.

活动监视器是一个带有以下可展开和折叠的窗格的选项卡式文档窗口:“概述” 、“进程” 、“资源等待” 、“数据文件 I/O” 、“最近耗费大量资源的查询” 和“耗费大量资源的活动查询” 。Activity Monitor is a tabbed document window with the following expandable and collapsible panes: Overview, Processes, Resource Waits, Data File I/O, Recent Expensive Queries, and Active Expensive Queries. 展开任何窗格时,活动监视器都将查询实例以获取相关信息。When any pane is expanded, Activity Monitor queries the instance for information. 折叠窗格时,该窗格的所有查询活动都将停止。When a pane is collapsed, all querying activity stops for that pane. 你可以同时展开一个或多个窗格,以查看实例上不同种类的活动。You can expand one or more panes at the same time to view different kinds of activity on the instance.

自定义列Customize columns

对于在“进程” 、“资源等待” 、“数据文件 I/O” 、“最近耗费大量资源的查询” 和“耗费大量资源的活动查询” 窗格中的列,用以下方式自定义显示内容:For columns included in the Processes, Resource Waits, Data File I/O, Recent Expensive Queries, and Active Expensive Queries panes, customize the display as follows:

  1. 若要重排列的顺序,请单击列标题,并将其拖到标题功能区中的另一位置。To rearrange column order, click the column heading and drag it to another location in the heading ribbon.

  2. 若要排序列,请单击列名称。To sort a column, click the column name.

  3. 若要对一个或多个列进行筛选,请单击列标题中的下拉箭头,然后选择值。To filter on one or more columns, click the drop-down arrow in the column heading, and then select a value.

期待您的反馈 :如果在本文中发现过时或不正确的内容(如步骤或代码示例),请告诉我们。We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. 可以单击此页底部的“反馈” 部分中的“本页” 按钮。You can click the This page button in the Feedback section at the bottom of this page. 我们通常在第二天阅读有关 SQL 的每项反馈。We read every item of feedback about SQL, typically the next day. 谢谢。Thanks.

详细信息More information

说明如何打开活动监视器和如何设置活动监视器刷新间隔。Describes how to open Activity Monitor and how to set the Activity Monitor refresh interval. 打开活动监视器 (SQL Server Management Studio)Open Activity Monitor (SQL Server Management Studio)
链接到关于服务器性能和活动监视的主题。Links to topics for server performance and activity monitoring. 服务器性能和活动监视Server Performance and Activity Monitoring