SQLServer 基线跟踪指标

基线收集参考：SQLServer Windows数据收集器

####################  CPU相关  ####################
"Processor(_Total)% User Time"
"Processor(_Total)% Processor Time"
"Processor(_Total)% Interrupt Time"
"Processor(_Total)% Privileged Time"
"SystemContext Switches/sec"
"SystemProcessor Queue Length"
"SystemProcesses"
"SystemThreads"

####################  内存相关  ####################
"Paging File(??C:pagefile.sys)% Usage"
"Paging File(??C:pagefile.sys)% Usage Peak"
"MemoryPages/sec"
"MemoryPage Faults/sec"
"MemoryAvailable MBytes"
"SQLServer:Buffer ManagerBuffer cache hit ratio"
"SQLServer:Buffer ManagerLazy writes/sec"
"SQLServer:Buffer ManagerPage life expectancy"
"SQLServer:Buffer ManagerCheckpoint pages/sec"
"SQLServer:Buffer ManagerTotal pages"
"SQLServer:Buffer ManagerTarget pages"
"SQLServer:Memory ManagerTarget Server Memory (KB)"
"SQLServer:Memory ManagerTotal Server Memory (KB)"
"SQLServer:Memory ManagerDatabase Cache Memory (KB)"
"SQLServer:Memory ManagerConnection Memory (KB)"
"SQLServer:Memory ManagerGranted Workspace Memory (KB)"
"SQLServer:Memory ManagerLock Memory (KB)"
"SQLServer:Memory ManagerMemory Grants Pending"
"SQLServer:Memory ManagerOptimizer Memory (KB)"
"SQLServer:Memory ManagerSQL Cache Memory (KB)"
"SQLServer:Memory ManagerStolen Server Memory (KB)"

####################  IO disk 相关  ####################
#监控指定各个数据库
#"SQLServer:Databases(AdventureWorks2014)Data File(s) Size (KB)"
#"SQLServer:Databases(AdventureWorks2014)Log File(s) Size (KB)"
#"SQLServer:Databases(AdventureWorks2014)Transactions/sec"
"SQLServer:Databases(_Total)Transactions/sec"
"SQLServer:Databases(_Total)Log File(s) Size (KB)"
"SQLServer:Databases(_Total)Data File(s) Size (KB)"
"PhysicalDisk(_Total)% Disk Time"
"PhysicalDisk(_Total)Avg. Disk Queue Length"
"PhysicalDisk(_Total)Current Disk Queue Length"
"PhysicalDisk(_Total)Avg. Disk Read Queue Length"
"PhysicalDisk(_Total)Avg. Disk Write Queue Length"
"PhysicalDisk(_Total)Avg. Disk sec/Read"
"PhysicalDisk(_Total)Avg. Disk sec/Write"
"PhysicalDisk(_Total)Avg. Disk Bytes/Read"
"PhysicalDisk(_Total)Avg. Disk Bytes/Write"
"PhysicalDisk(_Total)Split IO/Sec"

####################  访问方式  ####################
"SQLServer:Access MethodsPage Splits/sec"
"SQLServer:Access MethodsFull Scans/sec"
"SQLServer:Access MethodsRange Scans/sec"
"SQLServer:Access MethodsWorkfiles Created/sec"
"SQLServer:Access MethodsWorktables Created/sec"
"SQLServer:General StatisticsActive Temp Tables"
"SQLServer:General StatisticsTemp Tables Creation Rate"
"SQLServer:General StatisticsLogins/sec"
"SQLServer:General StatisticsLogouts/sec"
"SQLServer:General StatisticsConnection Reset/sec"
"SQLServer:General StatisticsLogical Connections"
"SQLServer:General StatisticsUser Connections"
"SQLServer:SQL StatisticsBatch Requests/sec"
"SQLServer:SQL StatisticsAuto-Param Attempts/sec"
"SQLServer:SQL StatisticsFailed Auto-Params/sec"
"SQLServer:SQL StatisticsForced Parameterizations/sec"
"SQLServer:SQL StatisticsSQL Compilations/sec"
"SQLServer:SQL StatisticsSQL Re-Compilations/sec"

####################  network  ####################
#监控对应的网卡
"Network Interface(Realtek PCIe FE 系列控制器)Current Bandwidth"
"Network Interface(Realtek PCIe FE 系列控制器)Output Queue Length"
"Network Interface(Realtek PCIe FE 系列控制器)Bytes Received/sec"
"Network Interface(Realtek PCIe FE 系列控制器)Bytes Sent/sec"
"Network Interface(Realtek PCIe FE 系列控制器)Packets Received/sec"
"Network Interface(Realtek PCIe FE 系列控制器)Packets Sent/sec"

####################  锁相关  ####################
"SQLServer:LatchesLatch Waits/sec"
"SQLServer:LatchesAverage Latch Wait Time (ms)"
"SQLServer:Locks(_Total)Lock Waits/sec"
"SQLServer:Locks(_Total)Lock Wait Time (ms)"
"SQLServer:Locks(_Total)Average Wait Time (ms)"
"SQLServer:Locks(_Total)Lock Requests/sec"
"SQLServer:Locks(_Total)Lock Timeouts/sec"
"SQLServer:Locks(_Total)Number of Deadlocks/sec"

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!