SQLSERVER性能计数器的简单剖析
程序员文章站
2022-04-08 17:48:47
...
SQLSERVER性能计数器的简单剖析 今晚看了这篇文章： SQL Server 2012新performance counter：非常实用的Batch Resp Statistics 文章里介绍到SQLSERVER2012新的性能计数器Batch Resp Statistics 其实我有一个问题： 当我的电脑里有多个版本的SQLSERVER或者多
SQLSERVER性能计数器的简单剖析
今晚看了这篇文章：SQL Server 2012新performance counter：非常实用的Batch Resp Statistics
文章里介绍到SQLSERVER2012新的性能计数器“Batch Resp Statistics”
其实我有一个问题：当我的电脑里有多个版本的SQLSERVER或者多个SQLSERVER实例，SQLSERVER是怎麽区分不同版本的不同计数器的呢？
比如下面SQL脚本，在SQL2012里执行可以看到新的性能计数器Batch Resp Statistics的信息
1 SELECT [counter_name] , 2 "CPU Time:Total(ms)" , 3 "CPU Time:Requests" , 4 "Elapsed Time:Total(ms)" , 5 "Elapsed Time:Requests" 6 FROM ( SELECT [counter_name] , 7 [instance_name] , 8 [cntr_value] 9 FROM sys.dm_os_performance_counters --计数器视图 10 WHERE OBJECT_NAME LIKE '%Batch Resp Statistics%' 11 ) os_pc PIVOT( AVG([cntr_value]) FOR [instance_name] IN ( "CPU Time:Total(ms)", 12 "CPU Time:Requests", 13 "Elapsed Time:Total(ms)", 14 "Elapsed Time:Requests" ) )AS Pvt;
而在SQL2005里执行上面的SQL语句则什么都查询不到，因为在SQL2005里没有这个计数器
在性能监视器里添加“Batch Resp Statistics”性能计数器
第一步：
第二步：
第三步：
第四步：
MSDN关于sys.dm_os_performance_counters性能计数器视图的描述
http://technet.microsoft.com/zh-cn/library/ms187743(SQL.90).aspx
更新日期： 2007 年 9 月 15 日
为服务器维护的每个性能计数器返回一行。 有关每个性能计数器的信息，请参阅使用 SQL Server 对象。
| 列名 | 数据类型 | 说明 | |
|---|---|---|---|
|
object_name |
nchar(128) |
该计数器所属的类别。 |
|
|
counter_name |
nchar(128) |
计数器的名称。 |
|
|
instance_name |
nchar(128) |
计数器特定实例的名称。 通常包含数据库名称。 |
|
|
cntr_value |
bigint |
计数器的当前值。
对于每秒计数器，该值是累积的。 速率值必须通过对离散时间间隔的值抽样来进行计算。 任何两个连续抽样值之间的差等于针对所使用时间间隔的速率。
|
|
|
cntr_type |
int |
Windows 性能体系结构定义的计数器类型。 有关性能计数器类型的详细信息，请参阅 WMI Performance Counter Types（WMI 性能计数器类型）或 Windows Server 文档。 |
权限
需要对服务器具有 VIEW SERVER STATE 权限。
备注
如果 SQL Server 的安装实例无法显示 Windows 操作系统的性能计数器，请使用下面的 Transact-SQL 查询来确认性能计算器已禁用。
1 SELECT COUNT (*) FROM sys.dm_os_performance_counters
如果返回值为 0 行，则性能计数器已禁用。 此时，您应查看安装日志并搜索错误 3409“请为此实例重新安装 sqlctr.ini，
并确保实例登录帐户具有正确的注册表权限”，该错误表示性能计数器未启用。
紧列在 3409 前的错误应指示导致性能计数器启用失败的根本原因。 有关安装日志文件的详细信息，
请参阅How to: View SQL Server 2005 Setup Log Files。
分析
我的电脑里安装了SQL2005 、SQL2008 SQLEXPRESS版本 、SQL2012
我安装各个SQLSERVER的路径
SQL2005
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
SQL2008 SQLEXPRESS版本
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn
SQL2012
D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Binn
上面三个路径都有一个sqlctr.ini文件
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlctr.ini SQL2005
1 [info] 2 drivername=MSSQLServer 3 trusted= 4 symbolfile=sqlctr.h 5 6 7 [languages] 8 009=English 9 004=Chinese 10 11 12 [text] 13 BUFMGR_OBJECT_009_NAME=SQLServer:Buffer Manager 14 BUFMGR_OBJECT_009_HELP=Statistics related to SQL Servers buffer manager 15 16 17 BUFPART_OBJECT_009_NAME=SQLServer:Buffer Partition 18 BUFPART_OBJECT_009_HELP=Statistics related to SQL Server's buffer partitions 19 20 21 BUFNODE_OBJECT_009_NAME=SQLServer:Buffer Node 22 BUFNODE_OBJECT_009_HELP=Statistics related to SQL Server's buffer pool by NUMA node 23 24 25 GENERAL_OBJECT_009_NAME=SQLServer:General Statistics 26 GENERAL_OBJECT_009_HELP=Server General Statistics 27 28 29 LOCKS_OBJECT_009_NAME=SQLServer:Locks 30 LOCKS_OBJECT_009_HELP=Describes statistics for individual lock server lock requests 31 32 33 DBMGR_OBJECT_009_NAME=SQLServer:Databases 34 DBMGR_OBJECT_009_HELP=This defines a Database manager object for SQL Server 35 36 37 DBMIRRORING_OBJECT_009_NAME=SQLServer:Database Mirroring 38 DBMIRRORING_OBJECT_009_HELP=This defines a Database Mirroring object for SQL Server 39 40 41 LATCH_OBJECT_009_NAME=SQLServer:Latches 42 LATCH_OBJECT_009_HELP=Collects statistics associated with internal server latches 43 44 45 ACCESS_METHODS_OBJECT_009_NAME=SQLServer:Access Methods 46 ACCESS_METHODS_OBJECT_009_HELP=Collects statistics associated with the database server access methods 47 48 49 SQL_ERROR_OBJECT_009_NAME=SQLServer:SQL Errors 50 SQL_ERROR_OBJECT_009_HELP=Statistics about errors in SQL Server 51 52 53 SQL_OBJECT_009_NAME=SQLServer:SQL Statistics 54 SQL_OBJECT_009_HELP=Collects statistics associated with SQL requests 55 56 57 PLAN_CACHE_009_NAME=SQLServer:Plan Cache 58 PLAN_CACHE_009_HELP=This defines cache counters 59 60 61 CURSOR_OBJECT_BY_TYPE_009_NAME=SQLServer:Cursor Manager by Type 62 CURSOR_OBJECT_BY_TYPE_009_HELP=Counters for cursor properties grouped by type 63 64 65 CURSOR_OBJECT_TOTAL_009_NAME=SQLServer:Cursor Manager Total 66 CURSOR_OBJECT_TOTAL_009_HELP=Counters for cursor properties not grouped by type 67 68 69 MEMORY_OBJECT_009_NAME=SQLServer:Memory Manager 70 MEMORY_OBJECT_009_HELP=This defines memory usage. 71 72 73 USER_QUERY_OBJECT_009_NAME=SQLServer:User Settable 74 USER_QUERY_OBJECT_009_HELP=This defines user definable counters 75 76 77 REPLICATION_AGENT_OBJECT_009_NAME=SQLServer:Replication Agents 78 REPLICATION_AGENT_OBJECT_009_HELP=Replication Summary 79 80 81 MERGE_AGENT_OBJECT_009_NAME=SQLServer:Replication Merge 82 MERGE_AGENT_OBJECT_009_HELP=Replication Merge Agent Statistics 83 84 85 LOGREADER_AGENT_OBJECT_009_NAME=SQLServer:Replication Logreader 86 LOGREADER_AGENT_OBJECT_009_HELP=Replication Logreader Agent Statistics 87 88 89 DISTRIBUTION_AGENT_OBJECT_009_NAME=SQLServer:Replication Dist. 90 DISTRIBUTION_AGENT_OBJECT_009_HELP=Replication Distribution Agent Statistics 91 92 93 SNAPSHOT_AGENT_OBJECT_009_NAME=SQLServer:Replication Snapshot 94 SNAPSHOT_AGENT_OBJECT_009_HELP=Replication Snapshot Agent Statistics 95 96 97 BACKUP_DEV_OBJECT_009_NAME=SQLServer:Backup Device 98 BACKUP_DEV_OBJECT_009_HELP=This defines a backup device object for SQL Server 99 100 101 XACT_OBJECT_009_NAME=SQLServer:Transactions 102 XACT_OBJECT_009_HELP=Statistics related to SQL Server transactions. 103 104 105 BROKER_OBJECT_009_NAME=SQLServer:Broker Statistics 106 BROKER_OBJECT_009_HELP=Service Broker Statistics 107 108 109 BROKER_TRANSPORT_OBJECT_009_NAME=SQLServer:Broker/DBM Transport 110 BROKER_TRANSPORT_OBJECT_009_HELP=Service Broker/Database Mirroring Transport Statistics 111 112 113 BROKER_ACTIVATION_OBJECT_009_NAME=SQLServer:Broker Activation 114 BROKER_ACTIVATION_OBJECT_009_HELP=Service Broker Activation 115 116 117 WAITSTATS_OBJECT_009_NAME=SQLServer:Wait Statistics 118 WAITSTATS_OBJECT_009_HELP=Wait Statistics 119 120 121 EXECSTATS_OBJECT_009_NAME=SQLServer:Exec Statistics 122 EXECSTATS_OBJECT_009_HELP=Execution statistics for external calls 123 124 125 SQLCLR_OBJECT_009_NAME=SQLServer:CLR 126 SQLCLR_OBJECT_009_HELP=CLR Execution in SQL Server 127 128 129 METADATAMGR_OBJECT_009_NAME=SQLServer:Catalog Metadata 130 METADATAMGR_OBJECT_009_HELP=This defines a catalog metadata manager object for SQL Server 131 132 133 BUF_CACHE_HIT_RATIO_009_NAME=Buffer cache hit ratio 134 BUF_CACHE_HIT_RATIO_009_HELP=Percentage of pages that were found in the buffer pool without having to incur a read from disk. 135 136 137 BUF_CACHE_RATIO_BASE_009_NAME=Buffer cache hit ratio base 138 BUF_CACHE_RATIO_BASE_009_HELP=Base for prior entry 139 140 141 BUF_PAGE_REQUESTS_009_NAME=Page lookups/sec 142 BUF_PAGE_REQUESTS_009_HELP=Number of requests to find a page in the buffer pool. 143 144 145 BUF_FREELIST_STALLS_009_NAME=Free list stalls/sec 146 BUF_FREELIST_STALLS_009_HELP=Number of requests that had to wait for a free page. 147 148 149 BUF_NUM_FREE_BUFFERS_009_NAME=Free pages 150 BUF_NUM_FREE_BUFFERS_009_HELP=Total number of pages on all free lists. 151 152 153 BUF_COMMITTED_PAGE_COUNT_009_NAME=Total pages 154 BUF_COMMITTED_PAGE_COUNT_009_HELP=Number of pages in the buffer pool (includes database, free, and stolen). 155 156 157 BUF_TARGET_PAGE_COUNT_009_NAME=Target pages 158 BUF_TARGET_PAGE_COUNT_009_HELP=Ideal number of pages in the buffer pool. 159 160 161 BUF_HASHED_PAGE_COUNT_009_NAME=Database pages 162 BUF_HASHED_PAGE_COUNT_009_HELP=Number of pages in the buffer pool with database content. 163 164 165 BUF_RESERVED_PAGE_COUNT_009_NAME=Reserved pages 166 BUF_RESERVED_PAGE_COUNT_009_HELP=Number of buffer pool reserved pages. 167 168 169 BUF_STOLEN_PAGE_COUNT_009_NAME=Stolen pages 170 BUF_STOLEN_PAGE_COUNT_009_HELP=Number of pages used for miscellaneous server purposes (including procedure cache). 171 172 173 BUF_LAZY_WRITES_009_NAME=Lazy writes/sec 174 BUF_LAZY_WRITES_009_HELP=Number of buffers written by buffer manager's lazy writer. 175 176 177 BUF_READAHEAD_PAGES_009_NAME=Readahead pages/sec 178 BUF_READAHEAD_PAGES_009_HELP=Number of pages read in anticipation of use. 179 180 181 BUF_BLOCK_READS_009_NAME=Page reads/sec 182 BUF_BLOCK_READS_009_HELP=Number of physical database page reads issued. 183 184 185 BUF_BLOCK_WRITES_009_NAME=Page writes/sec 186 BUF_BLOCK_WRITES_009_HELP=Number of physical database page writes issued. 187 188 189 BUF_CHECKPOINT_WRITES_009_NAME=Checkpoint pages/sec 190 BUF_CHECKPOINT_WRITES_009_HELP=Number of pages flushed by checkpoint or other operations that require all dirty pages to be flushed. 191 192 193 BUF_AWE_LOOKUP_MAPS_009_NAME=AWE lookup maps/sec 194 BUF_AWE_LOOKUP_MAPS_009_HELP=Number of AWE map calls made for pages found in the buffer pool. 195 196 197 BUF_AWE_STOLEN_MAPS_009_NAME=AWE stolen maps/sec 198 BUF_AWE_STOLEN_MAPS_009_HELP=Number of AWE map calls made for pages stolen from the buffer pool. 199 200 201 BUF_AWE_WRITE_MAPS_009_NAME=AWE write maps/sec 202 BUF_AWE_WRITE_MAPS_009_HELP=Number of AWE map calls made for pages to be written to disk. 203 204 205 BUF_AWE_UNMAP_CALLS_009_NAME=AWE unmap calls/sec 206 BUF_AWE_UNMAP_CALLS_009_HELP=Number of AWE unmap calls. 207 208 209 BUF_AWE_UNMAP_PAGES_009_NAME=AWE unmap pages/sec 210 BUF_AWE_UNMAP_PAGES_009_HELP=Number of AWE pages unmapped. 211 212 213 BUF_LIFE_EXPECTANCY_009_NAME=Page life expectancy 214 BUF_LIFE_EXPECTANCY_009_HELP=Number of seconds a page will stay in the buffer pool without references. 215 216 217 BUFPART_NUM_FREE_BUFFERS_009_NAME=Free pages 218 BUFPART_NUM_FREE_BUFFERS_009_HELP=Number of pages on partition free list. 219 220 221 BUFPART_FREE_BUFFERS_USED_009_NAME=Free list requests/sec 222 BUFPART_FREE_BUFFERS_USED_009_HELP=Number of times a free page was requested. 223 224 225 BUFPART_FREE_BUFFERS_EMPTY_009_NAME=Free list empty/sec 226 BUFPART_FREE_BUFFERS_EMPTY_009_HELP=Number of times a free page was requested and none were available. 227 228 229 BUFNODE_NUM_FREE_BUFFERS_009_NAME=Free pages 230 BUFNODE_NUM_FREE_BUFFERS_009_HELP=Free pages on node. 231 232 233 BUFNODE_COMMITTED_PAGE_COUNT_009_NAME=Total pages 234 BUFNODE_COMMITTED_PAGE_COUNT_009_HELP=Committed pages on node. 235 236 237 BUFNODE_FOREIGN_PAGE_COUNT_009_NAME=Foreign pages 238 BUFNODE_FOREIGN_PAGE_COUNT_009_HELP=Number of pages which are not from NUMA-local memory. 239 240 241 BUFNODE_HASHED_PAGE_COUNT_009_NAME=Database pages 242 BUFNODE_HASHED_PAGE_COUNT_009_HELP=Database pages on node. 243 244 245 BUFNODE_STOLEN_PAGE_COUNT_009_NAME=Stolen pages 246 BUFNODE_STOLEN_PAGE_COUNT_009_HELP=Stolen pages on node. 247 248 249 BUFNODE_TARGET_PAGE_COUNT_009_NAME=Target pages 250 BUFNODE_TARGET_PAGE_COUNT_009_HELP=Target pages on node. 251 252 253 BUFNODE_LIFE_EXPECTANCY_009_NAME=Page life expectancy 254 BUFNODE_LIFE_EXPECTANCY_009_HELP=Number of seconds a page will stay in the buffer pool without references. 255 256 257 GO_TEMP_TABLES_IN_USE_009_NAME=Active Temp Tables 258 GO_TEMP_TABLES_IN_USE_009_HELP=Number of temporary tables/table variables in use 259 260 261 GO_TEMP_TABLES_CREATION_RATE_009_NAME=Temp Tables Creation Rate 262 GO_TEMP_TABLES_CREATION_RATE_009_HELP=Number of temporary tables/table variables created/sec 263 264 265 GO_LOGINS_009_NAME=Logins/sec 266 GO_LOGINS_009_HELP=Total number of logins started per second. 267 268 269 GO_LOGOUTS_009_NAME=Logouts/sec 270 GO_LOGOUTS_009_HELP=Total number of logouts started per second. 271 272 273 GO_USER_CONNECTIONS_009_NAME=User Connections 274 GO_USER_CONNECTIONS_009_HELP=Number of users connected to the system. 275 276 277 GO_LOGICAL_CONNECTIONS_009_NAME=Logical Connections 278 GO_LOGICAL_CONNECTIONS_009_HELP=Number of logical connections to the system. 279 280 281 GO_TRANSACTIONS_009_NAME=Transactions 282 GO_TRANSACTIONS_009_HELP=Number of transaction enlistments (local, dtc, and bound). 283 284 285 GO_NON_ATOMIC_YIELD_RATE_009_NAME=Non-atomic yield rate 286 GO_NON_ATOMIC_YIELD_RATE_009_HELP=Number of non-atomic yields per second. 287 288 289 GO_MARS_DEADLOCKS_DETECTED_009_NAME=Mars Deadlocks 290 GO_MARS_DEADLOCKS_DETECTED_009_HELP=Number of Mars Deadlocks detected. 291 292 293 GO_HTTP_AUTH_REQS_009_NAME=HTTP Authenticated Requests 294 GO_HTTP_AUTH_REQS_009_HELP=Number of authenticated HTTP requests started per second. 295 296 297 GO_SOAP_EMPTY_REQS_009_NAME=SOAP Empty Requests 298 GO_SOAP_EMPTY_REQS_009_HELP=Number of empty SOAP requests started per second. 299 300 301 GO_SOAP_QUERY_REQS_009_NAME=SOAP SQL Requests 302 GO_SOAP_QUERY_REQS_009_HELP=Number of SOAP SQL requests started per second. 303 304 305 GO_SOAP_SP_REQS_009_NAME=SOAP Method Invocations 306 GO_SOAP_SP_REQS_009_HELP=Number of SOAP method invocations started per second. 307 308 309 GO_SOAP_WSDL_REQS_009_NAME=SOAP WSDL Requests 310 GO_SOAP_WSDL_REQS_009_HELP=Number of SOAP Web Service Description Language requests started per second. 311 312 313 GO_SOAP_SESSION_INITIATES_009_NAME=SOAP Session Initiate Requests 314 GO_SOAP_SESSION_INITIATES_009_HELP=Number of SOAP Session initiate requests started per second. 315 316 317 GO_SOAP_SESSION_TERMINATES_009_NAME=SOAP Session Terminate Requests 318 GO_SOAP_SESSION_TERMINATES_009_HELP=Number of SOAP Session terminate requests started per second. 319 320 321 GO_USERS_BLOCKED_009_NAME=Processes blocked 322 GO_USERS_BLOCKED_009_HELP=Number of currently blocked processes. 323 324 325 GO_TEMP_TABLES_FOR_DESTRUCTION_009_NAME=Temp Tables For Destruction 326 GO_TEMP_TABLES_FOR_DESTRUCTION_009_HELP=Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread 327 328 329 GO_EVT_NOTIF_DELAYED_DROP_009_NAME=Event Notifications Delayed Drop 330 GO_EVT_NOTIF_DELAYED_DROP_009_HELP=Number of event notifications waiting to be dropped by a system thread 331 332 333 GO_TRACE_EVT_NOTIF_QUEUE_SIZE_009_NAME=Trace Event Notification Queue 334 GO_TRACE_EVT_NOTIF_QUEUE_SIZE_009_HELP=Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker 335 336 337 GO_TRACE_IO_PROVIDER_EVENTLOCK_009_NAME=SQL Trace IO Provider Lock Waits 338 GO_TRACE_IO_PROVIDER_EVENTLOCK_009_HELP=Number of waits for the File IO Provider lock per second 339 340 341 LCK_NUM_REQUESTS_009_NAME=Lock Requests/sec 342 LCK_NUM_REQUESTS_009_HELP=Number of new locks and lock conversions requested from the lock manager. 343 344 345 LCK_NUM_TIMEOUTS_009_NAME=Lock Timeouts/sec 346 LCK_NUM_TIMEOUTS_009_HELP=Number of lock requests that timed out. This includes requests for NOWAIT locks. 347 348 349 LCK_NUM_DEADLOCKS_009_NAME=Number of Deadlocks/sec 350 LCK_NUM_DEADLOCKS_009_HELP=Number of lock requests that resulted in a deadlock. 351 352 353 LCK_NUM_WAITS_009_NAME=Lock Waits/sec 354 LCK_NUM_WAITS_009_HELP=Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock. 355 356 357 LCK_TOTAL_WAITTIME_009_NAME=Lock Wait Time (ms) 358 LCK_TOTAL_WAITTIME_009_HELP=Total wait time (milliseconds) for locks in the last second. 359 360 361 LCK_AVERAGE_WAITTIME_009_NAME=Average Wait Time (ms) 362 LCK_AVERAGE_WAITTIME_009_HELP=The average amount of wait time (milliseconds) for each lock request that resulted in a wait. 363 364 365 LCK_AVERAGE_WAITTIME_BASE_009_NAME=Average Wait Time Base 366 LCK_AVERAGE_WAITTIME_BASE_009_HELP=Base for Averate Wait Time. 367 368 369 LCK_NUM_TIMEOUTS_NONPROBE_009_NAME=Lock Timeouts (timeout > 0)/sec 370 LCK_NUM_TIMEOUTS_NONPROBE_009_HELP=Number of lock requests that timed out. This does not include requests for NOWAIT locks. 371 372 373 DB_DATA_SIZE_009_NAME=Data File(s) Size (KB) 374 DB_DATA_SIZE_009_HELP=The cumulative size of all the data files in the database. 375 376 377 DB_LOG_SIZE_009_NAME=Log File(s) Size (KB) 378 DB_LOG_SIZE_009_HELP=The cumulative size of all the log files in the database. 379 380 381 DB_LOG_USED_009_NAME=Log File(s) Used Size (KB) 382 DB_LOG_USED_009_HELP=The cumulative used size of all the log files in the database. 383 384 385 DB_LOG_USED_PERCENT_009_NAME=Percent Log Used 386 DB_LOG_USED_PERCENT_009_HELP=The percent of space in the log that is in use. 387 388 389 DB_ACT_XTRAN_009_NAME=Active Transactions 390 DB_ACT_XTRAN_009_HELP=Number of active update transactions for the database. 391 392 393 DB_TOTAL_XTRAN_009_NAME=Transactions/sec 394 DB_TOTAL_XTRAN_009_HELP=Number of transactions started for the database. 395 396 397 DB_REPLTRANS_009_NAME=Repl. Pending Xacts 398 DB_REPLTRANS_009_HELP=Number of pending replication transactions in the database. 399 400 401 DB_REPLCOUNT_009_NAME=Repl. Trans. Rate 402 DB_REPLCOUNT_009_HELP=Replication transaction rate (replicated transactions/sec.). 403 404 405 DB_LOGCACHE_READS_009_NAME=Log Cache Reads/sec 406 DB_LOGCACHE_READS_009_HELP=Reads performed through the log manager cache. 407 408 409 DB_LOGCACHE_RATIO_009_NAME=Log Cache Hit Ratio 410 DB_LOGCACHE_RATIO_009_HELP=Percentage of log cache reads that were satisfied from the log cache. 411 412 413 DB_LOGCACHE_BASE_009_NAME=Log Cache Hit Ratio Base 414 DB_LOGCACHE_BASE_009_HELP=Base for log cache calculations 415 416 417 DB_BULK_ROWS_009_NAME=Bulk Copy Rows/sec 418 DB_BULK_ROWS_009_HELP=Number of rows bulk copied. 419 420 421 DB_BULK_KILOBYTES_009_NAME=Bulk Copy Throughput/sec 422 DB_BULK_KILOBYTES_009_HELP=KiloBytes bulk copied. 423 424 425 DB_BCK_DB_THROUGHPUT_009_NAME=Backup/Restore Throughput/sec 426 DB_BCK_DB_THROUGHPUT_009_HELP=Read/write throughput for backup/restore of a database. 427 428 429 DB_DBCC_SCANRATE_009_NAME=DBCC Logical Scan Bytes/sec 430 DB_DBCC_SCANRATE_009_HELP=Logical read scan rate for DBCC commands 431 432 433 DB_DBCC_MOVERATE_009_NAME=Shrink Data Movement Bytes/sec 434 DB_DBCC_MOVERATE_009_HELP=The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE. 435 436 437 DB_FLUSHES_009_NAME=Log Flushes/sec 438 DB_FLUSHES_009_HELP=Number of log flushes. 439 440 441 DB_BYTES_FLUSHED_009_NAME=Log Bytes Flushed/sec 442 DB_BYTES_FLUSHED_009_HELP=Total number of log bytes flushed. 443 444 445 DB_FLUSH_WAITS_009_NAME=Log Flush Waits/sec 446 DB_FLUSH_WAITS_009_HELP=Number of commits waiting on log flush. 447 448 449 DB_FLUSH_WAIT_TIME_009_NAME=Log Flush Wait Time 450 DB_FLUSH_WAIT_TIME_009_HELP=Total wait time (milliseconds). 451 452 453 DB_LOG_TRUNCS_009_NAME=Log Truncations 454 DB_LOG_TRUNCS_009_HELP=Total number of log truncations for this database. 455 456 457 DB_LOG_GROWTHS_009_NAME=Log Growths 458 DB_LOG_GROWTHS_009_HELP=Total number of log growths for this database. 459 460 461 DB_LOG_SHRINKS_009_NAME=Log Shrinks 462 DB_LOG_SHRINKS_009_HELP=Total number of log shrinks for this database. 463 464 465 DB_DBMIRRORING_BYTES_SENT_009_NAME=Bytes Sent/sec 466 DB_DBMIRRORING_BYTES_SENT_009_HELP=Number of bytes sent per second 467 468 469 DB_DBMIRRORING_PAGES_SENT_009_NAME=Pages Sent/sec 470 DB_DBMIRRORING_PAGES_SENT_009_HELP=Number of pages sent per second 471 472 473 DB_DBMIRRORING_SENDS_009_NAME=Sends/sec 474 DB_DBMIRRORING_SENDS_009_HELP=Number of sends initiated per second 475 476 477 DB_DBMIRRORING_TRANSACTION_DELAY_009_NAME=Transaction Delay 478 DB_DBMIRRORING_TRANSACTION_DELAY_009_HELP=Average delay in transaction termination waiting for acknowledgement 479 480 481 DB_DBM_REDO_DELTA_009_NAME=Redo Queue KB 482 DB_DBM_REDO_DELTA_009_HELP=Total number of kilobytes that redo on the mirror database is behind the hardened log 483 484 485 DB_DBM_REDO_RATE_009_NAME=Redo Bytes/sec 486 DB_DBM_REDO_RATE_009_HELP=Number of bytes of log redone by the mirror database per second 487 488 489 DB_DBM_LOG_SEND_QUEUE_009_NAME=Log Send Queue KB 490 DB_DBM_LOG_SEND_QUEUE_009_HELP=Total number of kilobytes of log that have not been sent to the mirror server 491 492 493 DB_DBM_BYTES_RECEIVED_009_NAME=Bytes Received/sec 494 DB_DBM_BYTES_RECEIVED_009_HELP=Number of bytes received per second 495 496 497 DB_DBM_RECEIVES_009_NAME=Receives/sec 498 DB_DBM_RECEIVES_009_HELP=Number of mirroring message receives per second 499 500 501 DB_DBM_LOG_BYTES_RECEIVED_009_NAME=Log Bytes Received/sec 502 DB_DBM_LOG_BYTES_RECEIVED_009_HELP=Number of bytes of log received per second 503 504 505 DB_DBM_LOG_BYTES_SENT_009_NAME=Log Bytes Sent/sec 506 DB_DBM_LOG_BYTES_SENT_009_HELP=Number of bytes of log sent per second 507 508 509 DB_DBM_ACK_TIME_009_NAME=Send/Receive Ack Time 510 DB_DBM_ACK_TIME_009_HELP=Milliseconds packets waited in flow control per second. 511 512 513 LATCH_WAITS_NP_009_NAME=Latch Waits/sec 514 LATCH_WAITS_NP_009_HELP=Number of latch requests that could not be granted immediately and had to wait before being granted. 515 516 517 LATCH_AVG_WAIT_NP_009_NAME=Average Latch Wait Time (ms) 518 LATCH_AVG_WAIT_NP_009_HELP=Average latch wait time (milliseconds) for latch requests that had to wait. 519 520 521 LATCH_AVG_WAIT_BASE_009_NAME=Average Latch Wait Time Base 522 LATCH_AVG_WAIT_BASE_009_HELP=Base for Average Latch Wait Time. 523 524 525 LATCH_TOTAL_WAIT_NP_009_NAME=Total Latch Wait Time (ms) 526 LATCH_TOTAL_WAIT_NP_009_HELP=Total latch wait time (milliseconds) for latch requests that had to wait in the last second. 527 528 529 LATCH_SUPERLATCHES_009_NAME=Number of SuperLatches 530 LATCH_SUPERLATCHES_009_HELP=Number of latches that are currently SuperLatches. 531 532 533 LATCH_PROMOTIONS_009_NAME=SuperLatch Promotions/sec 534 LATCH_PROMOTIONS_009_HELP=Number of latches that have been promoted to SuperLatches 535 536 537 LATCH_DEMOTIONS_009_NAME=SuperLatch Demotions/sec 538 LATCH_DEMOTIONS_009_HELP=Number of SuperLatches that have been demoted to regular latches 539 540 541 AM_FULL_SCAN_009_NAME=Full Scans/sec 542 AM_FULL_SCAN_009_HELP=Number of unrestricted full scans. These can either be base table or full index scans. 543 544 545 AM_RANGE_SCAN_009_NAME=Range Scans/sec 546 AM_RANGE_SCAN_009_HELP=Number of qualified range scans through indexes per second. 547 548 549 AM_PROBE_SCAN_009_NAME=Probe Scans/sec 550 AM_PROBE_SCAN_009_HELP=Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. 551 552 553 AM_SCAN_REPOSITION_009_NAME=Scan Point Revalidations/sec 554 AM_SCAN_REPOSITION_009_HELP=Number of times the scan point had to be revalidated to continue the scan. 555 556 557 AM_WORKFILES_CREATED_009_NAME=Workfiles Created/sec 558 AM_WORKFILES_CREATED_009_HELP=Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates. 559 560 561 AM_WORKTABLES_CREATED_009_NAME=Worktables Created/sec 562 AM_WORKTABLES_CREATED_009_HELP=Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors. 563 564 565 AM_WORKTABLES_FROM_CACHE_009_NAME=Worktables From Cache Ratio 566 AM_WORKTABLES_FROM_CACHE_009_HELP=Percentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache. 567 568 569 AM_WORKTABLES_FROM_CACHE_BASE_009_NAME=Worktables From Cache Base 570 AM_WORKTABLES_FROM_CACHE_BASE_009_HELP=Percent of worktables from cache base. 571 572 573 AM_FORWARDED_RECS_009_NAME=Forwarded Records/sec 574 AM_FORWARDED_RECS_009_HELP=Number of records fetched through forwarded record pointers. 575 576 577 AM_GHOSTED_SKIPS_009_NAME=Skipped Ghosted Records/sec 578 AM_GHOSTED_SKIPS_009_HELP=Number of ghosted records per second skipped during scans. 579 580 581 AM_INDEX_SEARCHES_009_NAME=Index Searches/sec 582 AM_INDEX_SEARCHES_009_HELP=Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index. 583 584 585 AM_FREESPACE_SCANS_009_NAME=FreeSpace Scans/sec 586 AM_FREESPACE_SCANS_009_HELP=Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. Each scan may find multiple pages. 587 588 589 AM_FREESPACE_PAGES_009_NAME=FreeSpace Page Fetches/sec 590 AM_FREESPACE_PAGES_009_HELP=Number of pages fetched per second by free space scans. These scans search for free space within pages already allocated to an allocation unit, to satisfy requests to insert or modify record fragments. 591 592 593 AM_PAGES_ALLOCATED_009_NAME=Pages Allocated/sec 594 AM_PAGES_ALLOCATED_009_HELP=Number of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents. 595 596 597 AM_EXTENTS_ALLOCATED_009_NAME=Extents Allocated/sec 598 AM_EXTENTS_ALLOCATED_009_HELP=Number of extents allocated per second in all databases in this SQL Server instance. 599 600 601 AM_SINGLE_PAGE_ALLOCS_009_NAME=Mixed page allocations/sec 602 AM_SINGLE_PAGE_ALLOCS_009_HELP=Number of pages allocated per second from mixed extents. These could be used for storing the IAM pages and the first eight pages that are allocated to an allocation unit. 603 604 605 AM_EXTENTS_DEALLOCATED_009_NAME=Extent Deallocations/sec 606 AM_EXTENTS_DEALLOCATED_009_HELP=Number of extents deallocated per second in all databases in this SQL Server instance. 607 608 609 AM_PAGE_DEALLOCS_009_NAME=Page Deallocations/sec 610 AM_PAGE_DEALLOCS_009_HELP=Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents. 611 612 613 AM_PAGE_SPLITS_009_NAME=Page Splits/sec 614 AM_PAGE_SPLITS_009_HELP=Number of page splits per second that occur as a result of overflowing index pages. 615 616 617 AM_LOCKESCALATIONS_009_NAME=Table Lock Escalations/sec 618 AM_LOCKESCALATIONS_009_HELP=The number of times locks on a table were escalated. 619 620 621 AM_DEFDROPPEDROWSETQUEUELENGTH_009_NAME=Deferred Dropped rowsets 622 AM_DEFDROPPEDROWSETQUEUELENGTH_009_HELP=The number of rowsets created as a result of aborted online index build operations that are waiting to be dropped by the background task that cleans up deferred dropped rowsets. 623 624 625 AM_DEFDROPPEDROWSETSCLEANED_009_NAME=Dropped rowset cleanups/sec 626 AM_DEFDROPPEDROWSETSCLEANED_009_HELP=The number of rowsets per second created as a result of aborted online index build operations that were successfully dropped by the background task that cleans up deferred dropped rowsets. 627 628 629 AM_DEFDROPPEDROWSETSSKIPPED_009_NAME=Dropped rowsets skipped/sec 630 AM_DEFDROPPEDROWSETSSKIPPED_009_HELP=The number of rowsets per second created as a result of aborted online index build operations that were skipped by the background task that cleans up deferred dropped rowsets created. 631 632 633 AM_DDALLOCUNITQUEUELENGTH_009_NAME=Deferred dropped AUs 634 AM_DDALLOCUNITQUEUELENGTH_009_HELP=The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units. 635 636 637 AM_DDALLOCUNITSCLEANED_009_NAME=AU cleanups/sec 638 AM_DDALLOCUNITSCLEANED_009_HELP=The number of allocation units per second that were successfully dropped by the background task that cleans up deferred dropped allocation units. Each allocation unit drop requires multiple batches. 639 640 641 AM_DDALLOCUNITBATCHESCOMPLETED_009_NAME=AU cleanup batches/sec 642 AM_DDALLOCUNITBATCHESCOMPLETED_009_HELP=The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units. 643 644 645 AM_DDALLOCUNITBATCHESFAILED_009_NAME=Failed AU cleanup batches/sec 646 AM_DDALLOCUNITBATCHESFAILED_009_HELP=The number of batches per second that failed and required retry, by the background task that cleans up deferred dropped allocation units. Failure could be due to lack of memory or disk space, hardware failure and other reasons. 647 648 649 TREE_PAGE_COOKIE_SUCCEED_009_NAME=Used tree page cookie 650 TREE_PAGE_COOKIE_SUCCEED_009_HELP=Number of times a tree page cookie was used successfully during an index search since no change happened on the parent page of the tree page. The cookie is used to speed up index search. 651 652 653 TREE_PAGE_COOKIE_FAIL_009_NAME=Failed tree page cookie 654 TREE_PAGE_COOKIE_FAIL_009_HELP=The number of times that a tree page cookie could not be used during an index search since changes happened on the parent pages of those tree pages. The cookie is used to speed up index search. 655 656 657 LEAF_PAGE_COOKIE_SUCCEED_009_NAME=Used leaf page cookie 658 LEAF_PAGE_COOKIE_SUCCEED_009_HELP=Number of times a leaf page cookie was used successfully during an index search since no change happened on the leaf page. The cookie is used to speed up index search. 659 660 661 LEAF_PAGE_COOKIE_FAIL_009_NAME=Failed leaf page cookie 662 LEAF_PAGE_COOKIE_FAIL_009_HELP=The number of times that a leaf page cookie could not be used during an index search since changes happened on the leaf page. The cookie is used to speed up index search. 663 664 665 AM_LOBSS_PROVIDERS_CREATED_009_NAME=LobSS Provider Create Count 666 AM_LOBSS_PROVIDERS_CREATED_009_HELP=Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider. 667 668 669 AM_LOBSS_PROVIDERS_DESTROYED_009_NAME=LobSS Provider Destroy Count 670 AM_LOBSS_PROVIDERS_DESTROYED_009_HELP=Count of LOB Storage Service Providers destroyed. 671 672 673 AM_LOBSS_PROVIDERS_TRUNCATED_009_NAME=LobSS Provider Truncation Count 674 AM_LOBSS_PROVIDERS_TRUNCATED_009_HELP=Count of LOB Storage Service Providers truncated. 675 676 677 AM_LOBSS_LOBHANDLES_CREATED_009_NAME=LobHandle Create Count 678 AM_LOBSS_LOBHANDLES_CREATED_009_HELP=Count of temporary LOBs created. 679 680 681 AM_LOBSS_LOBHANDLES_DESTROYED_009_NAME=LobHandle Destroy Count 682 AM_LOBSS_LOBHANDLES_DESTROYED_009_HELP=Count of temporary LOBs destroyed. 683 684 685 AM_ORPHANS_CREATED_009_NAME=By-reference Lob Create Count 686 AM_ORPHANS_CREATED_009_HELP=Count of large object (LOB) values that were passed by reference. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value. 687 688 689 AM_ORPHANS_INSERTED_009_NAME=By-reference Lob Use Count 690 AM_ORPHANS_INSERTED_009_HELP=Count of by-reference lob values that were used. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value. 691 692 693 AM_COLS_PUSHED_OFFROW_009_NAME=Count Push Off Row 694 AM_COLS_PUSHED_OFFROW_009_HELP=Count of values that were pushed from in-row to off-row. 695 696 697 AM_COLS_PULLED_INROW_009_NAME=Count Pull In Row 698 AM_COLS_PULLED_INROW_009_HELP=Count of values that were pulled in-row from off-row. 699 700 701 AM_LOB_READAHEAD_ISSUED_009_NAME=Count Lob Readahead 702 AM_LOB_READAHEAD_ISSUED_009_HELP=Count of lob pages on which readahead was issued. 703 704 705 SQL_ERROR_RATE_009_NAME=Errors/sec 706 SQL_ERROR_RATE_009_HELP=Number of errors/sec 707 708 709 SQL_BATCH_REQ_009_NAME=Batch Requests/sec 710 SQL_BATCH_REQ_009_HELP=Number of SQL batch requests received by server. 711 712 713 SQL_UNIVPARAM_009_NAME=Forced Parameterizations/sec 714 SQL_UNIVPARAM_009_HELP=Number of statements parameterized by forced parameterization per second. 715 716 717 SQL_AUTOPARAM_REQ_009_NAME=Auto-Param Attempts/sec 718 SQL_AUTOPARAM_REQ_009_HELP=Number of auto-parameterization attempts. 719 720 721 SQL_AUTOPARAM_FAIL_009_NAME=Failed Auto-Params/sec 722 SQL_AUTOPARAM_FAIL_009_HELP=Number of failed auto-parameterizations. 723 724 725 SQL_AUTOPARAM_SAFE_009_NAME=Safe Auto-Params/sec 726 SQL_AUTOPARAM_SAFE_009_HELP=Number of safe auto-parameterizations. 727 728 729 SQL_AUTOPARAM_UNSAFE_009_NAME=Unsafe Auto-Params/sec 730 SQL_AUTOPARAM_UNSAFE_009_HELP=Number of unsafe auto-parameterizations. 731 732 733 SQL_COMPILES_009_NAME=SQL Compilations/sec 734 SQL_COMPILES_009_HELP=Number of SQL compilations. 735 736 737 SQL_RECOMPILES_009_NAME=SQL Re-Compilations/sec 738 SQL_RECOMPILES_009_HELP=Number of SQL re-compiles. 739 740 741 SQL_ATTENTION_RATE_009_NAME=SQL Attention rate 742 SQL_ATTENTION_RATE_009_HELP=Number of attentions per second. 743 744 745 PLAN_CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio 746 PLAN_CACHE_HIT_RATIO_009_HELP=Ratio between cache hits and lookups 747 748 749 PLAN_CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base 750 PLAN_CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry 751 752 753 PLAN_CACHE_PGS_IN_USE_009_NAME=Cache Pages 754 PLAN_CACHE_PGS_IN_USE_009_HELP=Number of 8k pages used by cache objects 755 756 757 PLAN_CACHE_OBJECT_COUNT_009_NAME=Cache Object Counts 758 PLAN_CACHE_OBJECT_COUNT_009_HELP=Number of cache objects in the cache 759 760 761 PLAN_CACHE_USE_COUNT_009_NAME=Cache Objects in use 762 PLAN_CACHE_USE_COUNT_009_HELP=Number of cache objects in use 763 764 765 CURSOR_CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio 766 CURSOR_CACHE_HIT_RATIO_009_HELP=Ratio between cache hits and lookups 767 768 769 CURSOR_CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base 770 CURSOR_CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry 771 772 773 CURSOR_CACHE_COUNT_009_NAME=Cached Cursor Counts 774 CURSOR_CACHE_COUNT_009_HELP=Number of cursors of a given type in the cache 775 776 777 CURSOR_CACHE_USE_COUNT_009_NAME=Cursor Cache Use Counts/sec 778 CURSOR_CACHE_USE_COUNT_009_HELP=Times each type of cached cursor has been used 779 780 781 CURSOR_REQ_009_NAME=Cursor Requests/sec 782 CURSOR_REQ_009_HELP=Number of SQL cursor requests received by server. 783 784 785 CURSOR_IN_USE_009_NAME=Active cursors 786 CURSOR_IN_USE_009_HELP=Number of active cursors. 787 788 789 CURSOR_MEMORY_USAGE_009_NAME=Cursor memory usage 790 CURSOR_MEMORY_USAGE_009_HELP=Amount of memory consumed by cursors (KB). 791 792 793 CURSOR_WORKTABLE_USAGE_009_NAME=Cursor worktable usage 794 CURSOR_WORKTABLE_USAGE_009_HELP=Number of worktables used by cursors. 795 796 797 CURSOR_PLANS_009_NAME=Number of active cursor plans 798 CURSOR_PLANS_009_HELP=Number of cursor plans. 799 800 801 CURSOR_CONVERSION_RATE_009_NAME=Cursor conversion rate 802 CURSOR_CONVERSION_RATE_009_HELP=Number of cursor conversions/sec. 803 804 805 CURSOR_ASYNC_POPULATION_009_NAME=Async population count 806 CURSOR_ASYNC_POPULATION_009_HELP=Number of cursors being populated asynchronously. 807 808 809 CURSOR_XSTMT_FLUSH_009_NAME=Cursor flushes 810 CURSOR_XSTMT_FLUSH_009_HELP=Total number of times a flush for a cursor xstmt occured. 811 812 813 MEMORY_CONNECTION_MEMORY_009_NAME=Connection Memory (KB) 814 MEMORY_CONNECTION_MEMORY_009_HELP=Total amount of dynamic memory the server is using for maintaining connections 815 816 817 MEMORY_MEMGRANT_OUTSTANDING_009_NAME=Granted Workspace Memory (KB) 818 MEMORY_MEMGRANT_OUTSTANDING_009_HELP=Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. 819 820 821 MEMORY_LOCK_MEMORY_009_NAME=Lock Memory (KB) 822 MEMORY_LOCK_MEMORY_009_HELP=Total amount of dynamic memory the server is using for locks 823 824 825 MEMORY_LOCKS_ALLOCATED_009_NAME=Lock Blocks Allocated 826 MEMORY_LOCKS_ALLOCATED_009_HELP=The current number of allocated lock blocks. 827 828 829 MEMORY_LOCKOWNERS_ALLOCATED_009_NAME=Lock Owner Blocks Allocated 830 MEMORY_LOCKOWNERS_ALLOCATED_009_HELP=The current number of allocated lock owner blocks. 831 832 833 MEMORY_LOCKS_009_NAME=Lock Blocks 834 MEMORY_LOCKS_009_HELP=The current number of lock blocks that are in use on the server. Refreshed periodically. 835 836 837 MEMORY_LOCKOWNERS_009_NAME=Lock Owner Blocks 838 MEMORY_LOCKOWNERS_009_HELP=The number of lock owner blocks that are currently in use on the server. Refreshed periodically. 839 840 841 MEMORY_MEMGRANT_MAXIMUM_009_NAME=Maximum Workspace Memory (KB) 842 MEMORY_MEMGRANT_MAXIMUM_009_HELP=Total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations. 843 844 845 MEMORY_MEMGRANT_ACQUIRES_009_NAME=Memory Grants Outstanding 846 MEMORY_MEMGRANT_ACQUIRES_009_HELP=Current number of processes that have successfully acquired a workspace memory grant 847 848 849 MEMORY_MEMGRANT_WAITERS_009_NAME=Memory Grants Pending 850 MEMORY_MEMGRANT_WAITERS_009_HELP=Current number of processes waiting for a workspace memory grant 851 852 853 MEMORY_OPTIMIZER_MEMORY_009_NAME=Optimizer Memory (KB) 854 MEMORY_OPTIMIZER_MEMORY_009_HELP=Total amount of dynamic memory the server is using for query optimization 855 856 857 MEMORY_SQL_CACHE_MEMORY_009_NAME=SQL Cache Memory (KB) 858 MEMORY_SQL_CACHE_MEMORY_009_HELP=Total amount of dynamic memory the server is using for the dynamic SQL cache 859 860 861 MEMORY_SERVER_MEMORY_TARGET_009_NAME=Target Server Memory (KB) 862 MEMORY_SERVER_MEMORY_TARGET_009_HELP=Total amount of dynamic memory the server is willing to consume 863 864 865 MEMORY_SERVER_MEMORY_009_NAME=Total Server Memory (KB) 866 MEMORY_SERVER_MEMORY_009_HELP=Total amount of dynamic memory the server is currently consuming 867 868 869 QUERY_INSTANCE_009_NAME=Query 870 QUERY_INSTANCE_009_HELP=As defined by the user. 871 872 873 RUNNING_INSTANCE_009_NAME=Running 874 RUNNING_INSTANCE_009_HELP=The number of replication agents currently running. 875 876 877 UPLOAD_INSTANCE_009_NAME=Uploaded Changes/sec 878 UPLOAD_INSTANCE_009_HELP=The number of rows per second merged from the Subscriber to the Publisher. 879 880 881 DOWNLOAD_INSTANCE_009_NAME=Downloaded Changes/sec 882 DOWNLOAD_INSTANCE_009_HELP=The number of rows per second merged from the Publisher to the Subscriber. 883 884 885 MERGE_CONFLICTS_INSTANCE_009_NAME=Conflicts/sec 886 MERGE_CONFLICTS_INSTANCE_009_HELP=The number of conflicts per second occurring during the merge process. 887 888 889 LOGREADER_LATENCY_INSTANCE_009_NAME=Logreader:Delivery Latency 890 LOGREADER_LATENCY_INSTANCE_009_HELP=The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor. 891 892 893 LOGREADER_COMMANDS_INSTANCE_009_NAME=Logreader:Delivered Cmds/sec 894 LOGREADER_COMMANDS_INSTANCE_009_HELP=The number of commands per second delivered to the Distributor. 895 896 897声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。