SQLServer 基线跟踪指标

概述基线收集参考：SQLServer Windows数据收集器 #################### CPU相关 ####################"\Processor(_Total)\% User Time""\Processor(_Total)\% Processor Time""\Processor(_Total)\% Interrupt Time""\Processor

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

####################  cpu相关  ####################"\Processor(_Total)\% User Time""\Processor(_Total)\% Processor Time""\Processor(_Total)\% Interrupt Time""\Processor(_Total)\% Privileged Time""\Sy@R_301_6563@\Context Switches/sec""\Sy@R_301_6563@\Processor Queue Length""\Sy@R_301_6563@\Processes""\Sy@R_301_6563@\Threads"####################  内存相关  ####################"\Paging file(\??\C:\pagefile.sys)\% Usage""\Paging file(\??\C:\pagefile.sys)\% Usage Peak""\Memory\Pages/sec""\Memory\Page Faults/sec""\Memory\Available MBytes""\sqlServer:Buffer Manager\Buffer cache hit ratio""\sqlServer:Buffer Manager\Lazy writes/sec""\sqlServer:Buffer Manager\Page life expectancy""\sqlServer:Buffer Manager\Checkpoint pages/sec""\sqlServer:Buffer Manager\Total pages""\sqlServer:Buffer Manager\Target pages""\sqlServer:Memory Manager\Target Server Memory (KB)""\sqlServer:Memory Manager\Total Server Memory (KB)""\sqlServer:Memory Manager\Database Cache Memory (KB)""\sqlServer:Memory Manager\Connection Memory (KB)""\sqlServer:Memory Manager\Granted Workspace Memory (KB)""\sqlServer:Memory Manager\Lock Memory (KB)""\sqlServer:Memory Manager\Memory Grants Pending""\sqlServer:Memory Manager\Optimizer Memory (KB)""\sqlServer:Memory Manager\sql Cache Memory (KB)""\sqlServer:Memory Manager\Stolen 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 Methods\Page Splits/sec""\sqlServer:Access Methods\Full Scans/sec""\sqlServer:Access Methods\Range Scans/sec""\sqlServer:Access Methods\Workfiles Created/sec""\sqlServer:Access Methods\Worktables Created/sec""\sqlServer:General Statistics\Active Temp tables""\sqlServer:General Statistics\Temp tables Creation Rate""\sqlServer:General Statistics\Logins/sec""\sqlServer:General Statistics\logouts/sec""\sqlServer:General Statistics\Connection reset/sec""\sqlServer:General Statistics\Logical Connections""\sqlServer:General Statistics\User Connections""\sqlServer:sql Statistics\Batch Requests/sec""\sqlServer:sql Statistics\auto-Param Attempts/sec""\sqlServer:sql Statistics\Failed auto-Params/sec""\sqlServer:sql Statistics\Forced Parameterizations/sec""\sqlServer:sql Statistics\sql Compilations/sec""\sqlServer:sql Statistics\sql 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:Latches\Latch Waits/sec""\sqlServer:Latches\Average 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"

（个人整理，仅供参考） 总结

以上是内存溢出为你收集整理的SQLServer 基线跟踪指标全部内容，希望文章能够帮你解决SQLServer 基线跟踪指标所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。