SQL Server活动监视器

最新推荐文章于 2024-07-28 18:27:48 发布

culuo4781

最新推荐文章于 2024-07-28 18:27:48 发布

阅读量4.6k

点赞数

文章标签：数据库 linux java python 大数据

原文链接：https://www.sqlshack.com/sql-server-activity-monitor/

版权

SQL Server活动监视器是一款用于显示SQL Server进程及其对性能影响的工具，包括概述、进程、资源等待、数据文件I/O和最近昂贵查询等多个窗格。它通过实时更新展示关键性能指标，如处理器时间、等待任务、数据库I/O等。用户可以根据需要过滤和分析数据，但其功能有限，不适合深度性能监控。要使用活动监视器，需要VIEW SERVER STATE权限，且终止进程需具备sysadmin角色。

摘要由CSDN通过智能技术生成

什么是SQL Server活动监视器？ (What is SQL Server Activity Monitor?)

SQL Server Activity Monitor is a feature in SQL Server Management Studio that displays information about the SQL Server processes and their effect on SQL Server performance

SQL Server活动监视器是SQL Server Management Studio中的一项功能，可显示有关SQL Server进程及其对SQL Server性能的影响的信息

活动监视器窗格 (Activity Monitor panes)

Activity Monitor consists of several panes – Overview, Processes, Resource Waits, Data File I/O, and Recent Expensive Queries. Panes can be expanded and collapsed. The activities are queried only when the specific pane is expanded

活动监视器由几个窗格组成- 概述，流程，资源等待，数据文件I / O和最近的昂贵查询 。窗格可以展开和折叠。仅在展开特定窗格时才查询活动

“Activity Monitor runs queries on the monitored instance to obtain information for the Activity Monitor display panes. When the refresh interval is set to less than 10 seconds, the time that is used to run these queries can affect server performance” [1]

“活动监视器在受监视的实例上运行查询，以获取活动监视器显示窗格的信息。 当刷新间隔设置为小于10秒时，用于运行这些查询的时间可能会影响服务器性能” [1]

概述窗格 (The Overview pane)

The Overview pane contains the graphs for the most important SQL Server instance information. The context menu contains the Refresh interval option that can be set to a predefined value from 1 second to 1 hour

概述窗格包含最重要SQL Server实例信息的图。上下文菜单包含“ 刷新间隔”选项，可以将其设置为从1秒到1小时的预定义值

SQL Server Activity Monitor - Overview pane

% Processor Time – is the percentage of time the processors spend to execute threads that are not idle

％Processor Time –是处理器用于执行非空闲线程的时间百分比

Waiting Tasks – is the number of tasks that are waiting for processor, I/O, or memory to be released so the tasks can be processed

等待任务 –是等待处理器，I / O或内存被释放以便可以处理任务的任务数

Database I/O – is the data transfer rate in MB/s from memory to disk, disk to memory, or disk to disk

数据库I / O –是从内存到磁盘，从磁盘到内存或从磁盘到磁盘的数据传输速率，以MB / s为单位

Batch Requests/sec – is the number of SQL Server batches received by the instance in a second

每秒批处理请求数 –是实例在一秒钟内收到SQL Server批处理数

进程窗格 (The Processes pane)

The Processes pane shows the information about the currently running processes on the SQL databases, who runs them, and from which application

“ 进程”窗格显示有关SQL数据库上当前正在运行的进程，谁运行它们以及从哪个应用程序运行的信息。

A tooltip for each table header shows a short description of the column data and system views used to obtain it. Each column can be filtered using the filters in the column header

每个表标题的工具提示显示了列数据的简短描述以及用于获取列数据的系统视图。可以使用列标题中的过滤器过滤每列

The context menu for th