Amazon CloudWatch Application Insights for .NET and SQL Server 支持的日志和指标
以下列表显示适用于 .NET 和 SQL Server 的 CloudWatch Application Insights 支持的日志和指标。
CloudWatch Application Insights for .NET and SQL Server 支持以下日志：
-
Microsoft Internet 信息服务 (IIS) 日志
-
EC2 上的 SQL Server 的错误日志
-
自定义 .NET 应用程序日志，例如 Log4Net
-
Windows 事件日志，包括 Windows 日志（系统、应用程序和安全），以及应用程序和服务日志
-
AWS Lambda 的 Amazon CloudWatch Logs
-
EC2 上 RDS MySQL 和 MySQL 的错误日志和慢速日志
CloudWatch Application Insights for .NET and SQL Server 支持以下应用程序组件的指标：
Amazon Elastic Compute Cloud (EC2)
CloudWatch 内置指标
CPUCreditBalance
CPUCreditUsage
CPUSurplusCreditBalance
CPUSurplusCreditsCharged
CPUUtilization
DiskReadBytes
DiskReadOps
DiskWriteBytes
DiskWriteOps
EBSByteBalance%
EBSIOBalance%
EBSReadBytes
EBSReadOps
EBSWriteBytes
EBSWriteOps
NetworkIn
NetworkOut
NetworkPacketsIn
NetworkPacketsOut
StatusCheckFailed
StatusCheckFailed_Instance
StatusCheckFailed_System
CloudWatch 代理指标 (Windows Server)
.NET CLR Exceptions # of Exceps Thrown
.NET CLR Exceptions # of Exceps Thrown/Sec
.NET CLR Exceptions # of Filters/sec
.NET CLR Exceptions # of Finallys/sec
.NET CLR Exceptions Throw to Catch Depth/sec
.NET CLR Interop # of CCWs
.NET CLR Interop # of Stubs
.NET CLR Interop # of TLB exports/sec
.NET CLR Interop # of TLB imports/sec
.NET CLR Interop # of marshaling
.NET CLR Jit % Time in Jit
.NET CLR Jit Standard Jit Failures
.NET CLR Loading % Time Loading
.NET CLR Loading Rate of Load Failures
.NET CLR LocksAndThreads Contention Rate/sec
.NET CLR LocksAndThreads Queue Length/sec
.NET CLR Memory # Total Committed Bytes
.NET CLR Memory % Time in GC
.NET CLR Networking 4.0.0.0 HttpWebRequest Average Queue Time
.NET CLR Networking 4.0.0.0 HttpWebRequests Aborted/sec
.NET CLR Networking 4.0.0.0 HttpWebRequests Failed/sec
.NET CLR Networking 4.0.0.0 HttpWebRequests Queued/sec
ASP.NET Application Restarts
ASP.NET Applications Errors Total/Sec
ASP.NET Applications Errors Unhandled During Execution/sec
ASP.NET Applications Requests in Application Queue
ASP.NET Applications Requests/Sec
ASP.NET Request Wait Time
ASP.NET Requests Queued
HTTP Service Request Queues CurrentQueueSize
LogicalDisk % Free Space
Memory % Committed Bytes In Use
Memory Available Mbytes
Memory Pages/sec
Network Interface Bytes Total/sec
Paging File % Usage
PhysicalDisk % Disk Time
PhysicalDisk Avg.Disk Queue Length
PhysicalDisk Avg.Disk sec/Read
PhysicalDisk Avg.Disk sec/Write
PhysicalDisk Disk Read Bytes/sec
PhysicalDisk Disk Reads/sec
PhysicalDisk Disk Write Bytes/sec
PhysicalDisk Disk Writes/sec
Processor % Idle Time
Processor % Interrupt Time
Processor % Processor Time
Processor % User Time
SQLServer:Access Methods Forwarded Records/sec
SQLServer:Access Methods Full Scans/sec
SQLServer:Access Methods Page Splits/sec
SQLServer:Buffer Manager Buffer cache hit ratio
SQLServer:Buffer Manager Page life expectancy
SQLServer:General Statistics Processes blocked
SQLServer:General Statistics User Connections
SQLServer:Latches Average Latch Wait Time (ms)
SQLServer:Locks Average Wait Time (ms)
SQLServer:Locks Lock Timeouts/sec
SQLServer:Locks Lock Waits/sec
SQLServer:Locks Number of Deadlocks/sec
SQLServer:Memory Manager Memory Grants Pending
SQLServer:SQL Statistics Batch Requests/sec
SQLServer:SQL Statistics SQL Compilations/sec
SQLServer:SQL Statistics SQL Re-Compilations/sec
System Processor Queue Length
TCPv4 Connections Established
TCPv6 Connections Established
W3SVC_W3WP File Cache Flushes
W3SVC_W3WP File Cache Misses
W3SVC_W3WP Requests/Sec
W3SVC_W3WP URI Cache Flushes
W3SVC_W3WP URI Cache Misses
Web Service Bytes Received/Sec
Web Service Bytes Sent/Sec
Web Service Connection attempts/sec
Web Service Current Connections
Web Service Get Requests/sec
Web Service Post Requests/sec
CloudWatch 代理指标 (Linux Server)
cpu_time_active
cpu_time_guest
cpu_time_guest_nice
cpu_time_idle
cpu_time_iowait
cpu_time_irq
cpu_time_nice
cpu_time_softirq
cpu_time_steal
cpu_time_system
cpu_time_user
cpu_usage_active
cpu_usage_guest
cpu_usage_guest_nice
cpu_usage_idle
cpu_usage_iowait
cpu_usage_irq
cpu_usage_nice
cpu_usage_softirq
cpu_usage_steal
cpu_usage_system
cpu_usage_user
disk_free
disk_inodes_free
disk_inodes_used
disk_used
disk_used_percent
diskio_io_time
diskio_iops_in_progress
diskio_read_bytes
diskio_read_time
diskio_reads
diskio_write_bytes
diskio_write_time
diskio_writes
mem_active
mem_available
mem_available_percent
mem_buffered
mem_cached
mem_free
mem_inactive
mem_used
mem_used_percent
net_bytes_recv
net_bytes_sent
net_drop_in
net_drop_out
net_err_in
net_err_out
net_packets_recv
net_packets_sent
netstat_tcp_close
netstat_tcp_close_wait
netstat_tcp_closing
netstat_tcp_established
netstat_tcp_fin_wait1
netstat_tcp_fin_wait2
netstat_tcp_last_ack
netstat_tcp_listen
netstat_tcp_none
netstat_tcp_syn_recv
netstat_tcp_syn_sent
netstat_tcp_time_wait
netstat_udp_socket
processes_blocked
processes_dead
processes_idle
processes_paging
processes_running
processes_sleeping
processes_stopped
processes_total
processes_total_threads
processes_wait
processes_zombies
swap_free
swap_used
swap_used_percent
Elastic Load Balancer (ELB)
EstimatedALBActiveConnectionCount
EstimatedALBConsumedLCUs
EstimatedALBNewConnectionCount
EstimatedProcessedBytes
HTTPCode_Backend_4XX
HTTPCode_Backend_5XX
HealthyHostCount
RequestCount
UnHealthyHostCount
Application ELB
EstimatedALBActiveConnectionCount
EstimatedALBConsumedLCUs
EstimatedALBNewConnectionCount
EstimatedProcessedBytes
HTTPCode_Backend_4XX
HTTPCode_Backend_5XX
HealthyHostCount
Latency
RequestCount
SurgeQueueLength
UnHealthyHostCount
Amazon EC2 Auto Scaling Groups
CPUCreditBalance
CPUCreditUsage
CPUSurplusCreditBalance
CPUSurplusCreditsCharged
CPUUtilization
DiskReadBytes
DiskReadOps
DiskWriteBytes
DiskWriteOps
EBSByteBalance%
EBSIOBalance%
EBSReadBytes
EBSReadOps
EBSWriteBytes
EBSWriteOps
NetworkIn
NetworkOut
NetworkPacketsIn
NetworkPacketsOut
StatusCheckFailed
StatusCheckFailed_Instance
StatusCheckFailed_System
Amazon Simple Queue Server (SQS)
ApproximateAgeOfOldestMessage
ApproximateNumberOfMessagesDelayed
ApproximateNumberOfMessagesNotVisible
ApproximateNumberOfMessagesVisible
NumberOfEmptyReceives
NumberOfMessagesDeleted
NumberOfMessagesReceived
NumberOfMessagesSent
Amazon Relational Database Service (RDS)
BurstBalance
CPUCreditBalance
CPUUtilization
DatabaseConnections
DiskQueueDepth
FailedSQLServerAgentJobsCount
FreeStorageSpace
FreeableMemory
NetworkReceiveThroughput
NetworkTransmitThroughput
ReadIOPS
ReadLatency
ReadThroughput
WriteIOPS
WriteLatency
WriteThroughput
AWS Lambda 函数
错误
DeadLetterErrors
持续时间
限制
IteratorAge
ProvisionedConcurrencySpilloverInvocations
Amazon DynamoDB 表
系统错误
用户错误
已使用读取容量单位
已使用写入容量单位
ReadThrottleEvents
WriteThrottleEvents
TimeToLiveDeletedItemCount
ConditionalCheckFailedRequests
TransactionConflict
ReturnedRecordsCount
PendingReplicationCount
ReplicationLatency
Amazon S3 存储桶
ReplicationLatency
BytesPendingReplication
OperationsPendingReplication
4xxErrors
5xxErrors
AllRequests
GetRequests
PutRequests
DeleteRequests
HeadRequests
PostRequests
SelectRequests
ListRequests
SelectScannedBytes
SelectReturnedBytes
FirstByteLatency
TotalRequestLatency
BytesDownloaded
BytesUploaded
具有数据点要求的指标
对于没有触发警报的明显默认阈值的指标，Application Insights 等到指标具有足够的数据点以预测触发警报的合理阈值。CloudWatch Application Insights 在创建警报之前检查的指标数据点要求是：
-
指标从过去 15 天到过去 2 天期间至少具有 100 个数据点。
-
指标在最后一天至少具有 100 个数据点。
以下指标遵循这些数据点要求。请注意，CloudWatch 代理指标最多需要一小时才能创建警报。
指标
AWS/ApplicationELB
ActiveConnectionCount
ConsumedLCUs
HTTPCode_ELB_4XX_Count
HTTPCode_Target_2XX_Count
HTTPCode_Target_3XX_Count
HTTPCode_Target_4XX_Count
HTTPCode_Target_5XX_Count
NewConnectionCount
ProcessedBytes
TargetResponseTime
UnHealthyHostCount
AWS/AutoScaling
GroupDesiredCapacity
GroupInServiceInstances
GroupMaxSize
GroupMinSize
GroupPendingInstances
GroupStandbyInstances
GroupTerminatingInstances
GroupTotalInstances
AWS/EC2
CPUCreditBalance
CPUCreditUsage
CPUSurplusCreditBalance
CPUSurplusCreditsCharged
CPUUtilization
DiskReadBytes
DiskReadOps
DiskWriteBytes
DiskWriteOps
EBSByteBalance%
EBSIOBalance%
EBSReadBytes
EBSReadOps
EBSWriteBytes
EBSWriteOps
NetworkIn
NetworkOut
NetworkPacketsIn
NetworkPacketsOut
AWS/ELB
EstimatedALBActiveConnectionCount
EstimatedALBConsumedLCUs
EstimatedALBNewConnectionCount
EstimatedProcessedBytes
HTTPCode_Backend_4XX
HTTPCode_Backend_5XX
HealthyHostCount
Latency
RequestCount
SurgeQueueLength
UnHealthyHostCount
AWS/RDS
CPUCreditBalance
DatabaseConnections
DiskQueueDepth
FreeStorageSpace
FreeableMemory
NetworkReceiveThroughput
NetworkTransmitThroughput
ReadIOPS
ReadThroughput
WriteIOPS
WriteThroughput
AWS/Lambda
错误
DeadLetterErrors
持续时间
限制
IteratorAge
ProvisionedConcurrencySpilloverInvocations
AWS/SQS
ApproximateAgeOfOldestMessage
ApproximateNumberOfMessagesDelayed
ApproximateNumberOfMessagesNotVisible
ApproximateNumberOfMessagesVisible
NumberOfEmptyReceives
NumberOfMessagesDeleted
NumberOfMessagesReceived
NumberOfMessagesSent
AWS/CWAgent
LogicalDisk % Free Space
Memory % Committed Bytes In Use
Memory Available Mbytes
Network Interface Bytes Total/sec
Paging File % Usage
PhysicalDisk % Disk Time
PhysicalDisk Avg.Disk sec/Read
PhysicalDisk Avg.Disk sec/Write
PhysicalDisk Disk Read Bytes/sec
PhysicalDisk Disk Reads/sec
PhysicalDisk Disk Write Bytes/sec
PhysicalDisk Disk Writes/sec
Processor % Idle Time
Processor % Interrupt Time
Processor % Processor Time
Processor % User Time
SQLServer:Access Methods Forwarded Records/sec
SQLServer:Access Methods Page Splits/sec
SQLServer:Buffer Manager Buffer cache hit ratio
SQLServer:Buffer Manager Page life expectancy
SQLServer：接收的数据库副本文件字节数/秒
SQLServer：接收的数据库副本日志字节数/秒
SQLServer：保留数据库副本日志以供撤消
SQLServer：数据库副本日志发送队列
SQLServer：数据库副本镜像写事务数/秒
SQLServer：数据库副本恢复队列
SQLServer：剩余数据库副本重做字节数
SQLServer：数据库副本已重做的字节数/秒
SQLServer：需要撤消的数据库副本总日志
SQLServer：数据库副本事务延迟
SQLServer:General Statistics Processes blocked
SQLServer:SQL Statistics Batch Requests/sec
SQLServer:SQL Statistics SQL Compilations/sec
SQLServer:SQL Statistics SQL Re-Compilations/sec
System Processor Queue Length
TCPv4 Connections Established
TCPv6 Connections Established
AWS/DynamoDB
已使用读取容量单位
已使用写入容量单位
ReadThrottleEvents
WriteThrottleEvents
TimeToLiveDeletedItemCount
ConditionalCheckFailedRequests
TransactionConflict
ReturnedRecordsCount
PendingReplicationCount
ReplicationLatency
AWS/S3
ReplicationLatency
BytesPendingReplication
OperationsPendingReplication
4xxErrors
5xxErrors
AllRequests
GetRequests
PutRequests
DeleteRequests
HeadRequests
PostRequests
SelectRequests
ListRequests
SelectScannedBytes
SelectReturnedBytes
FirstByteLatency
TotalRequestLatency
BytesDownloaded
BytesUploaded
推荐的指标
下表列出了每种组件类型的建议指标。
| 组件类型 | 工作负载类型 | 建议的指标 |
|---|---|---|
|
EC2 实例 (Windows Server) |
Microsoft IIS/.NET Web 前端 |
CPUUtilization StatusCheckFailed Processor % Processor Time Memory % Committed Bytes In Use Memory Available Mbytes .NET CLR Exceptions # of Exceps Thrown/Sec .NET CLR Memory # Total Committed Bytes .NET CLR Memory % Time in GC ASP.NET Applications Requests in Application Queue ASP.NET Requests Queued ASP.NET Application Restarts |
|
Microsoft SQL Server 数据库层 |
CPUUtilization StatusCheckFailed Processor % Processor Time Memory % Committed Bytes In Use Memory Available Mbytes Paging File % Usage System Processor Queue Length Network Interface Bytes Total/Sec PhysicalDisk % Disk Time SQLServer:Buffer Manager Buffer Cache Hit ratio SQLServer:Buffer Manager Page Life Expectancy SQLServer:General Statistics Processes Blocked SQLServer:General Statistics User Connections SQLServer:Locks Number of Deadlocks/Sec SQLServer:SQL Statistics Batch Requests/Sec |
|
| .NET 工作线程池/中间层 |
CPUUtilization StatusCheckFailed Processor % Processor Time Memory % Committed Bytes In Use Memory Available Mbytes .NET CLR Exceptions # of Exceps Thrown/Sec .NET CLR Memory # Total Committed Bytes .NET CLR Memory % Time in GC |
|
| .NET Core 层 |
CPUUtilization StatusCheckFailed Processor % Processor Time Memory % Committed Bytes In Use Memory Available Mbytes |
|
|
EC2 实例 (Linux Server) |
.NET Core 层或 SQL Server 数据库层 |
CPUUtilization StatusCheckFailed disk_used_percent mem_used_percent |
|
Classic ELB |
任何 |
HTTPCode_Backend_4XX HTTPCode_Backend_5XX Latency SurgeQueueLength UnHealthyHostCount |
|
Application ELB |
任何 |
HTTPCode_Target_4XX_Count HTTPCode_Target_5XX_Count TargetResponseTime UnHealthyHostCount |
|
RDS Instance |
任何 |
CPUUtilization ReadLatency WriteLatency BurstBalance FailedSQLServerAgentJobsCount |
|
Lambda 函数 |
任何 |
持续时间 错误 IteratorAge ProvisionedConcurrencySpilloverInvocations 限制 |
|
SQS Queue |
任何 |
ApproximateAgeOfOldestMessage ApproximateNumberOfMessagesVisible NumberOfMessagesSent |
| Amazon DynamoDB 表 | 任何 |
系统错误 用户错误 已使用读取容量单位 已使用写入容量单位 ReadThrottleEvents WriteThrottleEvents ConditionalCheckFailedRequests TransactionConflict |
|
Amazon S3 存储桶 |
任何 |
如果启用了带有复制时间控制 (RTC) 的复制配置： ReplicationLatency BytesPendingReplication OperationsPendingReplication 如果启用了请求指标： 5xxErrors 4xxErrors BytesDownloaded BytesUploaded |
性能计数器指标
仅当 Windows 实例上安装了相应的性能计数器集时，才建议对实例使用性能计数器指标。
| 性能计数器指标名称 | 性能计数器集名称 |
|---|---|
| .NET CLR Exceptions # of Exceps Thrown | .NET CLR Exceptions |
| .NET CLR Exceptions # of Exceps Thrown/Sec | .NET CLR Exceptions |
| .NET CLR Exceptions # of Filters/Sec | .NET CLR Exceptions |
| .NET CLR Exceptions # of Finallys/Sec | .NET CLR Exceptions |
| .NET CLR Exceptions Throw to Catch Depth/Sec | .NET CLR Exceptions |
| .NET CLR Interop # of CCWs | .NET CLR Interop |
| .NET CLR Interop # of Stubs | .NET CLR Interop |
| .NET CLR Interop # of TLB exports/Sec | .NET CLR Interop |
| .NET CLR Interop # of TLB imports/Sec | .NET CLR Interop |
| .NET CLR Interop # of Marshaling | .NET CLR Interop |
| .NET CLR Jit % Time in Jit | .NET CLR Jit |
| .NET CLR Jit Standard Jit Failures | .NET CLR Jit |
| .NET CLR Loading % Time Loading | .NET CLR Loading |
| .NET CLR Loading Rate of Load Failures | .NET CLR Loading |
| .NET CLR LocksAndThreads Contention Rate/Sec | .NET CLR LocksAndThreads |
| .NET CLR LocksAndThreads Queue Length/Sec | .NET CLR LocksAndThreads |
| .NET CLR Memory # Total Committed Bytes | .NET CLR Memory |
| .NET CLR Memory % Time in GC | .NET CLR Memory |
| .NET CLR Networking 4.0.0.0 HttpWebRequest Average Queue Time | .NET CLR Networking 4.0.0.0 |
| .NET CLR Networking 4.0.0.0 HttpWebRequests Aborted/Sec | .NET CLR Networking 4.0.0.0 |
| .NET CLR Networking 4.0.0.0 HttpWebRequests Failed/Sec | .NET CLR Networking 4.0.0.0 |
| .NET CLR Networking 4.0.0.0 HttpWebRequests Queued/Sec | .NET CLR Networking 4.0.0.0 |
| ASP.NET Application Restarts | ASP.NET |
| ASP.NET Applications Errors Total/Sec | ASP.NET Applications |
|
ASP.NET Applications Errors Unhandled During Execution/Sec |
ASP.NET Applications |
|
ASP.NET Applications Requests in Application Queue |
ASP.NET Applications |
|
ASP.NET Applications Requests/Sec |
ASP.NET Applications |
| ASP.NET Request Wait Time | ASP.NET |
| ASP.NET Requests Queued | ASP.NET |
| HTTP Service Request Queues CurrentQueueSize | HTTP Service Request Queues |
|
LogicalDisk % Free Space |
LogicalDisk |
|
Memory % Committed Bytes In Use |
内存 |
|
Memory Available Mbytes |
内存 |
| Memory Pages/Sec |
内存 |
|
Network Interface Bytes Total/Sec |
网络接口 |
|
Paging File % Usage |
Paging File |
| PhysicalDisk % Disk Time | PhysicalDisk |
| PhysicalDisk Avg.Disk Queue Length | PhysicalDisk |
| PhysicalDisk Avg.Disk Sec/Read | PhysicalDisk |
| PhysicalDisk Avg.Disk Sec/Write | PhysicalDisk |
| PhysicalDisk Disk Read Bytes/Sec | PhysicalDisk |
| PhysicalDisk Disk Reads/Sec | PhysicalDisk |
| PhysicalDisk Disk Write Bytes/Sec | PhysicalDisk |
| PhysicalDisk Disk Writes/Sec | PhysicalDisk |
|
Processor % Idle Time |
处理器 |
| Processor % Interrupt Time |
处理器 |
| Processor % Processor Time |
处理器 |
| Processor % User Time |
处理器 |
| SQLServer:Access Methods Forwarded Records/Sec |
SQLServer:Access Methods |
| SQLServer:Access Methods Full Scans/Sec |
SQLServer:Access Methods |
| SQLServer:Access Methods Page Splits/Sec |
SQLServer:Access Methods |
| SQLServer:Buffer Manager Buffer cache hit Ratio |
SQLServer:Buffer Manager |
| SQLServer:Buffer Manager Page life Expectancy |
SQLServer:Buffer Manager |
| SQLServer：接收的数据库副本文件字节数/秒 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：接收的数据库副本日志字节数/秒 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：保留数据库副本日志以供撤消 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：数据库副本日志发送队列 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：数据库副本镜像写事务数/秒 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：数据库副本恢复队列 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：剩余数据库副本重做字节数 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：数据库副本已重做的字节数/秒 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：需要撤消的数据库副本总日志 | SQL_SERVER_ALWAYSON_AG |
| SQLServer：数据库副本事务延迟 | SQL_SERVER_ALWAYSON_AG |
| SQLServer:General Statistics Processes Blocked |
SQLServer:General Statistics |
| SQLServer:General Statistics User Connections | SQLServer:General Statistics |
| SQLServer:Latches Average Latch Wait Time (ms) | SQLServer:Latches |
| SQLServer:Locks Average Wait Time (ms) | SQLServer:Locks |
| SQLServer:Locks Lock Timeouts/Sec | SQLServer:Locks |
| SQLServer:Locks Lock Waits/Sec | SQLServer:Locks |
| SQLServer:Locks Number of Deadlocks/Sec | SQLServer:Locks |
| SQLServer:Memory Manager Memory Grants Pending | SQLServer:Memory Manager |
| SQLServer:SQL Statistics Batch Requests/Sec | SQLServer:SQL Statistics |
| SQLServer:SQL Statistics SQL Compilations/Sec | SQLServer:SQL Statistics |
| SQLServer:SQL Statistics SQL Re-Compilations/Sec |
SQLServer:SQL Statistics |
| System Processor Queue Length |
系统 |
| TCPv4 Connections Established | TCPv4 |
| TCPv6 Connections Established | TCPv6 |
| W3SVC_W3WP File Cache Flushes | W3SVC_W3WP |
| W3SVC_W3WP File Cache Misses | W3SVC_W3WP |
| W3SVC_W3WP Requests/Sec | W3SVC_W3WP |
| W3SVC_W3WP URI Cache Flushes | W3SVC_W3WP |
| W3SVC_W3WP URI Cache Misses | W3SVC_W3WP |
| Web Service Bytes Received/Sec |
Web 服务 |
| Web Service Bytes Sent/Sec |
Web 服务 |
|
Web Service Connection Attempts/Sec |
Web 服务 |
| Web Service Current Connections |
Web 服务 |
| Web Service Get Requests/Sec |
Web 服务 |
| Web Service Post Requests/Sec |
Web 服务 |