C:\Windows\inf\MSSQLServer路径下的SQLSERVER配置文件
C:\Windows\inf\MSSQLServer路径下的SQLSERVER配置文件
perf-MSSQLSERVERsqlctr.ini
1 [info] 2 drivername=MSSQLServer 3 trusted= 4 symbolfile=c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\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 LOGREADER_TRANSACTIONS_INSTANCE_009_NAME=Logreader:Delivered Trans/sec 898 LOGREADER_TRANSACTIONS_INSTANCE_009_HELP=The number of transactions per second delivered to the Distributor. 899 900 901 DISTRIBUTION_LATENCY_INSTANCE_009_NAME=Dist:Delivery Latency 902 DISTRIBUTION_LATENCY_INSTANCE_009_HELP=The current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber. 903 904 905 DISTRIBUTION_COMMANDS_INSTANCE_009_NAME=Dist:Delivered Cmds/sec 906 DISTRIBUTION_COMMANDS_INSTANCE_009_HELP=The number of commands per second delivered to the Subscriber. 907 908 909 DISTRIBUTION_TRANS_INSTANCE_009_NAME=Dist:Delivered Trans/sec 910 DISTRIBUTION_TRANS_INSTANCE_009_HELP=The number of transactions per second delivered to the Subscriber. 911 912 913 SNAPSHOT_COMMANDS_BCPED_009_NAME=Snapshot:Delivered Cmds/sec 914 SNAPSHOT_COMMANDS_BCPED_009_HELP=The number of commands per second delivered to the Distributor. 915 916 917 SNAPSHOT_TRANSACTIONS_BCPED_009_NAME=Snapshot:Delivered Trans/sec 918 SNAPSHOT_TRANSACTIONS_BCPED_009_HELP=The number of transactions per second delivered to the Distributor. 919 920 921 DB_BCK_DEV_THROUGHPUT_009_NAME=Device Throughput Bytes/sec 922 DB_BCK_DEV_THROUGHPUT_009_HELP=Read/write throughput for a backup device. 923 924 925 XACT_NUM_009_NAME=Transactions 926 XACT_NUM_009_HELP=The total number of active transactions. 927 928 929 XACT_SNP_NUM_009_NAME=Snapshot Transactions 930 XACT_SNP_NUM_009_HELP=The total number of active snapshot transactions. 931 932 933 XACT_UPD_SNP_NUM_009_NAME=Update Snapshot Transactions 934 XACT_UPD_SNP_NUM_009_HELP=The total number of active snapshot transactions that do updates. 935 936 937 XACT_NSNP_VER_NUM_009_NAME=NonSnapshot Version Transactions 938 XACT_NSNP_VER_NUM_009_HELP=The total number of active non-snapshot transactions that generate version records. 939 940 941 XACT_LONGEST_RUNNING_009_NAME=Longest Transaction Running Time 942 XACT_LONGEST_RUNNING_009_HELP=The longest running time of any transcation in seconds. 943 944 945 XACT_UPD_CONFLICTS_RATIO_009_NAME=Update conflict ratio 946 XACT_UPD_CONFLICTS_RATIO_009_HELP=The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions. 947 948 949 XACT_UPD_CONFLICTS_RATIO_BASE_009_NAME=Update conflict ratio base 950 XACT_UPD_CONFLICTS_RATIO_BASE_009_HELP=The total number of update snapshot transactions. 951 952 953 XACT_TEMPDB_FREE_SPACE_009_NAME=Free Space in tempdb (KB) 954 XACT_TEMPDB_FREE_SPACE_009_HELP=The free space in tempdb in KB. 955 956 957 XACT_VER_STORE_GEN_RATE_009_NAME=Version Generation rate (KB/s) 958 XACT_VER_STORE_GEN_RATE_009_HELP=The version generation rate in KB per seconds. 959 960 961 XACT_VER_STORE_CLEANUP_RATE_009_NAME=Version Cleanup rate (KB/s) 962 XACT_VER_STORE_CLEANUP_RATE_009_HELP=The version cleanup rate in KB per seconds. 963 964 965 XACT_VER_STORE_SIZE_009_NAME=Version Store Size (KB) 966 XACT_VER_STORE_SIZE_009_HELP=The size of the version store in KB. 967 968 969 XACT_VER_STORE_UNIT_COUNT_009_NAME=Version Store unit count 970 XACT_VER_STORE_UNIT_COUNT_009_HELP=Number of unit in Version Store. 971 972 973 XACT_VER_STORE_UNIT_CREATION_009_NAME=Version Store unit creation 974 XACT_VER_STORE_UNIT_CREATION_009_HELP=Creation of new unit in Version Store. 975 976 977 XACT_VER_STORE_UNIT_TRUNCATION_009_NAME=Version Store unit truncation 978 XACT_VER_STORE_UNIT_TRUNCATION_009_HELP=Truncation of unit in Version Store. 979 980 981 BO_SEND_RATE_009_NAME=SQL SENDs/sec 982 BO_SEND_RATE_009_HELP=The number of SQL SEND commands processed by the Broker per second. 983 984 985 BO_TOTAL_SENDS_009_NAME=SQL SEND Total 986 BO_TOTAL_SENDS_009_HELP=Total number of SQL SEND commands processed by the Broker. 987 988 989 BO_RECEIVE_RATE_009_NAME=SQL RECEIVEs/sec 990 BO_RECEIVE_RATE_009_HELP=The number of SQL RECEIVE commands processed by the Broker per second. 991 992 993 BO_TOTAL_RECEIVES_009_NAME=SQL RECEIVE Total 994 BO_TOTAL_RECEIVES_009_HELP=Total number of SQL RECEIVE commands processed by the Broker. 995 996 997 BO_XACT_ROLLBACKS_009_NAME=Broker Transaction Rollbacks 998 BO_XACT_ROLLBACKS_009_HELP=The number of Service Broker related transactions that have rolled back. 999 1000 1001 BO_DEP_TIMER_EVENTS_009_NAME=Dialog Timer Event Count 1002 BO_DEP_TIMER_EVENTS_009_HELP=The number of dialog endpoint related timer events in the Broker. 1003 1004 1005 BO_ENQUEUED_MSG_RATE_009_NAME=Enqueued Messages/sec 1006 BO_ENQUEUED_MSG_RATE_009_HELP=The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second. 1007 1008 1009 BO_ENQUEUED_LOCAL_MSG_RATE_009_NAME=Enqueued Local Messages/sec 1010 BO_ENQUEUED_LOCAL_MSG_RATE_009_HELP=The number of messages from local endpoints that are successfully delivered as ready into queues per second. 1011 1012 1013 BO_ENQUEUED_TRANSPORT_MSG_RATE_009_NAME=Enqueued Transport Msgs/sec 1014 BO_ENQUEUED_TRANSPORT_MSG_RATE_009_HELP=The number of messages from the transport that are successfully delivered as ready into queues per second. 1015 1016 1017 BO_ENQUEUED_TRANSPORT_FRAG_RATE_009_NAME=Enqueued Transport Msg Frags/sec 1018 BO_ENQUEUED_TRANSPORT_FRAG_RATE_009_HELP=The number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled. 1019 1020 1021 BO_ENQUEUED_MSGS_TOTAL_009_NAME=Enqueued Messages Total 1022 BO_ENQUEUED_MSGS_TOTAL_009_HELP=Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues. 1023 1024 1025 BO_ENQUEUED_LOCAL_MSGS_TOTAL_009_NAME=Enqueued Local Messages Total 1026 BO_ENQUEUED_LOCAL_MSGS_TOTAL_009_HELP=Total number of message fragments from local endpoints that are successfully delivered as ready into queues. 1027 1028 1029 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_009_NAME=Enqueued Transport Msgs Total 1030 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_009_HELP=Total number of messages from the transport that are successfully delivered as ready into queues. 1031 1032 1033 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_009_NAME=Enqueued Transport Msg Frag Tot 1034 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_009_HELP=Total number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled. 1035 1036 1037 BO_FORWARDED_PENDING_MSGS_009_NAME=Forwarded Pending Msg Count 1038 BO_FORWARDED_PENDING_MSGS_009_HELP=The number of forwarded messages that have not been successfully sent yet. 1039 1040 1041 BO_FORWARDED_PENDING_MSG_BYTES_009_NAME=Forwarded Pending Msg Bytes 1042 BO_FORWARDED_PENDING_MSG_BYTES_009_HELP=The number of forwarded message bytes that have not been successfully sent yet. 1043 1044 1045 BO_FORWARDED_DISCARDED_MSG_RATE_009_NAME=Forwarded Msgs Discarded/sec 1046 BO_FORWARDED_DISCARDED_MSG_RATE_009_HELP=The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc. 1047 1048 1049 BO_FORWARDED_DISCARDED_MSG_TOTAL_009_NAME=Forwarded Msg Discarded Total 1050 BO_FORWARDED_DISCARDED_MSG_TOTAL_009_HELP=Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc. 1051 1052 1053 BO_FORWARDED_MSG_RATE_009_NAME=Forwarded Messages/sec 1054 BO_FORWARDED_MSG_RATE_009_HELP=The number of forwarded messages successfully sent per second. 1055 1056 1057 BO_FORWARDED_MSG_TOTAL_009_NAME=Forwarded Messages Total 1058 BO_FORWARDED_MSG_TOTAL_009_HELP=Total number of forwarded messages successfully sent. 1059 1060 1061 BO_FORWARDED_MSG_BYTE_RATE_009_NAME=Forwarded Msg Bytes/sec 1062 BO_FORWARDED_MSG_BYTE_RATE_009_HELP=The number of forwarded message bytes successfully sent per second. 1063 1064 1065 BO_FORWARDED_MSG_BYTE_TOTAL_009_NAME=Forwarded Msg Byte Total 1066 BO_FORWARDED_MSG_BYTE_TOTAL_009_HELP=Total number of forwarded message bytes successfully sent. 1067 1068 1069 BTO_OPEN_CONNECTIONS_009_NAME=Open Connection Count 1070 BTO_OPEN_CONNECTIONS_009_HELP=The total number of transport connections currently open. 1071 1072 1073 BTO_SEND_IO_RATE_009_NAME=Send I/Os/sec 1074 BTO_SEND_IO_RATE_009_HELP=The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment. 1075 1076 1077 BTO_SEND_IO_BYTE_RATE_009_NAME=Send I/O bytes/sec 1078 BTO_SEND_IO_BYTE_RATE_009_HELP=The number of transport send I/O bytes per second. 1079 1080 1081 BTO_SEND_IO_LEN_AVG_009_NAME=Send I/O Len Avg 1082 BTO_SEND_IO_LEN_AVG_009_HELP=The average byte length of transport send I/O operations. 1083 1084 1085 BTO_SEND_IO_LEN_AVG_BASE_009_NAME=Send I/O Len Avg Base 1086 BTO_SEND_IO_LEN_AVG_BASE_009_HELP=Base for the average byte length of transport send I/O operations. 1087 1088 1089 BTO_RECEIVE_IO_RATE_009_NAME=Receive I/Os/sec 1090 BTO_RECEIVE_IO_RATE_009_HELP=The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment. 1091 1092 1093 BTO_RECEIVE_IO_BYTE_RATE_009_NAME=Receive I/O bytes/sec 1094 BTO_RECEIVE_IO_BYTE_RATE_009_HELP=The number of transport receive I/O bytes per second. 1095 1096 1097 BTO_RECV_IO_LEN_AVG_009_NAME=Receive I/O Len Avg 1098 BTO_RECV_IO_LEN_AVG_009_HELP=The average byte length of transport receive I/O operations. 1099 1100 1101 BTO_RECV_IO_LEN_AVG_BASE_009_NAME=Receive I/O Len Avg Base 1102 BTO_RECV_IO_LEN_AVG_BASE_009_HELP=Base for the average byte length of transport receive I/O operations. 1103 1104 1105 BTO_SEND_FRAG_RATE_009_NAME=Message Fragment Sends/sec 1106 BTO_SEND_FRAG_RATE_009_HELP=The number of message fragments sent per second in transport send I/O operations. 1107 1108 1109 BTO_SEND_FRAG_SIZE_AVG_009_NAME=Msg Fragment Send Size Avg 1110 BTO_SEND_FRAG_SIZE_AVG_009_HELP=The average byte size of message fragments sent in transport send I/O operations. 1111 1112 1113 BTO_SEND_FRAG_SIZE_AVG_BASE_009_NAME=Msg Fragment Send Size Avg Base 1114 BTO_SEND_FRAG_SIZE_AVG_BASE_009_HELP=Base for the average byte size of message fragments sent in transport send I/O operations. 1115 1116 1117 BTO_RECEIVE_FRAG_RATE_009_NAME=Message Fragment Receives/sec 1118 BTO_RECEIVE_FRAG_RATE_009_HELP=The number of message fragments received per second in transport receive I/O operations. 1119 1120 1121 BTO_RECV_FRAG_SIZE_AVG_009_NAME=Msg Fragment Recv Size Avg 1122 BTO_RECV_FRAG_SIZE_AVG_009_HELP=The average byte size of message fragments received in transport receive I/O operations. 1123 1124 1125 BTO_RECV_FRAG_SIZE_AVG_BASE_009_NAME=Msg Fragment Recv Size Avg Base 1126 BTO_RECV_FRAG_SIZE_AVG_BASE_009_HELP=Base for the average byte size of message fragments received in transport receive I/O operations. 1127 1128 1129 BTO_SEND_IO_PEND_FRAG_COUNT_009_NAME=Pending Msg Frags for Send I/O 1130 BTO_SEND_IO_PEND_FRAG_COUNT_009_HELP=The current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer. 1131 1132 1133 BTO_SEND_IO_CURR_FRAG_COUNT_009_NAME=Current Msg Frags for Send I/O 1134 BTO_SEND_IO_CURR_FRAG_COUNT_009_HELP=The current number of message fragments associated with current transport send I/O operations that haven't completed. 1135 1136 1137 BTO_SEND_IO_PEND_BYTES_009_NAME=Pending Bytes for Send I/O 1138 BTO_SEND_IO_PEND_BYTES_009_HELP=The number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations. 1139 1140 1141 BTO_SEND_IO_CURR_BYTES_009_NAME=Current Bytes for Send I/O 1142 BTO_SEND_IO_CURR_BYTES_009_HELP=The number of buffer bytes associated with current transport send I/O operations that haven't completed. 1143 1144 1145 BTO_RECV_IO_PEND_FRAG_COUNT_009_NAME=Pending Msg Frags for Recv I/O 1146 BTO_RECV_IO_PEND_FRAG_COUNT_009_HELP=The current number of message fragments received in transport receive I/O operations that have not been enqueued (or rejected) yet. 1147 1148 1149 BTO_RECV_IO_CURR_BYTES_009_NAME=Current Bytes for Recv I/O 1150 BTO_RECV_IO_CURR_BYTES_009_HELP=The number of bytes associated with current transport receive I/O operations that haven't completed. 1151 1152 1153 BTO_RECV_IO_PEND_BYTES_009_NAME=Pending Bytes for Recv I/O 1154 BTO_RECV_IO_PEND_BYTES_009_HELP=The number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet. 1155 1156 1157 BTO_RECV_IO_COMPACT_MFB_009_NAME=Recv I/O Buffer Copies Count 1158 BTO_RECV_IO_COMPACT_MFB_009_HELP=The number of times when transport receive I/O operations had to move buffer fragments in memory. 1159 1160 1161 BTO_RECV_IO_COMPACT_MFB_RATE_009_NAME=Recv I/O Buffer Copies bytes/sec 1162 BTO_RECV_IO_COMPACT_MFB_RATE_009_HELP=The rate at witch transport receive I/O operations had to move buffer fragments in memory. 1163 1164 1165 BAO_TASK_START_RATE_009_NAME=Tasks Started/sec 1166 BAO_TASK_START_RATE_009_HELP=The number of activated tasks that are being started per second. 1167 1168 1169 BAO_TASKS_RUNNING_009_NAME=Tasks Running 1170 BAO_TASKS_RUNNING_009_HELP=The total number of activated tasks that are currently running. 1171 1172 1173 BAO_TASK_ABORT_RATE_009_NAME=Tasks Aborted/sec 1174 BAO_TASK_ABORT_RATE_009_HELP=The number of activated tasks that are being aborted per second. 1175 1176 1177 BAO_TASK_LIMIT_RATE_009_NAME=Task Limit Reached/sec 1178 BAO_TASK_LIMIT_RATE_009_HELP=The number of times the activated task limit on a queue has been reached per second. 1179 1180 1181 BAO_TASK_LIMIT_REACHED_009_NAME=Task Limit Reached 1182 BAO_TASK_LIMIT_REACHED_009_HELP=The total number of times the activated task limit on a queue has been reached. 1183 1184 1185 BAO_SP_INVOKE_RATE_009_NAME=Stored Procedures Invoked/sec 1186 BAO_SP_INVOKE_RATE_009_HELP=The number of stored procedures that are being invoked per second. 1187 1188 1189 WAITSTATS_LOCKS_009_NAME=Lock waits 1190 WAITSTATS_LOCKS_009_HELP=Statistics for processes waiting on a lock. 1191 1192 1193 WAITSTATS_RESOURCE_009_NAME=Memory grant queue waits 1194 WAITSTATS_RESOURCE_009_HELP=Statistics for processes waiting for memory grant to become available. 1195 1196 1197 WAITSTATS_MEMTHREAD_009_NAME=Thread-safe memory objects waits 1198 WAITSTATS_MEMTHREAD_009_HELP=Statistics for processes waiting on thread-safe memory allocators. 1199 1200 1201 WAITSTATS_WRITELOG_009_NAME=Log write waits 1202 WAITSTATS_WRITELOG_009_HELP=Statistics for processes waiting for log buffer to be written. 1203 1204 1205 WAITSTATS_LOGBUFFER_009_NAME=Log buffer waits 1206 WAITSTATS_LOGBUFFER_009_HELP=Statistics for processes waiting for log buffer to be available. 1207 1208 1209 WAITSTATS_NETWORKIO_009_NAME=Network IO waits 1210 WAITSTATS_NETWORKIO_009_HELP=Statistics relevant to wait on network IO. 1211 1212 1213 WAITSTATS_PAGEIOLATCH_009_NAME=Page IO latch waits 1214 WAITSTATS_PAGEIOLATCH_009_HELP=Statistics relevant to page IO latches. 1215 1216 1217 WAITSTATS_PAGELATCH_009_NAME=Page latch waits 1218 WAITSTATS_PAGELATCH_009_HELP=Statistics relevant to page latches, not including IO latches 1219 1220 1221 WAITSTATS_NPAGELATCH_009_NAME=Non-Page latch waits 1222 WAITSTATS_NPAGELATCH_009_HELP=Statistics relevant to non-page latches. 1223 1224 1225 WAITSTATS_SOS_WORKER_009_NAME=Wait for the worker 1226 WAITSTATS_SOS_WORKER_009_HELP=Statistics relevant to processes waiting for worker to become available. 1227 1228 1229 WAITSTATS_XACTWORKSPACE_009_NAME=Workspace synchronization waits 1230 WAITSTATS_XACTWORKSPACE_009_HELP=Statistics relevant to processes synchronizing access to workspace. 1231 1232 1233 WAITSTATS_TRANSACTION_009_NAME=Transaction ownership waits 1234 WAITSTATS_TRANSACTION_009_HELP=Statistics relevant to processes synchronizing access to transaction. 1235 1236 1237 EXECSTATS_MSQL_XP_009_NAME=Extended Procedures 1238 EXECSTATS_MSQL_XP_009_HELP=Statistics relevant to execution of XP calls. 1239 1240 1241 EXECSTATS_DTC_009_NAME=DTC calls 1242 EXECSTATS_DTC_009_HELP=Statistics relevant to execution of DTC calls. 1243 1244 1245 EXECSTATS_OLEDB_009_NAME=OLEDB calls 1246 EXECSTATS_OLEDB_009_HELP=Statistics relevant to execution of OLEDB calls. 1247 1248 1249 EXECSTATS_DQ_009_NAME=Distributed Query 1250 EXECSTATS_DQ_009_HELP=Statistics relevant to execution of distributed queries. 1251 1252 1253 SQLCLR_TOTAL_EXECTIME_009_NAME=CLR Execution 1254 SQLCLR_TOTAL_EXECTIME_009_HELP=Total Execution time in CLR ( microseconds ). 1255 1256 1257 MD_CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio 1258 MD_CACHE_HIT_RATIO_009_HELP=Ratio between catalog metadata cache hits and lookups 1259 1260 1261 MD_CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base 1262 MD_CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry 1263 1264 1265 MD_CACHE_ENTRY_COUNT_009_NAME=Cache Entries Count 1266 MD_CACHE_ENTRY_COUNT_009_HELP=Number of entries in the catalog metadata cache 1267 1268 1269 MD_CACHE_PINNED_COUNT_009_NAME=Cache Entries Pinned Count 1270 MD_CACHE_PINNED_COUNT_009_HELP=Number of catalog metadata cache entries that are pinned 1271 1272 1273 BUFMGR_OBJECT_004_NAME=SQLServer:Buffer Manager 1274 BUFMGR_OBJECT_004_HELP=与 SQL Server 缓冲区管理器有关的统计信息 1275 1276 1277 BUFPART_OBJECT_004_NAME=SQLServer:Buffer Partition 1278 BUFPART_OBJECT_004_HELP=与 SQL Server 的缓冲区分区有关的统计信息 1279 1280 1281 BUFNODE_OBJECT_004_NAME=SQLServer:Buffer Node 1282 BUFNODE_OBJECT_004_HELP=按 NUMA 节点列出的与 SQL Server 的缓冲池相关的统计信息 1283 1284 1285 GENERAL_OBJECT_004_NAME=SQLServer:General Statistics 1286 GENERAL_OBJECT_004_HELP=服务器常规统计信息 1287 1288 1289 LOCKS_OBJECT_004_NAME=SQLServer:Locks 1290 LOCKS_OBJECT_004_HELP=描述锁定服务器的各个锁请求的统计信息 1291 1292 1293 DBMGR_OBJECT_004_NAME=SQLServer:Databases 1294 DBMGR_OBJECT_004_HELP=它为 SQL Server 定义数据库管理器对象 1295 1296 1297 DBMIRRORING_OBJECT_004_NAME=SQLServer:Database Mirroring 1298 DBMIRRORING_OBJECT_004_HELP=它为 SQL Server 定义数据库镜像对象 1299 1300 1301 LATCH_OBJECT_004_NAME=SQLServer:Latches 1302 LATCH_OBJECT_004_HELP=收集与内部服务器闩锁相关的统计信息 1303 1304 1305 ACCESS_METHODS_OBJECT_004_NAME=SQLServer:Access Methods 1306 ACCESS_METHODS_OBJECT_004_HELP=收集与数据库服务器访问方法相关的统计信息 1307 1308 1309 SQL_ERROR_OBJECT_004_NAME=SQLServer:SQL Errors 1310 SQL_ERROR_OBJECT_004_HELP=有关 SQL Server 中错误的统计信息 1311 1312 1313 SQL_OBJECT_004_NAME=SQLServer:SQL Statistics 1314 SQL_OBJECT_004_HELP=收集与 SQL 请求相关的统计信息 1315 1316 1317 PLAN_CACHE_004_NAME=SQLServer:Plan Cache 1318 PLAN_CACHE_004_HELP=它定义缓存计数器 1319 1320 1321 CURSOR_OBJECT_BY_TYPE_004_NAME=SQLServer:Cursor Manager by Type 1322 CURSOR_OBJECT_BY_TYPE_004_HELP=按类型分组的游标属性的计数器 1323 1324 1325 CURSOR_OBJECT_TOTAL_004_NAME=SQLServer:Cursor Manager Total 1326 CURSOR_OBJECT_TOTAL_004_HELP=未按类型分组的游标属性的计数器 1327 1328 1329 MEMORY_OBJECT_004_NAME=SQLServer:Memory Manager 1330 MEMORY_OBJECT_004_HELP=它定义内存的使用情况。 1331 1332 1333 USER_QUERY_OBJECT_004_NAME=SQLServer:User Settable 1334 USER_QUERY_OBJECT_004_HELP=它定义用户可定义的计数器 1335 1336 1337 REPLICATION_AGENT_OBJECT_004_NAME=SQLServer:Replication Agents 1338 REPLICATION_AGENT_OBJECT_004_HELP=复制摘要 1339 1340 1341 MERGE_AGENT_OBJECT_004_NAME=SQLServer:Replication Merge 1342 MERGE_AGENT_OBJECT_004_HELP=复制合并代理统计信息 1343 1344 1345 LOGREADER_AGENT_OBJECT_004_NAME=SQLServer:Replication Logreader 1346 LOGREADER_AGENT_OBJECT_004_HELP=复制日志读取器代理统计信息 1347 1348 1349 DISTRIBUTION_AGENT_OBJECT_004_NAME=SQLServer:Replication Dist. 1350 DISTRIBUTION_AGENT_OBJECT_004_HELP=复制分发代理统计信息 1351 1352 1353 SNAPSHOT_AGENT_OBJECT_004_NAME=SQLServer:Replication Snapshot 1354 SNAPSHOT_AGENT_OBJECT_004_HELP=复制快照代理统计信息 1355 1356 1357 BACKUP_DEV_OBJECT_004_NAME=SQLServer:Backup Device 1358 BACKUP_DEV_OBJECT_004_HELP=它定义 SQL Server 的备份设备对象 1359 1360 1361 XACT_OBJECT_004_NAME=SQLServer:Transactions 1362 XACT_OBJECT_004_HELP=与 SQL Server 事务有关的统计信息。 1363 1364 1365 BROKER_OBJECT_004_NAME=SQLServer:Broker Statistics 1366 BROKER_OBJECT_004_HELP=Service Broker 统计信息 1367 1368 1369 BROKER_TRANSPORT_OBJECT_004_NAME=SQLServer:Broker/DBM Transport 1370 BROKER_TRANSPORT_OBJECT_004_HELP=Service Broker/数据库镜像传输统计信息 1371 1372 1373 BROKER_ACTIVATION_OBJECT_004_NAME=SQLServer:Broker Activation 1374 BROKER_ACTIVATION_OBJECT_004_HELP=Service Broker 激活 1375 1376 1377 WAITSTATS_OBJECT_004_NAME=SQLServer:Wait Statistics 1378 WAITSTATS_OBJECT_004_HELP=等待统计信息 1379 1380 1381 EXECSTATS_OBJECT_004_NAME=SQLServer:Exec Statistics 1382 EXECSTATS_OBJECT_004_HELP=外部调用的执行统计信息 1383 1384 1385 SQLCLR_OBJECT_004_NAME=SQLServer:CLR 1386 SQLCLR_OBJECT_004_HELP=在 SQL Server 中执行 CLR 1387 1388 1389 METADATAMGR_OBJECT_004_NAME=SQLServer:Catalog Metadata 1390 METADATAMGR_OBJECT_004_HELP=定义 SQL Server 的目录元数据管理器对象 1391 1392 1393 BUF_CACHE_HIT_RATIO_004_NAME=Buffer cache hit ratio 1394 BUF_CACHE_HIT_RATIO_004_HELP=可在缓冲池中找到而不必从磁盘读取的页所占的百分比。 1395 1396 1397 BUF_CACHE_RATIO_BASE_004_NAME=Buffer cache hit ratio base 1398 BUF_CACHE_RATIO_BASE_004_HELP=优先项的基数 1399 1400 1401 BUF_PAGE_REQUESTS_004_NAME=Page lookups/sec 1402 BUF_PAGE_REQUESTS_004_HELP=要求在缓冲池中查找页的请求数。 1403 1404 1405 BUF_FREELIST_STALLS_004_NAME=Free list stalls/sec 1406 BUF_FREELIST_STALLS_004_HELP=必须等待可用页的请求数。 1407 1408 1409 BUF_NUM_FREE_BUFFERS_004_NAME=Free pages 1410 BUF_NUM_FREE_BUFFERS_004_HELP=所有可用列表的总页数。 1411 1412 1413 BUF_COMMITTED_PAGE_COUNT_004_NAME=Total pages 1414 BUF_COMMITTED_PAGE_COUNT_004_HELP=缓冲池中的页数(包括数据库页、可用页和被盗页)。 1415 1416 1417 BUF_TARGET_PAGE_COUNT_004_NAME=Target pages 1418 BUF_TARGET_PAGE_COUNT_004_HELP=缓冲池中理想的页数。 1419 1420 1421 BUF_HASHED_PAGE_COUNT_004_NAME=Database pages 1422 BUF_HASHED_PAGE_COUNT_004_HELP=缓冲池中有数据库内容的页数。 1423 1424 1425 BUF_RESERVED_PAGE_COUNT_004_NAME=Reserved pages 1426 BUF_RESERVED_PAGE_COUNT_004_HELP=缓冲池保留的页数。 1427 1428 1429 BUF_STOLEN_PAGE_COUNT_004_NAME=Stolen pages 1430 BUF_STOLEN_PAGE_COUNT_004_HELP=用于其他服务器用途(包括过程缓存)的页数。 1431 1432 1433 BUF_LAZY_WRITES_004_NAME=Lazy writes/sec 1434 BUF_LAZY_WRITES_004_HELP=缓冲区管理器的惰性编写器写入的缓冲区数。 1435 1436 1437 BUF_READAHEAD_PAGES_004_NAME=Readahead pages/sec 1438 BUF_READAHEAD_PAGES_004_HELP=为预期使用读取的页数。 1439 1440 1441 BUF_BLOCK_READS_004_NAME=Page reads/sec 1442 BUF_BLOCK_READS_004_HELP=执行的物理数据库页读取数。 1443 1444 1445 BUF_BLOCK_WRITES_004_NAME=Page writes/sec 1446 BUF_BLOCK_WRITES_004_HELP=执行的物理数据库页写入数。 1447 1448 1449 BUF_CHECKPOINT_WRITES_004_NAME=Checkpoint pages/sec 1450 BUF_CHECKPOINT_WRITES_004_HELP=检查点或其他要求刷新全部脏页的操作所刷新的页数。 1451 1452 1453 BUF_AWE_LOOKUP_MAPS_004_NAME=AWE lookup maps/sec 1454 BUF_AWE_LOOKUP_MAPS_004_HELP=对在缓冲池中找到的页进行 AWE 映射调用的数目。 1455 1456 1457 BUF_AWE_STOLEN_MAPS_004_NAME=AWE stolen maps/sec 1458 BUF_AWE_STOLEN_MAPS_004_HELP=对从缓冲池盗用的页进行 AWE 映射调用的数目。 1459 1460 1461 BUF_AWE_WRITE_MAPS_004_NAME=AWE write maps/sec 1462 BUF_AWE_WRITE_MAPS_004_HELP=对要写入磁盘的页进行 AWE 映射调用的数目。 1463 1464 1465 BUF_AWE_UNMAP_CALLS_004_NAME=AWE unmap calls/sec 1466 BUF_AWE_UNMAP_CALLS_004_HELP=AWE 取消映射调用的数目。 1467 1468 1469 BUF_AWE_UNMAP_PAGES_004_NAME=AWE unmap pages/sec 1470 BUF_AWE_UNMAP_PAGES_004_HELP=取消映射的 AWE 页数。 1471 1472 1473 BUF_LIFE_EXPECTANCY_004_NAME=Page life expectancy 1474 BUF_LIFE_EXPECTANCY_004_HELP=没有引用的页停留在缓冲池中的时间(秒)。 1475 1476 1477 BUFPART_NUM_FREE_BUFFERS_004_NAME=Free pages 1478 BUFPART_NUM_FREE_BUFFERS_004_HELP=分区可用列表中的页数。 1479 1480 1481 BUFPART_FREE_BUFFERS_USED_004_NAME=Free list requests/sec 1482 BUFPART_FREE_BUFFERS_USED_004_HELP=请求可用页的次数。 1483 1484 1485 BUFPART_FREE_BUFFERS_EMPTY_004_NAME=Free list empty/sec 1486 BUFPART_FREE_BUFFERS_EMPTY_004_HELP=曾请求可用页但没有任何可用页的次数。 1487 1488 1489 BUFNODE_NUM_FREE_BUFFERS_004_NAME=Free pages 1490 BUFNODE_NUM_FREE_BUFFERS_004_HELP=节点上的空闲页数。 1491 1492 1493 BUFNODE_COMMITTED_PAGE_COUNT_004_NAME=Total pages 1494 BUFNODE_COMMITTED_PAGE_COUNT_004_HELP=节点上已提交的页数。 1495 1496 1497 BUFNODE_FOREIGN_PAGE_COUNT_004_NAME=Foreign pages 1498 BUFNODE_FOREIGN_PAGE_COUNT_004_HELP=不是 NUMA 本地内存中的页数。 1499 1500 1501 BUFNODE_HASHED_PAGE_COUNT_004_NAME=Database pages 1502 BUFNODE_HASHED_PAGE_COUNT_004_HELP=节点上的数据库页数。 1503 1504 1505 BUFNODE_STOLEN_PAGE_COUNT_004_NAME=Stolen pages 1506 BUFNODE_STOLEN_PAGE_COUNT_004_HELP=节点上的被盗用页数。 1507 1508 1509 BUFNODE_TARGET_PAGE_COUNT_004_NAME=Target pages 1510 BUFNODE_TARGET_PAGE_COUNT_004_HELP=节点上的目标页数。 1511 1512 1513 BUFNODE_LIFE_EXPECTANCY_004_NAME=Page life expectancy 1514 BUFNODE_LIFE_EXPECTANCY_004_HELP=没有引用的页停留在缓冲池中的时间(秒)。 1515 1516 1517 GO_TEMP_TABLES_IN_USE_004_NAME=Active Temp Tables 1518 GO_TEMP_TABLES_IN_USE_004_HELP=正在使用的临时表/表变量的数目 1519 1520 1521 GO_TEMP_TABLES_CREATION_RATE_004_NAME=Temp Tables Creation Rate 1522 GO_TEMP_TABLES_CREATION_RATE_004_HELP=每秒创建的临时表/表变量的数目 1523 1524 1525 GO_LOGINS_004_NAME=Logins/sec 1526 GO_LOGINS_004_HELP=每秒启动的登录总数。 1527 1528 1529 GO_LOGOUTS_004_NAME=Logouts/sec 1530 GO_LOGOUTS_004_HELP=每秒启动的注销总数。 1531 1532 1533 GO_USER_CONNECTIONS_004_NAME=User Connections 1534 GO_USER_CONNECTIONS_004_HELP=连接到系统的用户数。 1535 1536 1537 GO_LOGICAL_CONNECTIONS_004_NAME=Logical Connections 1538 GO_LOGICAL_CONNECTIONS_004_HELP=与系统建立的逻辑连接数。 1539 1540 1541 GO_TRANSACTIONS_004_NAME=Transactions 1542 GO_TRANSACTIONS_004_HELP=事务登记(本地、dtc 和绑定的事务)的数目。 1543 1544 1545 GO_NON_ATOMIC_YIELD_RATE_004_NAME=Non-atomic yield rate 1546 GO_NON_ATOMIC_YIELD_RATE_004_HELP=每秒的非原子生成数。 1547 1548 1549 GO_MARS_DEADLOCKS_DETECTED_004_NAME=Mars Deadlocks 1550 GO_MARS_DEADLOCKS_DETECTED_004_HELP=检测到的 Mars 死锁数。 1551 1552 1553 GO_HTTP_AUTH_REQS_004_NAME=HTTP Authenticated Requests 1554 GO_HTTP_AUTH_REQS_004_HELP=每秒启动的验证过的 HTTP 请求数。 1555 1556 1557 GO_SOAP_EMPTY_REQS_004_NAME=SOAP Empty Requests 1558 GO_SOAP_EMPTY_REQS_004_HELP=每秒启动的空 SOAP 请求数。 1559 1560 1561 GO_SOAP_QUERY_REQS_004_NAME=SOAP SQL Requests 1562 GO_SOAP_QUERY_REQS_004_HELP=每秒启动的 SOAP SQL 请求数。 1563 1564 1565 GO_SOAP_SP_REQS_004_NAME=SOAP Method Invocations 1566 GO_SOAP_SP_REQS_004_HELP=每秒启动的 SOAP 方法调用数。 1567 1568 1569 GO_SOAP_WSDL_REQS_004_NAME=SOAP WSDL Requests 1570 GO_SOAP_WSDL_REQS_004_HELP=每秒启动的 SOAP Web 服务描述语言请求数。 1571 1572 1573 GO_SOAP_SESSION_INITIATES_004_NAME=SOAP Session Initiate Requests 1574 GO_SOAP_SESSION_INITIATES_004_HELP=每秒启动的 SOAP 会话启动请求数。 1575 1576 1577 GO_SOAP_SESSION_TERMINATES_004_NAME=SOAP Session Terminate Requests 1578 GO_SOAP_SESSION_TERMINATES_004_HELP=每秒启动的 SOAP 会话终止请求数。 1579 1580 1581 GO_USERS_BLOCKED_004_NAME=Processes blocked 1582 GO_USERS_BLOCKED_004_HELP=当前阻塞的进程数。 1583 1584 1585 GO_TEMP_TABLES_FOR_DESTRUCTION_004_NAME=Temp Tables For Destruction 1586 GO_TEMP_TABLES_FOR_DESTRUCTION_004_HELP=等待被清除系统线程破坏的临时表/表变量数 1587 1588 1589 GO_EVT_NOTIF_DELAYED_DROP_004_NAME=Event Notifications Delayed Drop 1590 GO_EVT_NOTIF_DELAYED_DROP_004_HELP=等待某个系统线程删除的事件通知数 1591 1592 1593 GO_TRACE_EVT_NOTIF_QUEUE_SIZE_004_NAME=Trace Event Notification Queue 1594 GO_TRACE_EVT_NOTIF_QUEUE_SIZE_004_HELP=在内部队列中等待通过 Service Broker 发送的跟踪事件通知实例数 1595 1596 1597 GO_TRACE_IO_PROVIDER_EVENTLOCK_004_NAME=SQL Trace IO Provider Lock Waits 1598 GO_TRACE_IO_PROVIDER_EVENTLOCK_004_HELP=每秒等待 File IO Provider 锁的次数 1599 1600 1601 LCK_NUM_REQUESTS_004_NAME=Lock Requests/sec 1602 LCK_NUM_REQUESTS_004_HELP=从锁管理器请求的新锁和锁转换的数目。 1603 1604 1605 LCK_NUM_TIMEOUTS_004_NAME=Lock Timeouts/sec 1606 LCK_NUM_TIMEOUTS_004_HELP=超时的锁请求数。这包括对 NOWAIT 锁的请求。 1607 1608 1609 LCK_NUM_DEADLOCKS_004_NAME=Number of Deadlocks/sec 1610 LCK_NUM_DEADLOCKS_004_HELP=导致死锁的锁请求数。 1611 1612 1613 LCK_NUM_WAITS_004_NAME=Lock Waits/sec 1614 LCK_NUM_WAITS_004_HELP=不能立即满足而要求调用方等待授予锁的锁请求数。 1615 1616 1617 LCK_TOTAL_WAITTIME_004_NAME=Lock Wait Time (ms) 1618 LCK_TOTAL_WAITTIME_004_HELP=在上一秒钟内锁的总等待时间(毫秒)。 1619 1620 1621 LCK_AVERAGE_WAITTIME_004_NAME=Average Wait Time (ms) 1622 LCK_AVERAGE_WAITTIME_004_HELP=导致等待的每个锁请求的平均等待时间(毫秒)。 1623 1624 1625 LCK_AVERAGE_WAITTIME_BASE_004_NAME=Average Wait Time Base 1626 LCK_AVERAGE_WAITTIME_BASE_004_HELP=平均等待时间的基数。 1627 1628 1629 LCK_NUM_TIMEOUTS_NONPROBE_004_NAME=Lock Timeouts (timeout > 0)/sec 1630 LCK_NUM_TIMEOUTS_NONPROBE_004_HELP=超时的锁请求数。这不包括对 NOWAIT 锁的请求。 1631 1632 1633 DB_DATA_SIZE_004_NAME=Data File(s) Size (KB) 1634 DB_DATA_SIZE_004_HELP=数据库中所有数据文件的累积大小。 1635 1636 1637 DB_LOG_SIZE_004_NAME=Log File(s) Size (KB) 1638 DB_LOG_SIZE_004_HELP=数据库中所有日志文件的累积大小。 1639 1640 1641 DB_LOG_USED_004_NAME=Log File(s) Used Size (KB) 1642 DB_LOG_USED_004_HELP=数据库中所有日志文件的累积已用大小。 1643 1644 1645 DB_LOG_USED_PERCENT_004_NAME=Percent Log Used 1646 DB_LOG_USED_PERCENT_004_HELP=日志中已用空间所占的百分比。 1647 1648 1649 DB_ACT_XTRAN_004_NAME=Active Transactions 1650 DB_ACT_XTRAN_004_HELP=数据库的活动更新事务数。 1651 1652 1653 DB_TOTAL_XTRAN_004_NAME=Transactions/sec 1654 DB_TOTAL_XTRAN_004_HELP=为数据库启动的事务数。 1655 1656 1657 DB_REPLTRANS_004_NAME=Repl. Pending Xacts 1658 DB_REPLTRANS_004_HELP=数据库中挂起的复制事务数。 1659 1660 1661 DB_REPLCOUNT_004_NAME=Repl. Trans. Rate 1662 DB_REPLCOUNT_004_HELP=复制事务速率(每秒的复制事务数)。 1663 1664 1665 DB_LOGCACHE_READS_004_NAME=Log Cache Reads/sec 1666 DB_LOGCACHE_READS_004_HELP=通过日志管理器缓存执行的读取数。 1667 1668 1669 DB_LOGCACHE_RATIO_004_NAME=Log Cache Hit Ratio 1670 DB_LOGCACHE_RATIO_004_HELP=日志缓存所满足的日志缓存读取数所占的百分比。 1671 1672 1673 DB_LOGCACHE_BASE_004_NAME=Log Cache Hit Ratio Base 1674 DB_LOGCACHE_BASE_004_HELP=日志缓存的计算基数 1675 1676 1677 DB_BULK_ROWS_004_NAME=Bulk Copy Rows/sec 1678 DB_BULK_ROWS_004_HELP=大容量复制的行数。 1679 1680 1681 DB_BULK_KILOBYTES_004_NAME=Bulk Copy Throughput/sec 1682 DB_BULK_KILOBYTES_004_HELP=大容量复制的千字节数。 1683 1684 1685 DB_BCK_DB_THROUGHPUT_004_NAME=Backup/Restore Throughput/sec 1686 DB_BCK_DB_THROUGHPUT_004_HELP=数据库备份/还原的读取/写入吞吐量。 1687 1688 1689 DB_DBCC_SCANRATE_004_NAME=DBCC Logical Scan Bytes/sec 1690 DB_DBCC_SCANRATE_004_HELP=DBCC 命令的逻辑读取扫描速率 1691 1692 1693 DB_DBCC_MOVERATE_004_NAME=Shrink Data Movement Bytes/sec 1694 DB_DBCC_MOVERATE_004_HELP=Autoshrink、DBCC SHRINKDATABASE 或 SHRINKFILE 移动数据的速率。 1695 1696 1697 DB_FLUSHES_004_NAME=Log Flushes/sec 1698 DB_FLUSHES_004_HELP=日志刷新数目。 1699 1700 1701 DB_BYTES_FLUSHED_004_NAME=Log Bytes Flushed/sec 1702 DB_BYTES_FLUSHED_004_HELP=刷新的日志字节总数。 1703 1704 1705 DB_FLUSH_WAITS_004_NAME=Log Flush Waits/sec 1706 DB_FLUSH_WAITS_004_HELP=等待日志刷新的提交数目。 1707 1708 1709 DB_FLUSH_WAIT_TIME_004_NAME=Log Flush Wait Time 1710 DB_FLUSH_WAIT_TIME_004_HELP=总等待时间(毫秒)。 1711 1712 1713 DB_LOG_TRUNCS_004_NAME=Log Truncations 1714 DB_LOG_TRUNCS_004_HELP=此数据库的日志截断总数。 1715 1716 1717 DB_LOG_GROWTHS_004_NAME=Log Growths 1718 DB_LOG_GROWTHS_004_HELP=此数据库的日志增长总数。 1719 1720 1721 DB_LOG_SHRINKS_004_NAME=Log Shrinks 1722 DB_LOG_SHRINKS_004_HELP=此数据库的日志收缩总数。 1723 1724 1725 DB_DBMIRRORING_BYTES_SENT_004_NAME=Bytes Sent/sec 1726 DB_DBMIRRORING_BYTES_SENT_004_HELP=每秒发送的字节数 1727 1728 1729 DB_DBMIRRORING_PAGES_SENT_004_NAME=Pages Sent/sec 1730 DB_DBMIRRORING_PAGES_SENT_004_HELP=每秒发送的页数 1731 1732 1733 DB_DBMIRRORING_SENDS_004_NAME=Sends/sec 1734 DB_DBMIRRORING_SENDS_004_HELP=每秒启动的发送数目 1735 1736 1737 DB_DBMIRRORING_TRANSACTION_DELAY_004_NAME=Transaction Delay 1738 DB_DBMIRRORING_TRANSACTION_DELAY_004_HELP=等待确认的事务终止操作的平均延迟时间 1739 1740 1741 DB_DBM_REDO_DELTA_004_NAME=Redo Queue KB 1742 DB_DBM_REDO_DELTA_004_HELP=镜像数据库的重做操作滞后于镜像日志的总字节数(KB) 1743 1744 1745 DB_DBM_REDO_RATE_004_NAME=Redo Bytes/sec 1746 DB_DBM_REDO_RATE_004_HELP=每秒由镜像数据库重做的日志字节数 1747 1748 1749 DB_DBM_LOG_SEND_QUEUE_004_NAME=Log Send Queue KB 1750 DB_DBM_LOG_SEND_QUEUE_004_HELP=尚未发送到镜像服务器的日志总字节数(KB) 1751 1752 1753 DB_DBM_BYTES_RECEIVED_004_NAME=Bytes Received/sec 1754 DB_DBM_BYTES_RECEIVED_004_HELP=每秒收到的字节数 1755 1756 1757 DB_DBM_RECEIVES_004_NAME=Receives/sec 1758 DB_DBM_RECEIVES_004_HELP=每秒收到的镜像消息数 1759 1760 1761 DB_DBM_LOG_BYTES_RECEIVED_004_NAME=Log Bytes Received/sec 1762 DB_DBM_LOG_BYTES_RECEIVED_004_HELP=每秒收到的日志字节数 1763 1764 1765 DB_DBM_LOG_BYTES_SENT_004_NAME=Log Bytes Sent/sec 1766 DB_DBM_LOG_BYTES_SENT_004_HELP=每秒发送的日志字节数 1767 1768 1769 DB_DBM_ACK_TIME_004_NAME=Send/Receive Ack Time 1770 DB_DBM_ACK_TIME_004_HELP=包每秒在流控制中等待的时间(毫秒)。 1771 1772 1773 LATCH_WAITS_NP_004_NAME=Latch Waits/sec 1774 LATCH_WAITS_NP_004_HELP=未能立即授予而不得不等待的闩锁请求数。 1775 1776 1777 LATCH_AVG_WAIT_NP_004_NAME=Average Latch Wait Time (ms) 1778 LATCH_AVG_WAIT_NP_004_HELP=必须等待授予的闩锁请求的平均等待时间(毫秒)。 1779 1780 1781 LATCH_AVG_WAIT_BASE_004_NAME=Average Latch Wait Time Base 1782 LATCH_AVG_WAIT_BASE_004_HELP=闩锁平均等待时间的基数。 1783 1784 1785 LATCH_TOTAL_WAIT_NP_004_NAME=Total Latch Wait Time (ms) 1786 LATCH_TOTAL_WAIT_NP_004_HELP=在上一秒钟内必须等待授予的闩锁请求的总等待时间(毫秒)。 1787 1788 1789 LATCH_SUPERLATCHES_004_NAME=Number of SuperLatches 1790 LATCH_SUPERLATCHES_004_HELP=目前是 SuperLatch 的闩锁数。 1791 1792 1793 LATCH_PROMOTIONS_004_NAME=SuperLatch Promotions/sec 1794 LATCH_PROMOTIONS_004_HELP=已提升为 SuperLatch 的闩锁数 1795 1796 1797 LATCH_DEMOTIONS_004_NAME=SuperLatch Demotions/sec 1798 LATCH_DEMOTIONS_004_HELP=已降级为常规闩锁的 SuperLatch 数 1799 1800 1801 AM_FULL_SCAN_004_NAME=Full Scans/sec 1802 AM_FULL_SCAN_004_HELP=不受限制的完全扫描数目。这些扫描可以是基表扫描,也可以是全文索引扫描。 1803 1804 1805 AM_RANGE_SCAN_004_NAME=Range Scans/sec 1806 AM_RANGE_SCAN_004_HELP=每秒通过索引进行的限定范围扫描数。 1807 1808 1809 AM_PROBE_SCAN_004_NAME=Probe Scans/sec 1810 AM_PROBE_SCAN_004_HELP=每秒用于直接在索引或基表中查找最多一个单限定行的探测扫描的次数。 1811 1812 1813 AM_SCAN_REPOSITION_004_NAME=Scan Point Revalidations/sec 1814 AM_SCAN_REPOSITION_004_HELP=必须重新验证扫描点才能继续扫描的次数。 1815 1816 1817 AM_WORKFILES_CREATED_004_NAME=Workfiles Created/sec 1818 AM_WORKFILES_CREATED_004_HELP=每秒创建的工作文件数。例如,工作文件可用于存储哈希联接和哈希聚合的临时结果。 1819 1820 1821 AM_WORKTABLES_CREATED_004_NAME=Worktables Created/sec 1822 AM_WORKTABLES_CREATED_004_HELP=每秒创建的工作表数。例如,工作表可用于存储查询假脱机操作、LOB 变量、XML 变量和游标的临时结果。 1823 1824 1825 AM_WORKTABLES_FROM_CACHE_004_NAME=Worktables From Cache Ratio 1826 AM_WORKTABLES_FROM_CACHE_004_HELP=在创建的工作表中,工作表的最初两页不是分配的,而是直接来自工作表缓存中的工作表所占的百分比。 1827 1828 1829 AM_WORKTABLES_FROM_CACHE_BASE_004_NAME=Worktables From Cache Base 1830 AM_WORKTABLES_FROM_CACHE_BASE_004_HELP=优先项的基数。 1831 1832 1833 AM_FORWARDED_RECS_004_NAME=Forwarded Records/sec 1834 AM_FORWARDED_RECS_004_HELP=通过正向记录指针提取的记录数。 1835 1836 1837 AM_GHOSTED_SKIPS_004_NAME=Skipped Ghosted Records/sec 1838 AM_GHOSTED_SKIPS_004_HELP=扫描期间每秒跳过的虚影记录数。 1839 1840 1841 AM_INDEX_SEARCHES_004_NAME=Index Searches/sec 1842 AM_INDEX_SEARCHES_004_HELP=索引搜索的数目。索引搜索用于启动范围扫描和单个索引记录提取操作,也用于在索引中改变位置。 1843 1844 1845 AM_FREESPACE_SCANS_004_NAME=FreeSpace Scans/sec 1846 AM_FREESPACE_SCANS_004_HELP=每秒启动的扫描数目,扫描目的是搜索已分配给某分配单元的页内的可用空间,以用于插入或修改记录片段。每次扫描可能查找多页。 1847 1848 1849 AM_FREESPACE_PAGES_004_NAME=FreeSpace Page Fetches/sec 1850 AM_FREESPACE_PAGES_004_HELP=每秒由可用空间扫描提取的页数。这些扫描搜索已分配给分配单元的页内的可用空间,以满足插入或修改记录片段的请求。 1851 1852 1853 AM_PAGES_ALLOCATED_004_NAME=Pages Allocated/sec 1854 AM_PAGES_ALLOCATED_004_HELP=此 SQL Server 实例的所有数据库中每秒分配的页数。其中包括从混合区和统一区分配的页数。 1855 1856 1857 AM_EXTENTS_ALLOCATED_004_NAME=Extents Allocated/sec 1858 AM_EXTENTS_ALLOCATED_004_HELP=此 SQL Server 实例的所有数据库中每秒分配的区数。 1859 1860 1861 AM_SINGLE_PAGE_ALLOCS_004_NAME=Mixed page allocations/sec 1862 AM_SINGLE_PAGE_ALLOCS_004_HELP=每秒从混合区分配的页数。这些页可用于存储 IAM 页和分配给某分配单元的前八页。 1863 1864 1865 AM_EXTENTS_DEALLOCATED_004_NAME=Extent Deallocations/sec 1866 AM_EXTENTS_DEALLOCATED_004_HELP=此 SQL Server 实例的所有数据库中每秒释放的区数。 1867 1868 1869 AM_PAGE_DEALLOCS_004_NAME=Page Deallocations/sec 1870 AM_PAGE_DEALLOCS_004_HELP=此 SQL Server 实例的所有数据库中每秒释放的区数。其中包括从混合区和统一区释放的页数。 1871 1872 1873 AM_PAGE_SPLITS_004_NAME=Page Splits/sec 1874 AM_PAGE_SPLITS_004_HELP=索引页溢出时出现的每秒页拆分数目。 1875 1876 1877 AM_LOCKESCALATIONS_004_NAME=Table Lock Escalations/sec 1878 AM_LOCKESCALATIONS_004_HELP=表上的锁升级的次数。 1879 1880 1881 AM_DEFDROPPEDROWSETQUEUELENGTH_004_NAME=Deferred Dropped rowsets 1882 AM_DEFDROPPEDROWSETQUEUELENGTH_004_HELP=当已中止的联机索引生成操作正在等待清除延迟删除的行集的后台任务删除时创建的行集数。 1883 1884 1885 AM_DEFDROPPEDROWSETSCLEANED_004_NAME=Dropped rowset cleanups/sec 1886 AM_DEFDROPPEDROWSETSCLEANED_004_HELP=当清除延迟删除的行集的后台任务成功删除了已中止的联机索引生成操作时,每秒创建的行集数。 1887 1888 1889 AM_DEFDROPPEDROWSETSSKIPPED_004_NAME=Dropped rowsets skipped/sec 1890 AM_DEFDROPPEDROWSETSSKIPPED_004_HELP=当清除延迟删除的行集的后台任务跳过了已中止的联机索引生成操作时,每秒创建的行集数。 1891 1892 1893 AM_DDALLOCUNITQUEUELENGTH_004_NAME=Deferred dropped AUs 1894 AM_DDALLOCUNITQUEUELENGTH_004_HELP=正在等待清除延迟删除的分配单元的后台任务删除的分配单元数。 1895 1896 1897 AM_DDALLOCUNITSCLEANED_004_NAME=AU cleanups/sec 1898 AM_DDALLOCUNITSCLEANED_004_HELP=清除延迟删除的分配单元的后台任务每秒成功删除的分配单元数。删除每个分配单元都需要多个批处理。 1899 1900 1901 AM_DDALLOCUNITBATCHESCOMPLETED_004_NAME=AU cleanup batches/sec 1902 AM_DDALLOCUNITBATCHESCOMPLETED_004_HELP=清除延迟删除的分配单元的后台任务每秒成功完成的批处理个数。 1903 1904 1905 AM_DDALLOCUNITBATCHESFAILED_004_NAME=Failed AU cleanup batches/sec 1906 AM_DDALLOCUNITBATCHESFAILED_004_HELP=清除延迟删除的分配单元的后台任务每秒失败而需要重试的批处理个数。失败的原因可能是内存或磁盘空间不足和硬件故障,也可能是其他原因。 1907 1908 1909 TREE_PAGE_COOKIE_SUCCEED_004_NAME=Used tree page cookie 1910 TREE_PAGE_COOKIE_SUCCEED_004_HELP=自树页的父级未更改以来,在索引搜索期间成功使用了树页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1911 1912 1913 TREE_PAGE_COOKIE_FAIL_004_NAME=Failed tree page cookie 1914 TREE_PAGE_COOKIE_FAIL_004_HELP=自那些树页的父级发生更改以来,在索引搜索期间无法使用树页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1915 1916 1917 LEAF_PAGE_COOKIE_SUCCEED_004_NAME=Used leaf page cookie 1918 LEAF_PAGE_COOKIE_SUCCEED_004_HELP=自叶级页未更改以来,在索引搜索期间成功使用了叶级页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1919 1920 1921 LEAF_PAGE_COOKIE_FAIL_004_NAME=Failed leaf page cookie 1922 LEAF_PAGE_COOKIE_FAIL_004_HELP=自叶级页发生更改以来,在索引搜索期间无法使用叶级页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1923 1924 1925 AM_LOBSS_PROVIDERS_CREATED_004_NAME=LobSS Provider Create Count 1926 AM_LOBSS_PROVIDERS_CREATED_004_HELP=已创建的 LOB 存储服务提供程序计数。对每个 LOB 存储服务提供程序创建了一个工作表。 1927 1928 1929 AM_LOBSS_PROVIDERS_DESTROYED_004_NAME=LobSS Provider Destroy Count 1930 AM_LOBSS_PROVIDERS_DESTROYED_004_HELP=已破坏的 LOB 存储服务提供程序计数。 1931 1932 1933 AM_LOBSS_PROVIDERS_TRUNCATED_004_NAME=LobSS Provider Truncation Count 1934 AM_LOBSS_PROVIDERS_TRUNCATED_004_HELP=已截断的 LOB 存储服务提供程序计数。 1935 1936 1937 AM_LOBSS_LOBHANDLES_CREATED_004_NAME=LobHandle Create Count 1938 AM_LOBSS_LOBHANDLES_CREATED_004_HELP=已创建的临时 LOB 计数。 1939 1940 1941 AM_LOBSS_LOBHANDLES_DESTROYED_004_NAME=LobHandle Destroy Count 1942 AM_LOBSS_LOBHANDLES_DESTROYED_004_HELP=已破坏的临时 LOB 计数。 1943 1944 1945 AM_ORPHANS_CREATED_004_NAME=By-reference Lob Create Count 1946 AM_ORPHANS_CREATED_004_HELP=由引用传递的大型对象(LOB)值的计数。在某些大容量操作中使用由引用传递的 LOB,可免除按值传递它们时的开销。 1947 1948 1949 AM_ORPHANS_INSERTED_004_NAME=By-reference Lob Use Count 1950 AM_ORPHANS_INSERTED_004_HELP=使用过的由引用传递的 LOB 值的计数。在某些大容量操作中使用由引用传递的 LOB,可免除按值传递它们时的开销。 1951 1952 1953 AM_COLS_PUSHED_OFFROW_004_NAME=Count Push Off Row 1954 AM_COLS_PUSHED_OFFROW_004_HELP=已从行内推送到行外的值的计数。 1955 1956 1957 AM_COLS_PULLED_INROW_004_NAME=Count Pull In Row 1958 AM_COLS_PULLED_INROW_004_HELP=已从行外请求到行内的值的计数。 1959 1960 1961 AM_LOB_READAHEAD_ISSUED_004_NAME=Count Lob Readahead 1962 AM_LOB_READAHEAD_ISSUED_004_HELP=执行提前读的 lob 页计数。 1963 1964 1965 SQL_ERROR_RATE_004_NAME=Errors/sec 1966 SQL_ERROR_RATE_004_HELP=每秒的错误数 1967 1968 1969 SQL_BATCH_REQ_004_NAME=Batch Requests/sec 1970 SQL_BATCH_REQ_004_HELP=服务器收到的 SQL 批处理请求数。 1971 1972 1973 SQL_UNIVPARAM_004_NAME=Forced Parameterizations/sec 1974 SQL_UNIVPARAM_004_HELP=每秒由强制参数化导致参数化的语句数。 1975 1976 1977 SQL_AUTOPARAM_REQ_004_NAME=Auto-Param Attempts/sec 1978 SQL_AUTOPARAM_REQ_004_HELP=自动参数化尝试次数。 1979 1980 1981 SQL_AUTOPARAM_FAIL_004_NAME=Failed Auto-Params/sec 1982 SQL_AUTOPARAM_FAIL_004_HELP=失败的自动参数化数目。 1983 1984 1985 SQL_AUTOPARAM_SAFE_004_NAME=Safe Auto-Params/sec 1986 SQL_AUTOPARAM_SAFE_004_HELP=安全的自动参数化数目。 1987 1988 1989 SQL_AUTOPARAM_UNSAFE_004_NAME=Unsafe Auto-Params/sec 1990 SQL_AUTOPARAM_UNSAFE_004_HELP=不安全的自动参数化数目。 1991 1992 1993 SQL_COMPILES_004_NAME=SQL Compilations/sec 1994 SQL_COMPILES_004_HELP=SQL 编译的数目。 1995 1996 1997 SQL_RECOMPILES_004_NAME=SQL Re-Compilations/sec 1998 SQL_RECOMPILES_004_HELP=SQL 重新编译的数目。 1999 2000 2001 SQL_ATTENTION_RATE_004_NAME=SQL Attention rate 2002 SQL_ATTENTION_RATE_004_HELP=每秒发出关注信号的数目。 2003 2004 2005 PLAN_CACHE_HIT_RATIO_004_NAME=Cache Hit Ratio 2006 PLAN_CACHE_HIT_RATIO_004_HELP=缓存命中次数与查找次数之比 2007 2008 2009 PLAN_CACHE_HIT_RATIO_BASE_004_NAME=Cache Hit Ratio Base 2010 PLAN_CACHE_HIT_RATIO_BASE_004_HELP=优先项的基数 2011 2012 2013 PLAN_CACHE_PGS_IN_USE_004_NAME=Cache Pages 2014 PLAN_CACHE_PGS_IN_USE_004_HELP=缓存对象使用的 8k 页的数目 2015 2016 2017 PLAN_CACHE_OBJECT_COUNT_004_NAME=Cache Object Counts 2018 PLAN_CACHE_OBJECT_COUNT_004_HELP=缓存中的缓存对象数 2019 2020 2021 PLAN_CACHE_USE_COUNT_004_NAME=Cache Objects in use 2022 PLAN_CACHE_USE_COUNT_004_HELP=正在使用的缓存对象数 2023 2024 2025 CURSOR_CACHE_HIT_RATIO_004_NAME=Cache Hit Ratio 2026 CURSOR_CACHE_HIT_RATIO_004_HELP=缓存命中次数与查找次数之比 2027 2028 2029 CURSOR_CACHE_HIT_RATIO_BASE_004_NAME=Cache Hit Ratio Base 2030 CURSOR_CACHE_HIT_RATIO_BASE_004_HELP=优先项的基数 2031 2032 2033 CURSOR_CACHE_COUNT_004_NAME=Cached Cursor Counts 2034 CURSOR_CACHE_COUNT_004_HELP=缓存中给定类型的游标数 2035 2036 2037 CURSOR_CACHE_USE_COUNT_004_NAME=Cursor Cache Use Counts/sec 2038 CURSOR_CACHE_USE_COUNT_004_HELP=每种缓存的游标的使用次数 2039 2040 2041 CURSOR_REQ_004_NAME=Cursor Requests/sec 2042 CURSOR_REQ_004_HELP=服务器收到的 SQL 游标请求数。 2043 2044 2045 CURSOR_IN_USE_004_NAME=Active cursors 2046 CURSOR_IN_USE_004_HELP=活动游标数。 2047 2048 2049 CURSOR_MEMORY_USAGE_004_NAME=Cursor memory usage 2050 CURSOR_MEMORY_USAGE_004_HELP=游标占用的内存量(KB)。 2051 2052 2053 CURSOR_WORKTABLE_USAGE_004_NAME=Cursor worktable usage 2054 CURSOR_WORKTABLE_USAGE_004_HELP=游标使用的工作表数。 2055 2056 2057 CURSOR_PLANS_004_NAME=Number of active cursor plans 2058 CURSOR_PLANS_004_HELP=游标计划数。 2059 2060 2061 CURSOR_CONVERSION_RATE_004_NAME=Cursor conversion rate 2062 CURSOR_CONVERSION_RATE_004_HELP=游标每秒转换的次数。 2063 2064 2065 CURSOR_ASYNC_POPULATION_004_NAME=Async population count 2066 CURSOR_ASYNC_POPULATION_004_HELP=异步填充的游标数。 2067 2068 2069 CURSOR_XSTMT_FLUSH_004_NAME=Cursor flushes 2070 CURSOR_XSTMT_FLUSH_004_HELP=游标 xstmt 的刷新总次数。 2071 2072 2073 MEMORY_CONNECTION_MEMORY_004_NAME=Connection Memory (KB) 2074 MEMORY_CONNECTION_MEMORY_004_HELP=服务器用于维护连接的动态内存总量 2075 2076 2077 MEMORY_MEMGRANT_OUTSTANDING_004_NAME=Granted Workspace Memory (KB) 2078 MEMORY_MEMGRANT_OUTSTANDING_004_HELP=授予用来执行进程的内存总量。这些内存用于哈希、排序和创建索引操作。 2079 2080 2081 MEMORY_LOCK_MEMORY_004_NAME=Lock Memory (KB) 2082 MEMORY_LOCK_MEMORY_004_HELP=服务器用于锁的动态内存总量 2083 2084 2085 MEMORY_LOCKS_ALLOCATED_004_NAME=Lock Blocks Allocated 2086 MEMORY_LOCKS_ALLOCATED_004_HELP=分配的锁块的当前数目。 2087 2088 2089 MEMORY_LOCKOWNERS_ALLOCATED_004_NAME=Lock Owner Blocks Allocated 2090 MEMORY_LOCKOWNERS_ALLOCATED_004_HELP=分配的锁所有者块的当前数目。 2091 2092 2093 MEMORY_LOCKS_004_NAME=Lock Blocks 2094 MEMORY_LOCKS_004_HELP=服务器上正在使用的锁块的当前数目。已定期刷新。 2095 2096 2097 MEMORY_LOCKOWNERS_004_NAME=Lock Owner Blocks 2098 MEMORY_LOCKOWNERS_004_HELP=服务器上当前正在使用的锁所有者块的数目。已定期刷新。 2099 2100 2101 MEMORY_MEMGRANT_MAXIMUM_004_NAME=Maximum Workspace Memory (KB) 2102 MEMORY_MEMGRANT_MAXIMUM_004_HELP=授予用来执行进程的内存总量。这些内存主要用于哈希、排序和创建索引操作。 2103 2104 2105 MEMORY_MEMGRANT_ACQUIRES_004_NAME=Memory Grants Outstanding 2106 MEMORY_MEMGRANT_ACQUIRES_004_HELP=当前已成功获得工作区内存授予的进程数 2107 2108 2109 MEMORY_MEMGRANT_WAITERS_004_NAME=Memory Grants Pending 2110 MEMORY_MEMGRANT_WAITERS_004_HELP=当前正在等待工作区内存授予的进程数 2111 2112 2113 MEMORY_OPTIMIZER_MEMORY_004_NAME=Optimizer Memory (KB) 2114 MEMORY_OPTIMIZER_MEMORY_004_HELP=服务器用于查询优化的动态内存总量 2115 2116 2117 MEMORY_SQL_CACHE_MEMORY_004_NAME=SQL Cache Memory (KB) 2118 MEMORY_SQL_CACHE_MEMORY_004_HELP=服务器用于动态 SQL 缓存的动态内存总量 2119 2120 2121 MEMORY_SERVER_MEMORY_TARGET_004_NAME=Target Server Memory (KB) 2122 MEMORY_SERVER_MEMORY_TARGET_004_HELP=服务器打算占用的动态内存总量 2123 2124 2125 MEMORY_SERVER_MEMORY_004_NAME=Total Server Memory (KB) 2126 MEMORY_SERVER_MEMORY_004_HELP=服务器当前占用的动态内存总量 2127 2128 2129 QUERY_INSTANCE_004_NAME=Query 2130 QUERY_INSTANCE_004_HELP=与用户定义的一致。 2131 2132 2133 RUNNING_INSTANCE_004_NAME=Running 2134 RUNNING_INSTANCE_004_HELP=当前正在运行的复制代理数。 2135 2136 2137 UPLOAD_INSTANCE_004_NAME=Uploaded Changes/sec 2138 UPLOAD_INSTANCE_004_HELP=每秒从订阅服务器合并到发布服务器的行数。 2139 2140 2141 DOWNLOAD_INSTANCE_004_NAME=Downloaded Changes/sec 2142 DOWNLOAD_INSTANCE_004_HELP=每秒从发布服务器合并到订阅服务器的行数。 2143 2144 2145 MERGE_CONFLICTS_INSTANCE_004_NAME=Conflicts/sec 2146 MERGE_CONFLICTS_INSTANCE_004_HELP=在合并过程中每秒出现的冲突数。 2147 2148 2149 LOGREADER_LATENCY_INSTANCE_004_NAME=Logreader:Delivery Latency 2150 LOGREADER_LATENCY_INSTANCE_004_HELP=从将事务应用于发布服务器到将它们传递到分发服务器所占用的时间(毫秒)。 2151 2152 2153 LOGREADER_COMMANDS_INSTANCE_004_NAME=Logreader:Delivered Cmds/sec 2154 LOGREADER_COMMANDS_INSTANCE_004_HELP=每秒传递到分发服务器的命令数。 2155 2156 2157 LOGREADER_TRANSACTIONS_INSTANCE_004_NAME=Logreader:Delivered Trans/sec 2158 LOGREADER_TRANSACTIONS_INSTANCE_004_HELP=每秒传递到分发服务器的事务数。 2159 2160 2161 DISTRIBUTION_LATENCY_INSTANCE_004_NAME=Dist:Delivery Latency 2162 DISTRIBUTION_LATENCY_INSTANCE_004_HELP=从将事务传递到分发服务器到将它们应用于订阅服务器所占用的时间(毫秒)。 2163 2164 2165 DISTRIBUTION_COMMANDS_INSTANCE_004_NAME=Dist:Delivered Cmds/sec 2166 DISTRIBUTION_COMMANDS_INSTANCE_004_HELP=每秒传递到订阅服务器的命令数。 2167 2168 2169 DISTRIBUTION_TRANS_INSTANCE_004_NAME=Dist:Delivered Trans/sec 2170 DISTRIBUTION_TRANS_INSTANCE_004_HELP=每秒传递到订阅服务器的事务数。 2171 2172 2173 SNAPSHOT_COMMANDS_BCPED_004_NAME=Snapshot:Delivered Cmds/sec 2174 SNAPSHOT_COMMANDS_BCPED_004_HELP=每秒传递到分发服务器的命令数。 2175 2176 2177 SNAPSHOT_TRANSACTIONS_BCPED_004_NAME=Snapshot:Delivered Trans/sec 2178 SNAPSHOT_TRANSACTIONS_BCPED_004_HELP=每秒传递到分发服务器的事务数。 2179 2180 2181 DB_BCK_DEV_THROUGHPUT_004_NAME=Device Throughput Bytes/sec 2182 DB_BCK_DEV_THROUGHPUT_004_HELP=备份设备的读取/写入吞吐量。 2183 2184 2185 XACT_NUM_004_NAME=Transactions 2186 XACT_NUM_004_HELP=活动事务的总数。 2187 2188 2189 XACT_SNP_NUM_004_NAME=Snapshot Transactions 2190 XACT_SNP_NUM_004_HELP=活动快照事务的总数。 2191 2192 2193 XACT_UPD_SNP_NUM_004_NAME=Update Snapshot Transactions 2194 XACT_UPD_SNP_NUM_004_HELP=执行更新操作的活动快照事务的总数。 2195 2196 2197 XACT_NSNP_VER_NUM_004_NAME=NonSnapshot Version Transactions 2198 XACT_NSNP_VER_NUM_004_HELP=生成版本记录的活动非快照事务的总数。 2199 2200 2201 XACT_LONGEST_RUNNING_004_NAME=Longest Transaction Running Time 2202 XACT_LONGEST_RUNNING_004_HELP=任意事务的最长运行时间(秒)。 2203 2204 2205 XACT_UPD_CONFLICTS_RATIO_004_NAME=Update conflict ratio 2206 XACT_UPD_CONFLICTS_RATIO_004_HELP=存在更新冲突的更新快照事务与更新快照事务总数的比值。 2207 2208 2209 XACT_UPD_CONFLICTS_RATIO_BASE_004_NAME=Update conflict ratio base 2210 XACT_UPD_CONFLICTS_RATIO_BASE_004_HELP=更新快照事务的总数。 2211 2212 2213 XACT_TEMPDB_FREE_SPACE_004_NAME=Free Space in tempdb (KB) 2214 XACT_TEMPDB_FREE_SPACE_004_HELP=tempdb 中的可用空间(KB)。 2215 2216 2217 XACT_VER_STORE_GEN_RATE_004_NAME=Version Generation rate (KB/s) 2218 XACT_VER_STORE_GEN_RATE_004_HELP=版本生成速率(KB/秒)。 2219 2220 2221 XACT_VER_STORE_CLEANUP_RATE_004_NAME=Version Cleanup rate (KB/s) 2222 XACT_VER_STORE_CLEANUP_RATE_004_HELP=版本清除速率(KB/秒)。 2223 2224 2225 XACT_VER_STORE_SIZE_004_NAME=Version Store Size (KB) 2226 XACT_VER_STORE_SIZE_004_HELP=版本存储区的大小(KB)。 2227 2228 2229 XACT_VER_STORE_UNIT_COUNT_004_NAME=Version Store unit count 2230 XACT_VER_STORE_UNIT_COUNT_004_HELP=版本存储区中的单元数。 2231 2232 2233 XACT_VER_STORE_UNIT_CREATION_004_NAME=Version Store unit creation 2234 XACT_VER_STORE_UNIT_CREATION_004_HELP=在版本存储区中创建新单元。 2235 2236 2237 XACT_VER_STORE_UNIT_TRUNCATION_004_NAME=Version Store unit truncation 2238 XACT_VER_STORE_UNIT_TRUNCATION_004_HELP=截断版本存储区中的单元。 2239 2240 2241 BO_SEND_RATE_004_NAME=SQL SENDs/sec 2242 BO_SEND_RATE_004_HELP=Broker 每秒处理的 SQL SEND 命令数。 2243 2244 2245 BO_TOTAL_SENDS_004_NAME=SQL SEND Total 2246 BO_TOTAL_SENDS_004_HELP=Broker 处理的 SQL SEND 命令总数。 2247 2248 2249 BO_RECEIVE_RATE_004_NAME=SQL RECEIVEs/sec 2250 BO_RECEIVE_RATE_004_HELP=Broker 每秒处理的 SQL RECEIVE 命令数。 2251 2252 2253 BO_TOTAL_RECEIVES_004_NAME=SQL RECEIVE Total 2254 BO_TOTAL_RECEIVES_004_HELP=Broker 处理的 SQL RECEIVE 命令总数。 2255 2256 2257 BO_XACT_ROLLBACKS_004_NAME=Broker Transaction Rollbacks 2258 BO_XACT_ROLLBACKS_004_HELP=已回滚的 Service Broker 相关事务数。 2259 2260 2261 BO_DEP_TIMER_EVENTS_004_NAME=Dialog Timer Event Count 2262 BO_DEP_TIMER_EVENTS_004_HELP=Broker 中与对话框端点相关的计时器事件数。 2263 2264 2265 BO_ENQUEUED_MSG_RATE_004_NAME=Enqueued Messages/sec 2266 BO_ENQUEUED_MSG_RATE_004_HELP=每秒成功地从本地端点和传输层传递到队列的就绪消息数。 2267 2268 2269 BO_ENQUEUED_LOCAL_MSG_RATE_004_NAME=Enqueued Local Messages/sec 2270 BO_ENQUEUED_LOCAL_MSG_RATE_004_HELP=每秒成功地从本地端点传递到队列的就绪消息数。 2271 2272 2273 BO_ENQUEUED_TRANSPORT_MSG_RATE_004_NAME=Enqueued Transport Msgs/sec 2274 BO_ENQUEUED_TRANSPORT_MSG_RATE_004_HELP=每秒成功地从传输层传递到队列的就绪消息数。 2275 2276 2277 BO_ENQUEUED_TRANSPORT_FRAG_RATE_004_NAME=Enqueued Transport Msg Frags/sec 2278 BO_ENQUEUED_TRANSPORT_FRAG_RATE_004_HELP=每秒成功地从传输层传递到队列的消息片段数。请注意,相应的消息可能仍不完整或者顺序不对,因此该消息在队列中处于禁用状态。 2279 2280 2281 BO_ENQUEUED_MSGS_TOTAL_004_NAME=Enqueued Messages Total 2282 BO_ENQUEUED_MSGS_TOTAL_004_HELP=成功地从本地端点和传输层传递到队列的就绪消息片段总数。 2283 2284 2285 BO_ENQUEUED_LOCAL_MSGS_TOTAL_004_NAME=Enqueued Local Messages Total 2286 BO_ENQUEUED_LOCAL_MSGS_TOTAL_004_HELP=成功地从本地端点传递到队列的就绪消息片段总数。 2287 2288 2289 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_004_NAME=Enqueued Transport Msgs Total 2290 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_004_HELP=成功地从传输层传递到队列的就绪消息总数。 2291 2292 2293 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_004_NAME=Enqueued Transport Msg Frag Tot 2294 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_004_HELP=成功地从传输层传递到队列的消息片段总数。请注意,相应的消息可能仍不完整或者顺序不对,因此该消息在队列中处于禁用状态。 2295 2296 2297 BO_FORWARDED_PENDING_MSGS_004_NAME=Forwarded Pending Msg Count 2298 BO_FORWARDED_PENDING_MSGS_004_HELP=尚未成功发送的转发消息数。 2299 2300 2301 BO_FORWARDED_PENDING_MSG_BYTES_004_NAME=Forwarded Pending Msg Bytes 2302 BO_FORWARDED_PENDING_MSG_BYTES_004_HELP=尚未成功发送的转发消息字节数。 2303 2304 2305 BO_FORWARDED_DISCARDED_MSG_RATE_004_NAME=Forwarded Msgs Discarded/sec 2306 BO_FORWARDED_DISCARDED_MSG_RATE_004_HELP=每秒因转发消息内存限制、保留时间限制等原因而放弃的转发消息数。 2307 2308 2309 BO_FORWARDED_DISCARDED_MSG_TOTAL_004_NAME=Forwarded Msg Discarded Total 2310 BO_FORWARDED_DISCARDED_MSG_TOTAL_004_HELP=因转发消息内存限制、保留时间限制等原因而放弃的转发消息总数。 2311 2312 2313 BO_FORWARDED_MSG_RATE_004_NAME=Forwarded Messages/sec 2314 BO_FORWARDED_MSG_RATE_004_HELP=每秒成功发送的转发消息数。 2315 2316 2317 BO_FORWARDED_MSG_TOTAL_004_NAME=Forwarded Messages Total 2318 BO_FORWARDED_MSG_TOTAL_004_HELP=成功发送的转发消息总数。 2319 2320 2321 BO_FORWARDED_MSG_BYTE_RATE_004_NAME=Forwarded Msg Bytes/sec 2322 BO_FORWARDED_MSG_BYTE_RATE_004_HELP=每秒成功发送的转发消息字节数。 2323 2324 2325 BO_FORWARDED_MSG_BYTE_TOTAL_004_NAME=Forwarded Msg Byte Total 2326 BO_FORWARDED_MSG_BYTE_TOTAL_004_HELP=成功发送的转发消息字节总数。 2327 2328 2329 BTO_OPEN_CONNECTIONS_004_NAME=Open Connection Count 2330 BTO_OPEN_CONNECTIONS_004_HELP=当前打开的传输连接总数。 2331 2332 2333 BTO_SEND_IO_RATE_004_NAME=Send I/Os/sec 2334 BTO_SEND_IO_RATE_004_HELP=每秒传输发送 I/O 的数目。请注意,传输发送 I/O 可能包含一个以上的消息片段。 2335 2336 2337 BTO_SEND_IO_BYTE_RATE_004_NAME=Send I/O bytes/sec 2338 BTO_SEND_IO_BYTE_RATE_004_HELP=每秒传输发送 I/O 字节数。 2339 2340 2341 BTO_SEND_IO_LEN_AVG_004_NAME=Send I/O Len Avg 2342 BTO_SEND_IO_LEN_AVG_004_HELP=传输发送 I/O 操作的平均字节长度。 2343 2344 2345 BTO_SEND_IO_LEN_AVG_BASE_004_NAME=Send I/O Len Avg Base 2346 BTO_SEND_IO_LEN_AVG_BASE_004_HELP=传输发送 I/O 操作的平均字节长度的基数。 2347 2348 2349 BTO_RECEIVE_IO_RATE_004_NAME=Receive I/Os/sec 2350 BTO_RECEIVE_IO_RATE_004_HELP=每秒传输接收 I/O 的数目。请注意,传输接收 I/O 可能包含一个以上的消息片段。 2351 2352 2353 BTO_RECEIVE_IO_BYTE_RATE_004_NAME=Receive I/O bytes/sec 2354 BTO_RECEIVE_IO_BYTE_RATE_004_HELP=每秒传输接收 I/O 字节数。 2355 2356 2357 BTO_RECV_IO_LEN_AVG_004_NAME=Receive I/O Len Avg 2358 BTO_RECV_IO_LEN_AVG_004_HELP=传输接收 I/O 操作的平均字节长度。 2359 2360 2361 BTO_RECV_IO_LEN_AVG_BASE_004_NAME=Receive I/O Len Avg Base 2362 BTO_RECV_IO_LEN_AVG_BASE_004_HELP=传输接收 I/O 操作的平均字节长度的基数。 2363 2364 2365 BTO_SEND_FRAG_RATE_004_NAME=Message Fragment Sends/sec 2366 BTO_SEND_FRAG_RATE_004_HELP=每秒在传输发送 I/O 操作中发送的消息片段数。 2367 2368 2369 BTO_SEND_FRAG_SIZE_AVG_004_NAME=Msg Fragment Send Size Avg 2370 BTO_SEND_FRAG_SIZE_AVG_004_HELP=在传输发送 I/O 操作中发送的消息片段的平均字节大小。 2371 2372 2373 BTO_SEND_FRAG_SIZE_AVG_BASE_004_NAME=Msg Fragment Send Size Avg Base 2374 BTO_SEND_FRAG_SIZE_AVG_BASE_004_HELP=在传输发送 I/O 操作中发送的消息片段的平均字节大小的基数。 2375 2376 2377 BTO_RECEIVE_FRAG_RATE_004_NAME=Message Fragment Receives/sec 2378 BTO_RECEIVE_FRAG_RATE_004_HELP=每秒在传输接收 I/O 操作中接收的消息片段数。 2379 2380 2381 BTO_RECV_FRAG_SIZE_AVG_004_NAME=Msg Fragment Recv Size Avg 2382 BTO_RECV_FRAG_SIZE_AVG_004_HELP=在传输接收 I/O 操作中接收的消息片段的平均字节大小。 2383 2384 2385 BTO_RECV_FRAG_SIZE_AVG_BASE_004_NAME=Msg Fragment Recv Size Avg Base 2386 BTO_RECV_FRAG_SIZE_AVG_BASE_004_HELP=在传输接收 I/O 操作中接收的消息片段的平均字节大小的基数。 2387 2388 2389 BTO_SEND_IO_PEND_FRAG_COUNT_004_NAME=Pending Msg Frags for Send I/O 2390 BTO_SEND_IO_PEND_FRAG_COUNT_004_HELP=当前正在封送或已封送好可通过传输层发送的消息片段数。 2391 2392 2393 BTO_SEND_IO_CURR_FRAG_COUNT_004_NAME=Current Msg Frags for Send I/O 2394 BTO_SEND_IO_CURR_FRAG_COUNT_004_HELP=与当前尚未完成的传输发送 I/O 操作相关的当前消息片段数。 2395 2396 2397 BTO_SEND_IO_PEND_BYTES_004_NAME=Pending Bytes for Send I/O 2398 BTO_SEND_IO_PEND_BYTES_004_HELP=与正在封送或已封送好可通过发送 I/O 操作发送的消息片段相关的缓冲区字节数。 2399 2400 2401 BTO_SEND_IO_CURR_BYTES_004_NAME=Current Bytes for Send I/O 2402 BTO_SEND_IO_CURR_BYTES_004_HELP=与当前尚未完成的传输发送 I/O 操作相关的缓冲区字节数。 2403 2404 2405 BTO_RECV_IO_PEND_FRAG_COUNT_004_NAME=Pending Msg Frags for Recv I/O 2406 BTO_RECV_IO_PEND_FRAG_COUNT_004_HELP=在尚未排队(或拒绝)的传输接收 I/O 操作中接收的当前消息片段数。 2407 2408 2409 BTO_RECV_IO_CURR_BYTES_004_NAME=Current Bytes for Recv I/O 2410 BTO_RECV_IO_CURR_BYTES_004_HELP=与当前尚未完成的传输接收 I/O 操作相关的字节数。 2411 2412 2413 BTO_RECV_IO_PEND_BYTES_004_NAME=Pending Bytes for Recv I/O 2414 BTO_RECV_IO_PEND_BYTES_004_HELP=与其消息片段尚未排队(或拒绝)的未完成传输接收 I/O 操作相关的字节数。 2415 2416 2417 BTO_RECV_IO_COMPACT_MFB_004_NAME=Recv I/O Buffer Copies Count 2418 BTO_RECV_IO_COMPACT_MFB_004_HELP=传输接收 I/O 操作必须将缓冲区片段移入内存的次数。 2419 2420 2421 BTO_RECV_IO_COMPACT_MFB_RATE_004_NAME=Recv I/O Buffer Copies bytes/sec 2422 BTO_RECV_IO_COMPACT_MFB_RATE_004_HELP=传输接收 I/O 操作必须将缓冲区片段移入内存时的速率。 2423 2424 2425 BAO_TASK_START_RATE_004_NAME=Tasks Started/sec 2426 BAO_TASK_START_RATE_004_HELP=每秒正在启动的已激活任务的数目。 2427 2428 2429 BAO_TASKS_RUNNING_004_NAME=Tasks Running 2430 BAO_TASKS_RUNNING_004_HELP=当前正在运行的已激活任务的总数。 2431 2432 2433 BAO_TASK_ABORT_RATE_004_NAME=Tasks Aborted/sec 2434 BAO_TASK_ABORT_RATE_004_HELP=每秒正在中止的已激活任务的数目。 2435 2436 2437 BAO_TASK_LIMIT_RATE_004_NAME=Task Limit Reached/sec 2438 BAO_TASK_LIMIT_RATE_004_HELP=每秒队列中的已激活任务达到限额的次数。 2439 2440 2441 BAO_TASK_LIMIT_REACHED_004_NAME=Task Limit Reached 2442 BAO_TASK_LIMIT_REACHED_004_HELP=队列中的已激活任务达到限额的总次数。 2443 2444 2445 BAO_SP_INVOKE_RATE_004_NAME=Stored Procedures Invoked/sec 2446 BAO_SP_INVOKE_RATE_004_HELP=每秒正在调用的存储过程数。 2447 2448 2449 WAITSTATS_LOCKS_004_NAME=Lock waits 2450 WAITSTATS_LOCKS_004_HELP=等待锁的进程的统计信息。 2451 2452 2453 WAITSTATS_RESOURCE_004_NAME=Memory grant queue waits 2454 WAITSTATS_RESOURCE_004_HELP=等待内存授予的进程的统计信息。 2455 2456 2457 WAITSTATS_MEMTHREAD_004_NAME=Thread-safe memory objects waits 2458 WAITSTATS_MEMTHREAD_004_HELP=等待线程安全内存分配器的进程的统计信息。 2459 2460 2461 WAITSTATS_WRITELOG_004_NAME=Log write waits 2462 WAITSTATS_WRITELOG_004_HELP=等待写入日志缓冲区的进程的统计信息。 2463 2464 2465 WAITSTATS_LOGBUFFER_004_NAME=Log buffer waits 2466 WAITSTATS_LOGBUFFER_004_HELP=等待日志缓冲区可用的进程的统计信息。 2467 2468 2469 WAITSTATS_NETWORKIO_004_NAME=Network IO waits 2470 WAITSTATS_NETWORKIO_004_HELP=与等待网络 IO 相关的统计信息。 2471 2472 2473 WAITSTATS_PAGEIOLATCH_004_NAME=Page IO latch waits 2474 WAITSTATS_PAGEIOLATCH_004_HELP=与页 IO 闩锁相关的统计信息。 2475 2476 2477 WAITSTATS_PAGELATCH_004_NAME=Page latch waits 2478 WAITSTATS_PAGELATCH_004_HELP=与页闩锁(不包括 IO 闩锁)相关的统计信息 2479 2480 2481 WAITSTATS_NPAGELATCH_004_NAME=Non-Page latch waits 2482 WAITSTATS_NPAGELATCH_004_HELP=与非页闩锁相关的统计信息。 2483 2484 2485 WAITSTATS_SOS_WORKER_004_NAME=Wait for the worker 2486 WAITSTATS_SOS_WORKER_004_HELP=与等待工作线程变得可用的进程相关的统计信息。 2487 2488 2489 WAITSTATS_XACTWORKSPACE_004_NAME=Workspace synchronization waits 2490 WAITSTATS_XACTWORKSPACE_004_HELP=与同步访问工作区的进程相关的统计信息。 2491 2492 2493 WAITSTATS_TRANSACTION_004_NAME=Transaction ownership waits 2494 WAITSTATS_TRANSACTION_004_HELP=与同步访问事务的进程相关的统计信息。 2495 2496 2497 EXECSTATS_MSQL_XP_004_NAME=Extended Procedures 2498 EXECSTATS_MSQL_XP_004_HELP=与执行 XP 调用相关的统计信息。 2499 2500 2501 EXECSTATS_DTC_004_NAME=DTC calls 2502 EXECSTATS_DTC_004_HELP=与执行 DTC 调用相关的统计信息。 2503 2504 2505 EXECSTATS_OLEDB_004_NAME=OLEDB calls 2506 EXECSTATS_OLEDB_004_HELP=与执行 OLEDB 调用相关的统计信息。 2507 2508 2509 EXECSTATS_DQ_004_NAME=Distributed Query 2510 EXECSTATS_DQ_004_HELP=与执行分布式查询相关的统计信息。 2511 2512 2513 SQLCLR_TOTAL_EXECTIME_004_NAME=CLR Execution 2514 SQLCLR_TOTAL_EXECTIME_004_HELP=在 CLR 中的总执行时间(微秒)。 2515 2516 2517 MD_CACHE_HIT_RATIO_004_NAME=Cache Hit Ratio 2518 MD_CACHE_HIT_RATIO_004_HELP=目录元数据缓存中命中次数和查找次数之比 2519 2520 2521 MD_CACHE_HIT_RATIO_BASE_004_NAME=Cache Hit Ratio Base 2522 MD_CACHE_HIT_RATIO_BASE_004_HELP=优先项的基数 2523 2524 2525 MD_CACHE_ENTRY_COUNT_004_NAME=Cache Entries Count 2526 MD_CACHE_ENTRY_COUNT_004_HELP=目录元数据缓存中的项数 2527 2528 2529 MD_CACHE_PINNED_COUNT_004_NAME=Cache Entries Pinned Count 2530 MD_CACHE_PINNED_COUNT_004_HELP=目录元数据缓存中已固定的项数
perf-MSSQLSERVERsqlctr.ini
1 [info] 2 drivername=MSSQLServer 3 trusted= 4 symbolfile=c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\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 LOGREADER_TRANSACTIONS_INSTANCE_009_NAME=Logreader:Delivered Trans/sec 898 LOGREADER_TRANSACTIONS_INSTANCE_009_HELP=The number of transactions per second delivered to the Distributor. 899 900 901 DISTRIBUTION_LATENCY_INSTANCE_009_NAME=Dist:Delivery Latency 902 DISTRIBUTION_LATENCY_INSTANCE_009_HELP=The current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber. 903 904 905 DISTRIBUTION_COMMANDS_INSTANCE_009_NAME=Dist:Delivered Cmds/sec 906 DISTRIBUTION_COMMANDS_INSTANCE_009_HELP=The number of commands per second delivered to the Subscriber. 907 908 909 DISTRIBUTION_TRANS_INSTANCE_009_NAME=Dist:Delivered Trans/sec 910 DISTRIBUTION_TRANS_INSTANCE_009_HELP=The number of transactions per second delivered to the Subscriber. 911 912 913 SNAPSHOT_COMMANDS_BCPED_009_NAME=Snapshot:Delivered Cmds/sec 914 SNAPSHOT_COMMANDS_BCPED_009_HELP=The number of commands per second delivered to the Distributor. 915 916 917 SNAPSHOT_TRANSACTIONS_BCPED_009_NAME=Snapshot:Delivered Trans/sec 918 SNAPSHOT_TRANSACTIONS_BCPED_009_HELP=The number of transactions per second delivered to the Distributor. 919 920 921 DB_BCK_DEV_THROUGHPUT_009_NAME=Device Throughput Bytes/sec 922 DB_BCK_DEV_THROUGHPUT_009_HELP=Read/write throughput for a backup device. 923 924 925 XACT_NUM_009_NAME=Transactions 926 XACT_NUM_009_HELP=The total number of active transactions. 927 928 929 XACT_SNP_NUM_009_NAME=Snapshot Transactions 930 XACT_SNP_NUM_009_HELP=The total number of active snapshot transactions. 931 932 933 XACT_UPD_SNP_NUM_009_NAME=Update Snapshot Transactions 934 XACT_UPD_SNP_NUM_009_HELP=The total number of active snapshot transactions that do updates. 935 936 937 XACT_NSNP_VER_NUM_009_NAME=NonSnapshot Version Transactions 938 XACT_NSNP_VER_NUM_009_HELP=The total number of active non-snapshot transactions that generate version records. 939 940 941 XACT_LONGEST_RUNNING_009_NAME=Longest Transaction Running Time 942 XACT_LONGEST_RUNNING_009_HELP=The longest running time of any transcation in seconds. 943 944 945 XACT_UPD_CONFLICTS_RATIO_009_NAME=Update conflict ratio 946 XACT_UPD_CONFLICTS_RATIO_009_HELP=The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions. 947 948 949 XACT_UPD_CONFLICTS_RATIO_BASE_009_NAME=Update conflict ratio base 950 XACT_UPD_CONFLICTS_RATIO_BASE_009_HELP=The total number of update snapshot transactions. 951 952 953 XACT_TEMPDB_FREE_SPACE_009_NAME=Free Space in tempdb (KB) 954 XACT_TEMPDB_FREE_SPACE_009_HELP=The free space in tempdb in KB. 955 956 957 XACT_VER_STORE_GEN_RATE_009_NAME=Version Generation rate (KB/s) 958 XACT_VER_STORE_GEN_RATE_009_HELP=The version generation rate in KB per seconds. 959 960 961 XACT_VER_STORE_CLEANUP_RATE_009_NAME=Version Cleanup rate (KB/s) 962 XACT_VER_STORE_CLEANUP_RATE_009_HELP=The version cleanup rate in KB per seconds. 963 964 965 XACT_VER_STORE_SIZE_009_NAME=Version Store Size (KB) 966 XACT_VER_STORE_SIZE_009_HELP=The size of the version store in KB. 967 968 969 XACT_VER_STORE_UNIT_COUNT_009_NAME=Version Store unit count 970 XACT_VER_STORE_UNIT_COUNT_009_HELP=Number of unit in Version Store. 971 972 973 XACT_VER_STORE_UNIT_CREATION_009_NAME=Version Store unit creation 974 XACT_VER_STORE_UNIT_CREATION_009_HELP=Creation of new unit in Version Store. 975 976 977 XACT_VER_STORE_UNIT_TRUNCATION_009_NAME=Version Store unit truncation 978 XACT_VER_STORE_UNIT_TRUNCATION_009_HELP=Truncation of unit in Version Store. 979 980 981 BO_SEND_RATE_009_NAME=SQL SENDs/sec 982 BO_SEND_RATE_009_HELP=The number of SQL SEND commands processed by the Broker per second. 983 984 985 BO_TOTAL_SENDS_009_NAME=SQL SEND Total 986 BO_TOTAL_SENDS_009_HELP=Total number of SQL SEND commands processed by the Broker. 987 988 989 BO_RECEIVE_RATE_009_NAME=SQL RECEIVEs/sec 990 BO_RECEIVE_RATE_009_HELP=The number of SQL RECEIVE commands processed by the Broker per second. 991 992 993 BO_TOTAL_RECEIVES_009_NAME=SQL RECEIVE Total 994 BO_TOTAL_RECEIVES_009_HELP=Total number of SQL RECEIVE commands processed by the Broker. 995 996 997 BO_XACT_ROLLBACKS_009_NAME=Broker Transaction Rollbacks 998 BO_XACT_ROLLBACKS_009_HELP=The number of Service Broker related transactions that have rolled back. 999 1000 1001 BO_DEP_TIMER_EVENTS_009_NAME=Dialog Timer Event Count 1002 BO_DEP_TIMER_EVENTS_009_HELP=The number of dialog endpoint related timer events in the Broker. 1003 1004 1005 BO_ENQUEUED_MSG_RATE_009_NAME=Enqueued Messages/sec 1006 BO_ENQUEUED_MSG_RATE_009_HELP=The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second. 1007 1008 1009 BO_ENQUEUED_LOCAL_MSG_RATE_009_NAME=Enqueued Local Messages/sec 1010 BO_ENQUEUED_LOCAL_MSG_RATE_009_HELP=The number of messages from local endpoints that are successfully delivered as ready into queues per second. 1011 1012 1013 BO_ENQUEUED_TRANSPORT_MSG_RATE_009_NAME=Enqueued Transport Msgs/sec 1014 BO_ENQUEUED_TRANSPORT_MSG_RATE_009_HELP=The number of messages from the transport that are successfully delivered as ready into queues per second. 1015 1016 1017 BO_ENQUEUED_TRANSPORT_FRAG_RATE_009_NAME=Enqueued Transport Msg Frags/sec 1018 BO_ENQUEUED_TRANSPORT_FRAG_RATE_009_HELP=The number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled. 1019 1020 1021 BO_ENQUEUED_MSGS_TOTAL_009_NAME=Enqueued Messages Total 1022 BO_ENQUEUED_MSGS_TOTAL_009_HELP=Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues. 1023 1024 1025 BO_ENQUEUED_LOCAL_MSGS_TOTAL_009_NAME=Enqueued Local Messages Total 1026 BO_ENQUEUED_LOCAL_MSGS_TOTAL_009_HELP=Total number of message fragments from local endpoints that are successfully delivered as ready into queues. 1027 1028 1029 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_009_NAME=Enqueued Transport Msgs Total 1030 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_009_HELP=Total number of messages from the transport that are successfully delivered as ready into queues. 1031 1032 1033 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_009_NAME=Enqueued Transport Msg Frag Tot 1034 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_009_HELP=Total number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled. 1035 1036 1037 BO_FORWARDED_PENDING_MSGS_009_NAME=Forwarded Pending Msg Count 1038 BO_FORWARDED_PENDING_MSGS_009_HELP=The number of forwarded messages that have not been successfully sent yet. 1039 1040 1041 BO_FORWARDED_PENDING_MSG_BYTES_009_NAME=Forwarded Pending Msg Bytes 1042 BO_FORWARDED_PENDING_MSG_BYTES_009_HELP=The number of forwarded message bytes that have not been successfully sent yet. 1043 1044 1045 BO_FORWARDED_DISCARDED_MSG_RATE_009_NAME=Forwarded Msgs Discarded/sec 1046 BO_FORWARDED_DISCARDED_MSG_RATE_009_HELP=The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc. 1047 1048 1049 BO_FORWARDED_DISCARDED_MSG_TOTAL_009_NAME=Forwarded Msg Discarded Total 1050 BO_FORWARDED_DISCARDED_MSG_TOTAL_009_HELP=Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc. 1051 1052 1053 BO_FORWARDED_MSG_RATE_009_NAME=Forwarded Messages/sec 1054 BO_FORWARDED_MSG_RATE_009_HELP=The number of forwarded messages successfully sent per second. 1055 1056 1057 BO_FORWARDED_MSG_TOTAL_009_NAME=Forwarded Messages Total 1058 BO_FORWARDED_MSG_TOTAL_009_HELP=Total number of forwarded messages successfully sent. 1059 1060 1061 BO_FORWARDED_MSG_BYTE_RATE_009_NAME=Forwarded Msg Bytes/sec 1062 BO_FORWARDED_MSG_BYTE_RATE_009_HELP=The number of forwarded message bytes successfully sent per second. 1063 1064 1065 BO_FORWARDED_MSG_BYTE_TOTAL_009_NAME=Forwarded Msg Byte Total 1066 BO_FORWARDED_MSG_BYTE_TOTAL_009_HELP=Total number of forwarded message bytes successfully sent. 1067 1068 1069 BTO_OPEN_CONNECTIONS_009_NAME=Open Connection Count 1070 BTO_OPEN_CONNECTIONS_009_HELP=The total number of transport connections currently open. 1071 1072 1073 BTO_SEND_IO_RATE_009_NAME=Send I/Os/sec 1074 BTO_SEND_IO_RATE_009_HELP=The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment. 1075 1076 1077 BTO_SEND_IO_BYTE_RATE_009_NAME=Send I/O bytes/sec 1078 BTO_SEND_IO_BYTE_RATE_009_HELP=The number of transport send I/O bytes per second. 1079 1080 1081 BTO_SEND_IO_LEN_AVG_009_NAME=Send I/O Len Avg 1082 BTO_SEND_IO_LEN_AVG_009_HELP=The average byte length of transport send I/O operations. 1083 1084 1085 BTO_SEND_IO_LEN_AVG_BASE_009_NAME=Send I/O Len Avg Base 1086 BTO_SEND_IO_LEN_AVG_BASE_009_HELP=Base for the average byte length of transport send I/O operations. 1087 1088 1089 BTO_RECEIVE_IO_RATE_009_NAME=Receive I/Os/sec 1090 BTO_RECEIVE_IO_RATE_009_HELP=The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment. 1091 1092 1093 BTO_RECEIVE_IO_BYTE_RATE_009_NAME=Receive I/O bytes/sec 1094 BTO_RECEIVE_IO_BYTE_RATE_009_HELP=The number of transport receive I/O bytes per second. 1095 1096 1097 BTO_RECV_IO_LEN_AVG_009_NAME=Receive I/O Len Avg 1098 BTO_RECV_IO_LEN_AVG_009_HELP=The average byte length of transport receive I/O operations. 1099 1100 1101 BTO_RECV_IO_LEN_AVG_BASE_009_NAME=Receive I/O Len Avg Base 1102 BTO_RECV_IO_LEN_AVG_BASE_009_HELP=Base for the average byte length of transport receive I/O operations. 1103 1104 1105 BTO_SEND_FRAG_RATE_009_NAME=Message Fragment Sends/sec 1106 BTO_SEND_FRAG_RATE_009_HELP=The number of message fragments sent per second in transport send I/O operations. 1107 1108 1109 BTO_SEND_FRAG_SIZE_AVG_009_NAME=Msg Fragment Send Size Avg 1110 BTO_SEND_FRAG_SIZE_AVG_009_HELP=The average byte size of message fragments sent in transport send I/O operations. 1111 1112 1113 BTO_SEND_FRAG_SIZE_AVG_BASE_009_NAME=Msg Fragment Send Size Avg Base 1114 BTO_SEND_FRAG_SIZE_AVG_BASE_009_HELP=Base for the average byte size of message fragments sent in transport send I/O operations. 1115 1116 1117 BTO_RECEIVE_FRAG_RATE_009_NAME=Message Fragment Receives/sec 1118 BTO_RECEIVE_FRAG_RATE_009_HELP=The number of message fragments received per second in transport receive I/O operations. 1119 1120 1121 BTO_RECV_FRAG_SIZE_AVG_009_NAME=Msg Fragment Recv Size Avg 1122 BTO_RECV_FRAG_SIZE_AVG_009_HELP=The average byte size of message fragments received in transport receive I/O operations. 1123 1124 1125 BTO_RECV_FRAG_SIZE_AVG_BASE_009_NAME=Msg Fragment Recv Size Avg Base 1126 BTO_RECV_FRAG_SIZE_AVG_BASE_009_HELP=Base for the average byte size of message fragments received in transport receive I/O operations. 1127 1128 1129 BTO_SEND_IO_PEND_FRAG_COUNT_009_NAME=Pending Msg Frags for Send I/O 1130 BTO_SEND_IO_PEND_FRAG_COUNT_009_HELP=The current number of message fragments that are being marshalled, or marshalled and ready to be sent via the transport layer. 1131 1132 1133 BTO_SEND_IO_CURR_FRAG_COUNT_009_NAME=Current Msg Frags for Send I/O 1134 BTO_SEND_IO_CURR_FRAG_COUNT_009_HELP=The current number of message fragments associated with current transport send I/O operations that haven't completed. 1135 1136 1137 BTO_SEND_IO_PEND_BYTES_009_NAME=Pending Bytes for Send I/O 1138 BTO_SEND_IO_PEND_BYTES_009_HELP=The number of buffer bytes associated with message fragments being marshalled, or marshalled and ready to be sent with send I/O operations. 1139 1140 1141 BTO_SEND_IO_CURR_BYTES_009_NAME=Current Bytes for Send I/O 1142 BTO_SEND_IO_CURR_BYTES_009_HELP=The number of buffer bytes associated with current transport send I/O operations that haven't completed. 1143 1144 1145 BTO_RECV_IO_PEND_FRAG_COUNT_009_NAME=Pending Msg Frags for Recv I/O 1146 BTO_RECV_IO_PEND_FRAG_COUNT_009_HELP=The current number of message fragments received in transport receive I/O operations that have not been enqueued (or rejected) yet. 1147 1148 1149 BTO_RECV_IO_CURR_BYTES_009_NAME=Current Bytes for Recv I/O 1150 BTO_RECV_IO_CURR_BYTES_009_HELP=The number of bytes associated with current transport receive I/O operations that haven't completed. 1151 1152 1153 BTO_RECV_IO_PEND_BYTES_009_NAME=Pending Bytes for Recv I/O 1154 BTO_RECV_IO_PEND_BYTES_009_HELP=The number of bytes associated with in completed transport receive I/O operations whose message fragments haven't been enqueued (or rejected) yet. 1155 1156 1157 BTO_RECV_IO_COMPACT_MFB_009_NAME=Recv I/O Buffer Copies Count 1158 BTO_RECV_IO_COMPACT_MFB_009_HELP=The number of times when transport receive I/O operations had to move buffer fragments in memory. 1159 1160 1161 BTO_RECV_IO_COMPACT_MFB_RATE_009_NAME=Recv I/O Buffer Copies bytes/sec 1162 BTO_RECV_IO_COMPACT_MFB_RATE_009_HELP=The rate at witch transport receive I/O operations had to move buffer fragments in memory. 1163 1164 1165 BAO_TASK_START_RATE_009_NAME=Tasks Started/sec 1166 BAO_TASK_START_RATE_009_HELP=The number of activated tasks that are being started per second. 1167 1168 1169 BAO_TASKS_RUNNING_009_NAME=Tasks Running 1170 BAO_TASKS_RUNNING_009_HELP=The total number of activated tasks that are currently running. 1171 1172 1173 BAO_TASK_ABORT_RATE_009_NAME=Tasks Aborted/sec 1174 BAO_TASK_ABORT_RATE_009_HELP=The number of activated tasks that are being aborted per second. 1175 1176 1177 BAO_TASK_LIMIT_RATE_009_NAME=Task Limit Reached/sec 1178 BAO_TASK_LIMIT_RATE_009_HELP=The number of times the activated task limit on a queue has been reached per second. 1179 1180 1181 BAO_TASK_LIMIT_REACHED_009_NAME=Task Limit Reached 1182 BAO_TASK_LIMIT_REACHED_009_HELP=The total number of times the activated task limit on a queue has been reached. 1183 1184 1185 BAO_SP_INVOKE_RATE_009_NAME=Stored Procedures Invoked/sec 1186 BAO_SP_INVOKE_RATE_009_HELP=The number of stored procedures that are being invoked per second. 1187 1188 1189 WAITSTATS_LOCKS_009_NAME=Lock waits 1190 WAITSTATS_LOCKS_009_HELP=Statistics for processes waiting on a lock. 1191 1192 1193 WAITSTATS_RESOURCE_009_NAME=Memory grant queue waits 1194 WAITSTATS_RESOURCE_009_HELP=Statistics for processes waiting for memory grant to become available. 1195 1196 1197 WAITSTATS_MEMTHREAD_009_NAME=Thread-safe memory objects waits 1198 WAITSTATS_MEMTHREAD_009_HELP=Statistics for processes waiting on thread-safe memory allocators. 1199 1200 1201 WAITSTATS_WRITELOG_009_NAME=Log write waits 1202 WAITSTATS_WRITELOG_009_HELP=Statistics for processes waiting for log buffer to be written. 1203 1204 1205 WAITSTATS_LOGBUFFER_009_NAME=Log buffer waits 1206 WAITSTATS_LOGBUFFER_009_HELP=Statistics for processes waiting for log buffer to be available. 1207 1208 1209 WAITSTATS_NETWORKIO_009_NAME=Network IO waits 1210 WAITSTATS_NETWORKIO_009_HELP=Statistics relevant to wait on network IO. 1211 1212 1213 WAITSTATS_PAGEIOLATCH_009_NAME=Page IO latch waits 1214 WAITSTATS_PAGEIOLATCH_009_HELP=Statistics relevant to page IO latches. 1215 1216 1217 WAITSTATS_PAGELATCH_009_NAME=Page latch waits 1218 WAITSTATS_PAGELATCH_009_HELP=Statistics relevant to page latches, not including IO latches 1219 1220 1221 WAITSTATS_NPAGELATCH_009_NAME=Non-Page latch waits 1222 WAITSTATS_NPAGELATCH_009_HELP=Statistics relevant to non-page latches. 1223 1224 1225 WAITSTATS_SOS_WORKER_009_NAME=Wait for the worker 1226 WAITSTATS_SOS_WORKER_009_HELP=Statistics relevant to processes waiting for worker to become available. 1227 1228 1229 WAITSTATS_XACTWORKSPACE_009_NAME=Workspace synchronization waits 1230 WAITSTATS_XACTWORKSPACE_009_HELP=Statistics relevant to processes synchronizing access to workspace. 1231 1232 1233 WAITSTATS_TRANSACTION_009_NAME=Transaction ownership waits 1234 WAITSTATS_TRANSACTION_009_HELP=Statistics relevant to processes synchronizing access to transaction. 1235 1236 1237 EXECSTATS_MSQL_XP_009_NAME=Extended Procedures 1238 EXECSTATS_MSQL_XP_009_HELP=Statistics relevant to execution of XP calls. 1239 1240 1241 EXECSTATS_DTC_009_NAME=DTC calls 1242 EXECSTATS_DTC_009_HELP=Statistics relevant to execution of DTC calls. 1243 1244 1245 EXECSTATS_OLEDB_009_NAME=OLEDB calls 1246 EXECSTATS_OLEDB_009_HELP=Statistics relevant to execution of OLEDB calls. 1247 1248 1249 EXECSTATS_DQ_009_NAME=Distributed Query 1250 EXECSTATS_DQ_009_HELP=Statistics relevant to execution of distributed queries. 1251 1252 1253 SQLCLR_TOTAL_EXECTIME_009_NAME=CLR Execution 1254 SQLCLR_TOTAL_EXECTIME_009_HELP=Total Execution time in CLR ( microseconds ). 1255 1256 1257 MD_CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio 1258 MD_CACHE_HIT_RATIO_009_HELP=Ratio between catalog metadata cache hits and lookups 1259 1260 1261 MD_CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base 1262 MD_CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry 1263 1264 1265 MD_CACHE_ENTRY_COUNT_009_NAME=Cache Entries Count 1266 MD_CACHE_ENTRY_COUNT_009_HELP=Number of entries in the catalog metadata cache 1267 1268 1269 MD_CACHE_PINNED_COUNT_009_NAME=Cache Entries Pinned Count 1270 MD_CACHE_PINNED_COUNT_009_HELP=Number of catalog metadata cache entries that are pinned 1271 1272 1273 BUFMGR_OBJECT_004_NAME=SQLServer:Buffer Manager 1274 BUFMGR_OBJECT_004_HELP=与 SQL Server 缓冲区管理器有关的统计信息 1275 1276 1277 BUFPART_OBJECT_004_NAME=SQLServer:Buffer Partition 1278 BUFPART_OBJECT_004_HELP=与 SQL Server 的缓冲区分区有关的统计信息 1279 1280 1281 BUFNODE_OBJECT_004_NAME=SQLServer:Buffer Node 1282 BUFNODE_OBJECT_004_HELP=按 NUMA 节点列出的与 SQL Server 的缓冲池相关的统计信息 1283 1284 1285 GENERAL_OBJECT_004_NAME=SQLServer:General Statistics 1286 GENERAL_OBJECT_004_HELP=服务器常规统计信息 1287 1288 1289 LOCKS_OBJECT_004_NAME=SQLServer:Locks 1290 LOCKS_OBJECT_004_HELP=描述锁定服务器的各个锁请求的统计信息 1291 1292 1293 DBMGR_OBJECT_004_NAME=SQLServer:Databases 1294 DBMGR_OBJECT_004_HELP=它为 SQL Server 定义数据库管理器对象 1295 1296 1297 DBMIRRORING_OBJECT_004_NAME=SQLServer:Database Mirroring 1298 DBMIRRORING_OBJECT_004_HELP=它为 SQL Server 定义数据库镜像对象 1299 1300 1301 LATCH_OBJECT_004_NAME=SQLServer:Latches 1302 LATCH_OBJECT_004_HELP=收集与内部服务器闩锁相关的统计信息 1303 1304 1305 ACCESS_METHODS_OBJECT_004_NAME=SQLServer:Access Methods 1306 ACCESS_METHODS_OBJECT_004_HELP=收集与数据库服务器访问方法相关的统计信息 1307 1308 1309 SQL_ERROR_OBJECT_004_NAME=SQLServer:SQL Errors 1310 SQL_ERROR_OBJECT_004_HELP=有关 SQL Server 中错误的统计信息 1311 1312 1313 SQL_OBJECT_004_NAME=SQLServer:SQL Statistics 1314 SQL_OBJECT_004_HELP=收集与 SQL 请求相关的统计信息 1315 1316 1317 PLAN_CACHE_004_NAME=SQLServer:Plan Cache 1318 PLAN_CACHE_004_HELP=它定义缓存计数器 1319 1320 1321 CURSOR_OBJECT_BY_TYPE_004_NAME=SQLServer:Cursor Manager by Type 1322 CURSOR_OBJECT_BY_TYPE_004_HELP=按类型分组的游标属性的计数器 1323 1324 1325 CURSOR_OBJECT_TOTAL_004_NAME=SQLServer:Cursor Manager Total 1326 CURSOR_OBJECT_TOTAL_004_HELP=未按类型分组的游标属性的计数器 1327 1328 1329 MEMORY_OBJECT_004_NAME=SQLServer:Memory Manager 1330 MEMORY_OBJECT_004_HELP=它定义内存的使用情况。 1331 1332 1333 USER_QUERY_OBJECT_004_NAME=SQLServer:User Settable 1334 USER_QUERY_OBJECT_004_HELP=它定义用户可定义的计数器 1335 1336 1337 REPLICATION_AGENT_OBJECT_004_NAME=SQLServer:Replication Agents 1338 REPLICATION_AGENT_OBJECT_004_HELP=复制摘要 1339 1340 1341 MERGE_AGENT_OBJECT_004_NAME=SQLServer:Replication Merge 1342 MERGE_AGENT_OBJECT_004_HELP=复制合并代理统计信息 1343 1344 1345 LOGREADER_AGENT_OBJECT_004_NAME=SQLServer:Replication Logreader 1346 LOGREADER_AGENT_OBJECT_004_HELP=复制日志读取器代理统计信息 1347 1348 1349 DISTRIBUTION_AGENT_OBJECT_004_NAME=SQLServer:Replication Dist. 1350 DISTRIBUTION_AGENT_OBJECT_004_HELP=复制分发代理统计信息 1351 1352 1353 SNAPSHOT_AGENT_OBJECT_004_NAME=SQLServer:Replication Snapshot 1354 SNAPSHOT_AGENT_OBJECT_004_HELP=复制快照代理统计信息 1355 1356 1357 BACKUP_DEV_OBJECT_004_NAME=SQLServer:Backup Device 1358 BACKUP_DEV_OBJECT_004_HELP=它定义 SQL Server 的备份设备对象 1359 1360 1361 XACT_OBJECT_004_NAME=SQLServer:Transactions 1362 XACT_OBJECT_004_HELP=与 SQL Server 事务有关的统计信息。 1363 1364 1365 BROKER_OBJECT_004_NAME=SQLServer:Broker Statistics 1366 BROKER_OBJECT_004_HELP=Service Broker 统计信息 1367 1368 1369 BROKER_TRANSPORT_OBJECT_004_NAME=SQLServer:Broker/DBM Transport 1370 BROKER_TRANSPORT_OBJECT_004_HELP=Service Broker/数据库镜像传输统计信息 1371 1372 1373 BROKER_ACTIVATION_OBJECT_004_NAME=SQLServer:Broker Activation 1374 BROKER_ACTIVATION_OBJECT_004_HELP=Service Broker 激活 1375 1376 1377 WAITSTATS_OBJECT_004_NAME=SQLServer:Wait Statistics 1378 WAITSTATS_OBJECT_004_HELP=等待统计信息 1379 1380 1381 EXECSTATS_OBJECT_004_NAME=SQLServer:Exec Statistics 1382 EXECSTATS_OBJECT_004_HELP=外部调用的执行统计信息 1383 1384 1385 SQLCLR_OBJECT_004_NAME=SQLServer:CLR 1386 SQLCLR_OBJECT_004_HELP=在 SQL Server 中执行 CLR 1387 1388 1389 METADATAMGR_OBJECT_004_NAME=SQLServer:Catalog Metadata 1390 METADATAMGR_OBJECT_004_HELP=定义 SQL Server 的目录元数据管理器对象 1391 1392 1393 BUF_CACHE_HIT_RATIO_004_NAME=Buffer cache hit ratio 1394 BUF_CACHE_HIT_RATIO_004_HELP=可在缓冲池中找到而不必从磁盘读取的页所占的百分比。 1395 1396 1397 BUF_CACHE_RATIO_BASE_004_NAME=Buffer cache hit ratio base 1398 BUF_CACHE_RATIO_BASE_004_HELP=优先项的基数 1399 1400 1401 BUF_PAGE_REQUESTS_004_NAME=Page lookups/sec 1402 BUF_PAGE_REQUESTS_004_HELP=要求在缓冲池中查找页的请求数。 1403 1404 1405 BUF_FREELIST_STALLS_004_NAME=Free list stalls/sec 1406 BUF_FREELIST_STALLS_004_HELP=必须等待可用页的请求数。 1407 1408 1409 BUF_NUM_FREE_BUFFERS_004_NAME=Free pages 1410 BUF_NUM_FREE_BUFFERS_004_HELP=所有可用列表的总页数。 1411 1412 1413 BUF_COMMITTED_PAGE_COUNT_004_NAME=Total pages 1414 BUF_COMMITTED_PAGE_COUNT_004_HELP=缓冲池中的页数(包括数据库页、可用页和被盗页)。 1415 1416 1417 BUF_TARGET_PAGE_COUNT_004_NAME=Target pages 1418 BUF_TARGET_PAGE_COUNT_004_HELP=缓冲池中理想的页数。 1419 1420 1421 BUF_HASHED_PAGE_COUNT_004_NAME=Database pages 1422 BUF_HASHED_PAGE_COUNT_004_HELP=缓冲池中有数据库内容的页数。 1423 1424 1425 BUF_RESERVED_PAGE_COUNT_004_NAME=Reserved pages 1426 BUF_RESERVED_PAGE_COUNT_004_HELP=缓冲池保留的页数。 1427 1428 1429 BUF_STOLEN_PAGE_COUNT_004_NAME=Stolen pages 1430 BUF_STOLEN_PAGE_COUNT_004_HELP=用于其他服务器用途(包括过程缓存)的页数。 1431 1432 1433 BUF_LAZY_WRITES_004_NAME=Lazy writes/sec 1434 BUF_LAZY_WRITES_004_HELP=缓冲区管理器的惰性编写器写入的缓冲区数。 1435 1436 1437 BUF_READAHEAD_PAGES_004_NAME=Readahead pages/sec 1438 BUF_READAHEAD_PAGES_004_HELP=为预期使用读取的页数。 1439 1440 1441 BUF_BLOCK_READS_004_NAME=Page reads/sec 1442 BUF_BLOCK_READS_004_HELP=执行的物理数据库页读取数。 1443 1444 1445 BUF_BLOCK_WRITES_004_NAME=Page writes/sec 1446 BUF_BLOCK_WRITES_004_HELP=执行的物理数据库页写入数。 1447 1448 1449 BUF_CHECKPOINT_WRITES_004_NAME=Checkpoint pages/sec 1450 BUF_CHECKPOINT_WRITES_004_HELP=检查点或其他要求刷新全部脏页的操作所刷新的页数。 1451 1452 1453 BUF_AWE_LOOKUP_MAPS_004_NAME=AWE lookup maps/sec 1454 BUF_AWE_LOOKUP_MAPS_004_HELP=对在缓冲池中找到的页进行 AWE 映射调用的数目。 1455 1456 1457 BUF_AWE_STOLEN_MAPS_004_NAME=AWE stolen maps/sec 1458 BUF_AWE_STOLEN_MAPS_004_HELP=对从缓冲池盗用的页进行 AWE 映射调用的数目。 1459 1460 1461 BUF_AWE_WRITE_MAPS_004_NAME=AWE write maps/sec 1462 BUF_AWE_WRITE_MAPS_004_HELP=对要写入磁盘的页进行 AWE 映射调用的数目。 1463 1464 1465 BUF_AWE_UNMAP_CALLS_004_NAME=AWE unmap calls/sec 1466 BUF_AWE_UNMAP_CALLS_004_HELP=AWE 取消映射调用的数目。 1467 1468 1469 BUF_AWE_UNMAP_PAGES_004_NAME=AWE unmap pages/sec 1470 BUF_AWE_UNMAP_PAGES_004_HELP=取消映射的 AWE 页数。 1471 1472 1473 BUF_LIFE_EXPECTANCY_004_NAME=Page life expectancy 1474 BUF_LIFE_EXPECTANCY_004_HELP=没有引用的页停留在缓冲池中的时间(秒)。 1475 1476 1477 BUFPART_NUM_FREE_BUFFERS_004_NAME=Free pages 1478 BUFPART_NUM_FREE_BUFFERS_004_HELP=分区可用列表中的页数。 1479 1480 1481 BUFPART_FREE_BUFFERS_USED_004_NAME=Free list requests/sec 1482 BUFPART_FREE_BUFFERS_USED_004_HELP=请求可用页的次数。 1483 1484 1485 BUFPART_FREE_BUFFERS_EMPTY_004_NAME=Free list empty/sec 1486 BUFPART_FREE_BUFFERS_EMPTY_004_HELP=曾请求可用页但没有任何可用页的次数。 1487 1488 1489 BUFNODE_NUM_FREE_BUFFERS_004_NAME=Free pages 1490 BUFNODE_NUM_FREE_BUFFERS_004_HELP=节点上的空闲页数。 1491 1492 1493 BUFNODE_COMMITTED_PAGE_COUNT_004_NAME=Total pages 1494 BUFNODE_COMMITTED_PAGE_COUNT_004_HELP=节点上已提交的页数。 1495 1496 1497 BUFNODE_FOREIGN_PAGE_COUNT_004_NAME=Foreign pages 1498 BUFNODE_FOREIGN_PAGE_COUNT_004_HELP=不是 NUMA 本地内存中的页数。 1499 1500 1501 BUFNODE_HASHED_PAGE_COUNT_004_NAME=Database pages 1502 BUFNODE_HASHED_PAGE_COUNT_004_HELP=节点上的数据库页数。 1503 1504 1505 BUFNODE_STOLEN_PAGE_COUNT_004_NAME=Stolen pages 1506 BUFNODE_STOLEN_PAGE_COUNT_004_HELP=节点上的被盗用页数。 1507 1508 1509 BUFNODE_TARGET_PAGE_COUNT_004_NAME=Target pages 1510 BUFNODE_TARGET_PAGE_COUNT_004_HELP=节点上的目标页数。 1511 1512 1513 BUFNODE_LIFE_EXPECTANCY_004_NAME=Page life expectancy 1514 BUFNODE_LIFE_EXPECTANCY_004_HELP=没有引用的页停留在缓冲池中的时间(秒)。 1515 1516 1517 GO_TEMP_TABLES_IN_USE_004_NAME=Active Temp Tables 1518 GO_TEMP_TABLES_IN_USE_004_HELP=正在使用的临时表/表变量的数目 1519 1520 1521 GO_TEMP_TABLES_CREATION_RATE_004_NAME=Temp Tables Creation Rate 1522 GO_TEMP_TABLES_CREATION_RATE_004_HELP=每秒创建的临时表/表变量的数目 1523 1524 1525 GO_LOGINS_004_NAME=Logins/sec 1526 GO_LOGINS_004_HELP=每秒启动的登录总数。 1527 1528 1529 GO_LOGOUTS_004_NAME=Logouts/sec 1530 GO_LOGOUTS_004_HELP=每秒启动的注销总数。 1531 1532 1533 GO_USER_CONNECTIONS_004_NAME=User Connections 1534 GO_USER_CONNECTIONS_004_HELP=连接到系统的用户数。 1535 1536 1537 GO_LOGICAL_CONNECTIONS_004_NAME=Logical Connections 1538 GO_LOGICAL_CONNECTIONS_004_HELP=与系统建立的逻辑连接数。 1539 1540 1541 GO_TRANSACTIONS_004_NAME=Transactions 1542 GO_TRANSACTIONS_004_HELP=事务登记(本地、dtc 和绑定的事务)的数目。 1543 1544 1545 GO_NON_ATOMIC_YIELD_RATE_004_NAME=Non-atomic yield rate 1546 GO_NON_ATOMIC_YIELD_RATE_004_HELP=每秒的非原子生成数。 1547 1548 1549 GO_MARS_DEADLOCKS_DETECTED_004_NAME=Mars Deadlocks 1550 GO_MARS_DEADLOCKS_DETECTED_004_HELP=检测到的 Mars 死锁数。 1551 1552 1553 GO_HTTP_AUTH_REQS_004_NAME=HTTP Authenticated Requests 1554 GO_HTTP_AUTH_REQS_004_HELP=每秒启动的验证过的 HTTP 请求数。 1555 1556 1557 GO_SOAP_EMPTY_REQS_004_NAME=SOAP Empty Requests 1558 GO_SOAP_EMPTY_REQS_004_HELP=每秒启动的空 SOAP 请求数。 1559 1560 1561 GO_SOAP_QUERY_REQS_004_NAME=SOAP SQL Requests 1562 GO_SOAP_QUERY_REQS_004_HELP=每秒启动的 SOAP SQL 请求数。 1563 1564 1565 GO_SOAP_SP_REQS_004_NAME=SOAP Method Invocations 1566 GO_SOAP_SP_REQS_004_HELP=每秒启动的 SOAP 方法调用数。 1567 1568 1569 GO_SOAP_WSDL_REQS_004_NAME=SOAP WSDL Requests 1570 GO_SOAP_WSDL_REQS_004_HELP=每秒启动的 SOAP Web 服务描述语言请求数。 1571 1572 1573 GO_SOAP_SESSION_INITIATES_004_NAME=SOAP Session Initiate Requests 1574 GO_SOAP_SESSION_INITIATES_004_HELP=每秒启动的 SOAP 会话启动请求数。 1575 1576 1577 GO_SOAP_SESSION_TERMINATES_004_NAME=SOAP Session Terminate Requests 1578 GO_SOAP_SESSION_TERMINATES_004_HELP=每秒启动的 SOAP 会话终止请求数。 1579 1580 1581 GO_USERS_BLOCKED_004_NAME=Processes blocked 1582 GO_USERS_BLOCKED_004_HELP=当前阻塞的进程数。 1583 1584 1585 GO_TEMP_TABLES_FOR_DESTRUCTION_004_NAME=Temp Tables For Destruction 1586 GO_TEMP_TABLES_FOR_DESTRUCTION_004_HELP=等待被清除系统线程破坏的临时表/表变量数 1587 1588 1589 GO_EVT_NOTIF_DELAYED_DROP_004_NAME=Event Notifications Delayed Drop 1590 GO_EVT_NOTIF_DELAYED_DROP_004_HELP=等待某个系统线程删除的事件通知数 1591 1592 1593 GO_TRACE_EVT_NOTIF_QUEUE_SIZE_004_NAME=Trace Event Notification Queue 1594 GO_TRACE_EVT_NOTIF_QUEUE_SIZE_004_HELP=在内部队列中等待通过 Service Broker 发送的跟踪事件通知实例数 1595 1596 1597 GO_TRACE_IO_PROVIDER_EVENTLOCK_004_NAME=SQL Trace IO Provider Lock Waits 1598 GO_TRACE_IO_PROVIDER_EVENTLOCK_004_HELP=每秒等待 File IO Provider 锁的次数 1599 1600 1601 LCK_NUM_REQUESTS_004_NAME=Lock Requests/sec 1602 LCK_NUM_REQUESTS_004_HELP=从锁管理器请求的新锁和锁转换的数目。 1603 1604 1605 LCK_NUM_TIMEOUTS_004_NAME=Lock Timeouts/sec 1606 LCK_NUM_TIMEOUTS_004_HELP=超时的锁请求数。这包括对 NOWAIT 锁的请求。 1607 1608 1609 LCK_NUM_DEADLOCKS_004_NAME=Number of Deadlocks/sec 1610 LCK_NUM_DEADLOCKS_004_HELP=导致死锁的锁请求数。 1611 1612 1613 LCK_NUM_WAITS_004_NAME=Lock Waits/sec 1614 LCK_NUM_WAITS_004_HELP=不能立即满足而要求调用方等待授予锁的锁请求数。 1615 1616 1617 LCK_TOTAL_WAITTIME_004_NAME=Lock Wait Time (ms) 1618 LCK_TOTAL_WAITTIME_004_HELP=在上一秒钟内锁的总等待时间(毫秒)。 1619 1620 1621 LCK_AVERAGE_WAITTIME_004_NAME=Average Wait Time (ms) 1622 LCK_AVERAGE_WAITTIME_004_HELP=导致等待的每个锁请求的平均等待时间(毫秒)。 1623 1624 1625 LCK_AVERAGE_WAITTIME_BASE_004_NAME=Average Wait Time Base 1626 LCK_AVERAGE_WAITTIME_BASE_004_HELP=平均等待时间的基数。 1627 1628 1629 LCK_NUM_TIMEOUTS_NONPROBE_004_NAME=Lock Timeouts (timeout > 0)/sec 1630 LCK_NUM_TIMEOUTS_NONPROBE_004_HELP=超时的锁请求数。这不包括对 NOWAIT 锁的请求。 1631 1632 1633 DB_DATA_SIZE_004_NAME=Data File(s) Size (KB) 1634 DB_DATA_SIZE_004_HELP=数据库中所有数据文件的累积大小。 1635 1636 1637 DB_LOG_SIZE_004_NAME=Log File(s) Size (KB) 1638 DB_LOG_SIZE_004_HELP=数据库中所有日志文件的累积大小。 1639 1640 1641 DB_LOG_USED_004_NAME=Log File(s) Used Size (KB) 1642 DB_LOG_USED_004_HELP=数据库中所有日志文件的累积已用大小。 1643 1644 1645 DB_LOG_USED_PERCENT_004_NAME=Percent Log Used 1646 DB_LOG_USED_PERCENT_004_HELP=日志中已用空间所占的百分比。 1647 1648 1649 DB_ACT_XTRAN_004_NAME=Active Transactions 1650 DB_ACT_XTRAN_004_HELP=数据库的活动更新事务数。 1651 1652 1653 DB_TOTAL_XTRAN_004_NAME=Transactions/sec 1654 DB_TOTAL_XTRAN_004_HELP=为数据库启动的事务数。 1655 1656 1657 DB_REPLTRANS_004_NAME=Repl. Pending Xacts 1658 DB_REPLTRANS_004_HELP=数据库中挂起的复制事务数。 1659 1660 1661 DB_REPLCOUNT_004_NAME=Repl. Trans. Rate 1662 DB_REPLCOUNT_004_HELP=复制事务速率(每秒的复制事务数)。 1663 1664 1665 DB_LOGCACHE_READS_004_NAME=Log Cache Reads/sec 1666 DB_LOGCACHE_READS_004_HELP=通过日志管理器缓存执行的读取数。 1667 1668 1669 DB_LOGCACHE_RATIO_004_NAME=Log Cache Hit Ratio 1670 DB_LOGCACHE_RATIO_004_HELP=日志缓存所满足的日志缓存读取数所占的百分比。 1671 1672 1673 DB_LOGCACHE_BASE_004_NAME=Log Cache Hit Ratio Base 1674 DB_LOGCACHE_BASE_004_HELP=日志缓存的计算基数 1675 1676 1677 DB_BULK_ROWS_004_NAME=Bulk Copy Rows/sec 1678 DB_BULK_ROWS_004_HELP=大容量复制的行数。 1679 1680 1681 DB_BULK_KILOBYTES_004_NAME=Bulk Copy Throughput/sec 1682 DB_BULK_KILOBYTES_004_HELP=大容量复制的千字节数。 1683 1684 1685 DB_BCK_DB_THROUGHPUT_004_NAME=Backup/Restore Throughput/sec 1686 DB_BCK_DB_THROUGHPUT_004_HELP=数据库备份/还原的读取/写入吞吐量。 1687 1688 1689 DB_DBCC_SCANRATE_004_NAME=DBCC Logical Scan Bytes/sec 1690 DB_DBCC_SCANRATE_004_HELP=DBCC 命令的逻辑读取扫描速率 1691 1692 1693 DB_DBCC_MOVERATE_004_NAME=Shrink Data Movement Bytes/sec 1694 DB_DBCC_MOVERATE_004_HELP=Autoshrink、DBCC SHRINKDATABASE 或 SHRINKFILE 移动数据的速率。 1695 1696 1697 DB_FLUSHES_004_NAME=Log Flushes/sec 1698 DB_FLUSHES_004_HELP=日志刷新数目。 1699 1700 1701 DB_BYTES_FLUSHED_004_NAME=Log Bytes Flushed/sec 1702 DB_BYTES_FLUSHED_004_HELP=刷新的日志字节总数。 1703 1704 1705 DB_FLUSH_WAITS_004_NAME=Log Flush Waits/sec 1706 DB_FLUSH_WAITS_004_HELP=等待日志刷新的提交数目。 1707 1708 1709 DB_FLUSH_WAIT_TIME_004_NAME=Log Flush Wait Time 1710 DB_FLUSH_WAIT_TIME_004_HELP=总等待时间(毫秒)。 1711 1712 1713 DB_LOG_TRUNCS_004_NAME=Log Truncations 1714 DB_LOG_TRUNCS_004_HELP=此数据库的日志截断总数。 1715 1716 1717 DB_LOG_GROWTHS_004_NAME=Log Growths 1718 DB_LOG_GROWTHS_004_HELP=此数据库的日志增长总数。 1719 1720 1721 DB_LOG_SHRINKS_004_NAME=Log Shrinks 1722 DB_LOG_SHRINKS_004_HELP=此数据库的日志收缩总数。 1723 1724 1725 DB_DBMIRRORING_BYTES_SENT_004_NAME=Bytes Sent/sec 1726 DB_DBMIRRORING_BYTES_SENT_004_HELP=每秒发送的字节数 1727 1728 1729 DB_DBMIRRORING_PAGES_SENT_004_NAME=Pages Sent/sec 1730 DB_DBMIRRORING_PAGES_SENT_004_HELP=每秒发送的页数 1731 1732 1733 DB_DBMIRRORING_SENDS_004_NAME=Sends/sec 1734 DB_DBMIRRORING_SENDS_004_HELP=每秒启动的发送数目 1735 1736 1737 DB_DBMIRRORING_TRANSACTION_DELAY_004_NAME=Transaction Delay 1738 DB_DBMIRRORING_TRANSACTION_DELAY_004_HELP=等待确认的事务终止操作的平均延迟时间 1739 1740 1741 DB_DBM_REDO_DELTA_004_NAME=Redo Queue KB 1742 DB_DBM_REDO_DELTA_004_HELP=镜像数据库的重做操作滞后于镜像日志的总字节数(KB) 1743 1744 1745 DB_DBM_REDO_RATE_004_NAME=Redo Bytes/sec 1746 DB_DBM_REDO_RATE_004_HELP=每秒由镜像数据库重做的日志字节数 1747 1748 1749 DB_DBM_LOG_SEND_QUEUE_004_NAME=Log Send Queue KB 1750 DB_DBM_LOG_SEND_QUEUE_004_HELP=尚未发送到镜像服务器的日志总字节数(KB) 1751 1752 1753 DB_DBM_BYTES_RECEIVED_004_NAME=Bytes Received/sec 1754 DB_DBM_BYTES_RECEIVED_004_HELP=每秒收到的字节数 1755 1756 1757 DB_DBM_RECEIVES_004_NAME=Receives/sec 1758 DB_DBM_RECEIVES_004_HELP=每秒收到的镜像消息数 1759 1760 1761 DB_DBM_LOG_BYTES_RECEIVED_004_NAME=Log Bytes Received/sec 1762 DB_DBM_LOG_BYTES_RECEIVED_004_HELP=每秒收到的日志字节数 1763 1764 1765 DB_DBM_LOG_BYTES_SENT_004_NAME=Log Bytes Sent/sec 1766 DB_DBM_LOG_BYTES_SENT_004_HELP=每秒发送的日志字节数 1767 1768 1769 DB_DBM_ACK_TIME_004_NAME=Send/Receive Ack Time 1770 DB_DBM_ACK_TIME_004_HELP=包每秒在流控制中等待的时间(毫秒)。 1771 1772 1773 LATCH_WAITS_NP_004_NAME=Latch Waits/sec 1774 LATCH_WAITS_NP_004_HELP=未能立即授予而不得不等待的闩锁请求数。 1775 1776 1777 LATCH_AVG_WAIT_NP_004_NAME=Average Latch Wait Time (ms) 1778 LATCH_AVG_WAIT_NP_004_HELP=必须等待授予的闩锁请求的平均等待时间(毫秒)。 1779 1780 1781 LATCH_AVG_WAIT_BASE_004_NAME=Average Latch Wait Time Base 1782 LATCH_AVG_WAIT_BASE_004_HELP=闩锁平均等待时间的基数。 1783 1784 1785 LATCH_TOTAL_WAIT_NP_004_NAME=Total Latch Wait Time (ms) 1786 LATCH_TOTAL_WAIT_NP_004_HELP=在上一秒钟内必须等待授予的闩锁请求的总等待时间(毫秒)。 1787 1788 1789 LATCH_SUPERLATCHES_004_NAME=Number of SuperLatches 1790 LATCH_SUPERLATCHES_004_HELP=目前是 SuperLatch 的闩锁数。 1791 1792 1793 LATCH_PROMOTIONS_004_NAME=SuperLatch Promotions/sec 1794 LATCH_PROMOTIONS_004_HELP=已提升为 SuperLatch 的闩锁数 1795 1796 1797 LATCH_DEMOTIONS_004_NAME=SuperLatch Demotions/sec 1798 LATCH_DEMOTIONS_004_HELP=已降级为常规闩锁的 SuperLatch 数 1799 1800 1801 AM_FULL_SCAN_004_NAME=Full Scans/sec 1802 AM_FULL_SCAN_004_HELP=不受限制的完全扫描数目。这些扫描可以是基表扫描,也可以是全文索引扫描。 1803 1804 1805 AM_RANGE_SCAN_004_NAME=Range Scans/sec 1806 AM_RANGE_SCAN_004_HELP=每秒通过索引进行的限定范围扫描数。 1807 1808 1809 AM_PROBE_SCAN_004_NAME=Probe Scans/sec 1810 AM_PROBE_SCAN_004_HELP=每秒用于直接在索引或基表中查找最多一个单限定行的探测扫描的次数。 1811 1812 1813 AM_SCAN_REPOSITION_004_NAME=Scan Point Revalidations/sec 1814 AM_SCAN_REPOSITION_004_HELP=必须重新验证扫描点才能继续扫描的次数。 1815 1816 1817 AM_WORKFILES_CREATED_004_NAME=Workfiles Created/sec 1818 AM_WORKFILES_CREATED_004_HELP=每秒创建的工作文件数。例如,工作文件可用于存储哈希联接和哈希聚合的临时结果。 1819 1820 1821 AM_WORKTABLES_CREATED_004_NAME=Worktables Created/sec 1822 AM_WORKTABLES_CREATED_004_HELP=每秒创建的工作表数。例如,工作表可用于存储查询假脱机操作、LOB 变量、XML 变量和游标的临时结果。 1823 1824 1825 AM_WORKTABLES_FROM_CACHE_004_NAME=Worktables From Cache Ratio 1826 AM_WORKTABLES_FROM_CACHE_004_HELP=在创建的工作表中,工作表的最初两页不是分配的,而是直接来自工作表缓存中的工作表所占的百分比。 1827 1828 1829 AM_WORKTABLES_FROM_CACHE_BASE_004_NAME=Worktables From Cache Base 1830 AM_WORKTABLES_FROM_CACHE_BASE_004_HELP=优先项的基数。 1831 1832 1833 AM_FORWARDED_RECS_004_NAME=Forwarded Records/sec 1834 AM_FORWARDED_RECS_004_HELP=通过正向记录指针提取的记录数。 1835 1836 1837 AM_GHOSTED_SKIPS_004_NAME=Skipped Ghosted Records/sec 1838 AM_GHOSTED_SKIPS_004_HELP=扫描期间每秒跳过的虚影记录数。 1839 1840 1841 AM_INDEX_SEARCHES_004_NAME=Index Searches/sec 1842 AM_INDEX_SEARCHES_004_HELP=索引搜索的数目。索引搜索用于启动范围扫描和单个索引记录提取操作,也用于在索引中改变位置。 1843 1844 1845 AM_FREESPACE_SCANS_004_NAME=FreeSpace Scans/sec 1846 AM_FREESPACE_SCANS_004_HELP=每秒启动的扫描数目,扫描目的是搜索已分配给某分配单元的页内的可用空间,以用于插入或修改记录片段。每次扫描可能查找多页。 1847 1848 1849 AM_FREESPACE_PAGES_004_NAME=FreeSpace Page Fetches/sec 1850 AM_FREESPACE_PAGES_004_HELP=每秒由可用空间扫描提取的页数。这些扫描搜索已分配给分配单元的页内的可用空间,以满足插入或修改记录片段的请求。 1851 1852 1853 AM_PAGES_ALLOCATED_004_NAME=Pages Allocated/sec 1854 AM_PAGES_ALLOCATED_004_HELP=此 SQL Server 实例的所有数据库中每秒分配的页数。其中包括从混合区和统一区分配的页数。 1855 1856 1857 AM_EXTENTS_ALLOCATED_004_NAME=Extents Allocated/sec 1858 AM_EXTENTS_ALLOCATED_004_HELP=此 SQL Server 实例的所有数据库中每秒分配的区数。 1859 1860 1861 AM_SINGLE_PAGE_ALLOCS_004_NAME=Mixed page allocations/sec 1862 AM_SINGLE_PAGE_ALLOCS_004_HELP=每秒从混合区分配的页数。这些页可用于存储 IAM 页和分配给某分配单元的前八页。 1863 1864 1865 AM_EXTENTS_DEALLOCATED_004_NAME=Extent Deallocations/sec 1866 AM_EXTENTS_DEALLOCATED_004_HELP=此 SQL Server 实例的所有数据库中每秒释放的区数。 1867 1868 1869 AM_PAGE_DEALLOCS_004_NAME=Page Deallocations/sec 1870 AM_PAGE_DEALLOCS_004_HELP=此 SQL Server 实例的所有数据库中每秒释放的区数。其中包括从混合区和统一区释放的页数。 1871 1872 1873 AM_PAGE_SPLITS_004_NAME=Page Splits/sec 1874 AM_PAGE_SPLITS_004_HELP=索引页溢出时出现的每秒页拆分数目。 1875 1876 1877 AM_LOCKESCALATIONS_004_NAME=Table Lock Escalations/sec 1878 AM_LOCKESCALATIONS_004_HELP=表上的锁升级的次数。 1879 1880 1881 AM_DEFDROPPEDROWSETQUEUELENGTH_004_NAME=Deferred Dropped rowsets 1882 AM_DEFDROPPEDROWSETQUEUELENGTH_004_HELP=当已中止的联机索引生成操作正在等待清除延迟删除的行集的后台任务删除时创建的行集数。 1883 1884 1885 AM_DEFDROPPEDROWSETSCLEANED_004_NAME=Dropped rowset cleanups/sec 1886 AM_DEFDROPPEDROWSETSCLEANED_004_HELP=当清除延迟删除的行集的后台任务成功删除了已中止的联机索引生成操作时,每秒创建的行集数。 1887 1888 1889 AM_DEFDROPPEDROWSETSSKIPPED_004_NAME=Dropped rowsets skipped/sec 1890 AM_DEFDROPPEDROWSETSSKIPPED_004_HELP=当清除延迟删除的行集的后台任务跳过了已中止的联机索引生成操作时,每秒创建的行集数。 1891 1892 1893 AM_DDALLOCUNITQUEUELENGTH_004_NAME=Deferred dropped AUs 1894 AM_DDALLOCUNITQUEUELENGTH_004_HELP=正在等待清除延迟删除的分配单元的后台任务删除的分配单元数。 1895 1896 1897 AM_DDALLOCUNITSCLEANED_004_NAME=AU cleanups/sec 1898 AM_DDALLOCUNITSCLEANED_004_HELP=清除延迟删除的分配单元的后台任务每秒成功删除的分配单元数。删除每个分配单元都需要多个批处理。 1899 1900 1901 AM_DDALLOCUNITBATCHESCOMPLETED_004_NAME=AU cleanup batches/sec 1902 AM_DDALLOCUNITBATCHESCOMPLETED_004_HELP=清除延迟删除的分配单元的后台任务每秒成功完成的批处理个数。 1903 1904 1905 AM_DDALLOCUNITBATCHESFAILED_004_NAME=Failed AU cleanup batches/sec 1906 AM_DDALLOCUNITBATCHESFAILED_004_HELP=清除延迟删除的分配单元的后台任务每秒失败而需要重试的批处理个数。失败的原因可能是内存或磁盘空间不足和硬件故障,也可能是其他原因。 1907 1908 1909 TREE_PAGE_COOKIE_SUCCEED_004_NAME=Used tree page cookie 1910 TREE_PAGE_COOKIE_SUCCEED_004_HELP=自树页的父级未更改以来,在索引搜索期间成功使用了树页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1911 1912 1913 TREE_PAGE_COOKIE_FAIL_004_NAME=Failed tree page cookie 1914 TREE_PAGE_COOKIE_FAIL_004_HELP=自那些树页的父级发生更改以来,在索引搜索期间无法使用树页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1915 1916 1917 LEAF_PAGE_COOKIE_SUCCEED_004_NAME=Used leaf page cookie 1918 LEAF_PAGE_COOKIE_SUCCEED_004_HELP=自叶级页未更改以来,在索引搜索期间成功使用了叶级页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1919 1920 1921 LEAF_PAGE_COOKIE_FAIL_004_NAME=Failed leaf page cookie 1922 LEAF_PAGE_COOKIE_FAIL_004_HELP=自叶级页发生更改以来,在索引搜索期间无法使用叶级页 cookie 的次数。该 cookie 用于加快索引搜索速度。 1923 1924 1925 AM_LOBSS_PROVIDERS_CREATED_004_NAME=LobSS Provider Create Count 1926 AM_LOBSS_PROVIDERS_CREATED_004_HELP=已创建的 LOB 存储服务提供程序计数。对每个 LOB 存储服务提供程序创建了一个工作表。 1927 1928 1929 AM_LOBSS_PROVIDERS_DESTROYED_004_NAME=LobSS Provider Destroy Count 1930 AM_LOBSS_PROVIDERS_DESTROYED_004_HELP=已破坏的 LOB 存储服务提供程序计数。 1931 1932 1933 AM_LOBSS_PROVIDERS_TRUNCATED_004_NAME=LobSS Provider Truncation Count 1934 AM_LOBSS_PROVIDERS_TRUNCATED_004_HELP=已截断的 LOB 存储服务提供程序计数。 1935 1936 1937 AM_LOBSS_LOBHANDLES_CREATED_004_NAME=LobHandle Create Count 1938 AM_LOBSS_LOBHANDLES_CREATED_004_HELP=已创建的临时 LOB 计数。 1939 1940 1941 AM_LOBSS_LOBHANDLES_DESTROYED_004_NAME=LobHandle Destroy Count 1942 AM_LOBSS_LOBHANDLES_DESTROYED_004_HELP=已破坏的临时 LOB 计数。 1943 1944 1945 AM_ORPHANS_CREATED_004_NAME=By-reference Lob Create Count 1946 AM_ORPHANS_CREATED_004_HELP=由引用传递的大型对象(LOB)值的计数。在某些大容量操作中使用由引用传递的 LOB,可免除按值传递它们时的开销。 1947 1948 1949 AM_ORPHANS_INSERTED_004_NAME=By-reference Lob Use Count 1950 AM_ORPHANS_INSERTED_004_HELP=使用过的由引用传递的 LOB 值的计数。在某些大容量操作中使用由引用传递的 LOB,可免除按值传递它们时的开销。 1951 1952 1953 AM_COLS_PUSHED_OFFROW_004_NAME=Count Push Off Row 1954 AM_COLS_PUSHED_OFFROW_004_HELP=已从行内推送到行外的值的计数。 1955 1956 1957 AM_COLS_PULLED_INROW_004_NAME=Count Pull In Row 1958 AM_COLS_PULLED_INROW_004_HELP=已从行外请求到行内的值的计数。 1959 1960 1961 AM_LOB_READAHEAD_ISSUED_004_NAME=Count Lob Readahead 1962 AM_LOB_READAHEAD_ISSUED_004_HELP=执行提前读的 lob 页计数。 1963 1964 1965 SQL_ERROR_RATE_004_NAME=Errors/sec 1966 SQL_ERROR_RATE_004_HELP=每秒的错误数 1967 1968 1969 SQL_BATCH_REQ_004_NAME=Batch Requests/sec 1970 SQL_BATCH_REQ_004_HELP=服务器收到的 SQL 批处理请求数。 1971 1972 1973 SQL_UNIVPARAM_004_NAME=Forced Parameterizations/sec 1974 SQL_UNIVPARAM_004_HELP=每秒由强制参数化导致参数化的语句数。 1975 1976 1977 SQL_AUTOPARAM_REQ_004_NAME=Auto-Param Attempts/sec 1978 SQL_AUTOPARAM_REQ_004_HELP=自动参数化尝试次数。 1979 1980 1981 SQL_AUTOPARAM_FAIL_004_NAME=Failed Auto-Params/sec 1982 SQL_AUTOPARAM_FAIL_004_HELP=失败的自动参数化数目。 1983 1984 1985 SQL_AUTOPARAM_SAFE_004_NAME=Safe Auto-Params/sec 1986 SQL_AUTOPARAM_SAFE_004_HELP=安全的自动参数化数目。 1987 1988 1989 SQL_AUTOPARAM_UNSAFE_004_NAME=Unsafe Auto-Params/sec 1990 SQL_AUTOPARAM_UNSAFE_004_HELP=不安全的自动参数化数目。 1991 1992 1993 SQL_COMPILES_004_NAME=SQL Compilations/sec 1994 SQL_COMPILES_004_HELP=SQL 编译的数目。 1995 1996 1997 SQL_RECOMPILES_004_NAME=SQL Re-Compilations/sec 1998 SQL_RECOMPILES_004_HELP=SQL 重新编译的数目。 1999 2000 2001 SQL_ATTENTION_RATE_004_NAME=SQL Attention rate 2002 SQL_ATTENTION_RATE_004_HELP=每秒发出关注信号的数目。 2003 2004 2005 PLAN_CACHE_HIT_RATIO_004_NAME=Cache Hit Ratio 2006 PLAN_CACHE_HIT_RATIO_004_HELP=缓存命中次数与查找次数之比 2007 2008 2009 PLAN_CACHE_HIT_RATIO_BASE_004_NAME=Cache Hit Ratio Base 2010 PLAN_CACHE_HIT_RATIO_BASE_004_HELP=优先项的基数 2011 2012 2013 PLAN_CACHE_PGS_IN_USE_004_NAME=Cache Pages 2014 PLAN_CACHE_PGS_IN_USE_004_HELP=缓存对象使用的 8k 页的数目 2015 2016 2017 PLAN_CACHE_OBJECT_COUNT_004_NAME=Cache Object Counts 2018 PLAN_CACHE_OBJECT_COUNT_004_HELP=缓存中的缓存对象数 2019 2020 2021 PLAN_CACHE_USE_COUNT_004_NAME=Cache Objects in use 2022 PLAN_CACHE_USE_COUNT_004_HELP=正在使用的缓存对象数 2023 2024 2025 CURSOR_CACHE_HIT_RATIO_004_NAME=Cache Hit Ratio 2026 CURSOR_CACHE_HIT_RATIO_004_HELP=缓存命中次数与查找次数之比 2027 2028 2029 CURSOR_CACHE_HIT_RATIO_BASE_004_NAME=Cache Hit Ratio Base 2030 CURSOR_CACHE_HIT_RATIO_BASE_004_HELP=优先项的基数 2031 2032 2033 CURSOR_CACHE_COUNT_004_NAME=Cached Cursor Counts 2034 CURSOR_CACHE_COUNT_004_HELP=缓存中给定类型的游标数 2035 2036 2037 CURSOR_CACHE_USE_COUNT_004_NAME=Cursor Cache Use Counts/sec 2038 CURSOR_CACHE_USE_COUNT_004_HELP=每种缓存的游标的使用次数 2039 2040 2041 CURSOR_REQ_004_NAME=Cursor Requests/sec 2042 CURSOR_REQ_004_HELP=服务器收到的 SQL 游标请求数。 2043 2044 2045 CURSOR_IN_USE_004_NAME=Active cursors 2046 CURSOR_IN_USE_004_HELP=活动游标数。 2047 2048 2049 CURSOR_MEMORY_USAGE_004_NAME=Cursor memory usage 2050 CURSOR_MEMORY_USAGE_004_HELP=游标占用的内存量(KB)。 2051 2052 2053 CURSOR_WORKTABLE_USAGE_004_NAME=Cursor worktable usage 2054 CURSOR_WORKTABLE_USAGE_004_HELP=游标使用的工作表数。 2055 2056 2057 CURSOR_PLANS_004_NAME=Number of active cursor plans 2058 CURSOR_PLANS_004_HELP=游标计划数。 2059 2060 2061 CURSOR_CONVERSION_RATE_004_NAME=Cursor conversion rate 2062 CURSOR_CONVERSION_RATE_004_HELP=游标每秒转换的次数。 2063 2064 2065 CURSOR_ASYNC_POPULATION_004_NAME=Async population count 2066 CURSOR_ASYNC_POPULATION_004_HELP=异步填充的游标数。 2067 2068 2069 CURSOR_XSTMT_FLUSH_004_NAME=Cursor flushes 2070 CURSOR_XSTMT_FLUSH_004_HELP=游标 xstmt 的刷新总次数。 2071 2072 2073 MEMORY_CONNECTION_MEMORY_004_NAME=Connection Memory (KB) 2074 MEMORY_CONNECTION_MEMORY_004_HELP=服务器用于维护连接的动态内存总量 2075 2076 2077 MEMORY_MEMGRANT_OUTSTANDING_004_NAME=Granted Workspace Memory (KB) 2078 MEMORY_MEMGRANT_OUTSTANDING_004_HELP=授予用来执行进程的内存总量。这些内存用于哈希、排序和创建索引操作。 2079 2080 2081 MEMORY_LOCK_MEMORY_004_NAME=Lock Memory (KB) 2082 MEMORY_LOCK_MEMORY_004_HELP=服务器用于锁的动态内存总量 2083 2084 2085 MEMORY_LOCKS_ALLOCATED_004_NAME=Lock Blocks Allocated 2086 MEMORY_LOCKS_ALLOCATED_004_HELP=分配的锁块的当前数目。 2087 2088 2089 MEMORY_LOCKOWNERS_ALLOCATED_004_NAME=Lock Owner Blocks Allocated 2090 MEMORY_LOCKOWNERS_ALLOCATED_004_HELP=分配的锁所有者块的当前数目。 2091 2092 2093 MEMORY_LOCKS_004_NAME=Lock Blocks 2094 MEMORY_LOCKS_004_HELP=服务器上正在使用的锁块的当前数目。已定期刷新。 2095 2096 2097 MEMORY_LOCKOWNERS_004_NAME=Lock Owner Blocks 2098 MEMORY_LOCKOWNERS_004_HELP=服务器上当前正在使用的锁所有者块的数目。已定期刷新。 2099 2100 2101 MEMORY_MEMGRANT_MAXIMUM_004_NAME=Maximum Workspace Memory (KB) 2102 MEMORY_MEMGRANT_MAXIMUM_004_HELP=授予用来执行进程的内存总量。这些内存主要用于哈希、排序和创建索引操作。 2103 2104 2105 MEMORY_MEMGRANT_ACQUIRES_004_NAME=Memory Grants Outstanding 2106 MEMORY_MEMGRANT_ACQUIRES_004_HELP=当前已成功获得工作区内存授予的进程数 2107 2108 2109 MEMORY_MEMGRANT_WAITERS_004_NAME=Memory Grants Pending 2110 MEMORY_MEMGRANT_WAITERS_004_HELP=当前正在等待工作区内存授予的进程数 2111 2112 2113 MEMORY_OPTIMIZER_MEMORY_004_NAME=Optimizer Memory (KB) 2114 MEMORY_OPTIMIZER_MEMORY_004_HELP=服务器用于查询优化的动态内存总量 2115 2116 2117 MEMORY_SQL_CACHE_MEMORY_004_NAME=SQL Cache Memory (KB) 2118 MEMORY_SQL_CACHE_MEMORY_004_HELP=服务器用于动态 SQL 缓存的动态内存总量 2119 2120 2121 MEMORY_SERVER_MEMORY_TARGET_004_NAME=Target Server Memory (KB) 2122 MEMORY_SERVER_MEMORY_TARGET_004_HELP=服务器打算占用的动态内存总量 2123 2124 2125 MEMORY_SERVER_MEMORY_004_NAME=Total Server Memory (KB) 2126 MEMORY_SERVER_MEMORY_004_HELP=服务器当前占用的动态内存总量 2127 2128 2129 QUERY_INSTANCE_004_NAME=Query 2130 QUERY_INSTANCE_004_HELP=与用户定义的一致。 2131 2132 2133 RUNNING_INSTANCE_004_NAME=Running 2134 RUNNING_INSTANCE_004_HELP=当前正在运行的复制代理数。 2135 2136 2137 UPLOAD_INSTANCE_004_NAME=Uploaded Changes/sec 2138 UPLOAD_INSTANCE_004_HELP=每秒从订阅服务器合并到发布服务器的行数。 2139 2140 2141 DOWNLOAD_INSTANCE_004_NAME=Downloaded Changes/sec 2142 DOWNLOAD_INSTANCE_004_HELP=每秒从发布服务器合并到订阅服务器的行数。 2143 2144 2145 MERGE_CONFLICTS_INSTANCE_004_NAME=Conflicts/sec 2146 MERGE_CONFLICTS_INSTANCE_004_HELP=在合并过程中每秒出现的冲突数。 2147 2148 2149 LOGREADER_LATENCY_INSTANCE_004_NAME=Logreader:Delivery Latency 2150 LOGREADER_LATENCY_INSTANCE_004_HELP=从将事务应用于发布服务器到将它们传递到分发服务器所占用的时间(毫秒)。 2151 2152 2153 LOGREADER_COMMANDS_INSTANCE_004_NAME=Logreader:Delivered Cmds/sec 2154 LOGREADER_COMMANDS_INSTANCE_004_HELP=每秒传递到分发服务器的命令数。 2155 2156 2157 LOGREADER_TRANSACTIONS_INSTANCE_004_NAME=Logreader:Delivered Trans/sec 2158 LOGREADER_TRANSACTIONS_INSTANCE_004_HELP=每秒传递到分发服务器的事务数。 2159 2160 2161 DISTRIBUTION_LATENCY_INSTANCE_004_NAME=Dist:Delivery Latency 2162 DISTRIBUTION_LATENCY_INSTANCE_004_HELP=从将事务传递到分发服务器到将它们应用于订阅服务器所占用的时间(毫秒)。 2163 2164 2165 DISTRIBUTION_COMMANDS_INSTANCE_004_NAME=Dist:Delivered Cmds/sec 2166 DISTRIBUTION_COMMANDS_INSTANCE_004_HELP=每秒传递到订阅服务器的命令数。 2167 2168 2169 DISTRIBUTION_TRANS_INSTANCE_004_NAME=Dist:Delivered Trans/sec 2170 DISTRIBUTION_TRANS_INSTANCE_004_HELP=每秒传递到订阅服务器的事务数。 2171 2172 2173 SNAPSHOT_COMMANDS_BCPED_004_NAME=Snapshot:Delivered Cmds/sec 2174 SNAPSHOT_COMMANDS_BCPED_004_HELP=每秒传递到分发服务器的命令数。 2175 2176 2177 SNAPSHOT_TRANSACTIONS_BCPED_004_NAME=Snapshot:Delivered Trans/sec 2178 SNAPSHOT_TRANSACTIONS_BCPED_004_HELP=每秒传递到分发服务器的事务数。 2179 2180 2181 DB_BCK_DEV_THROUGHPUT_004_NAME=Device Throughput Bytes/sec 2182 DB_BCK_DEV_THROUGHPUT_004_HELP=备份设备的读取/写入吞吐量。 2183 2184 2185 XACT_NUM_004_NAME=Transactions 2186 XACT_NUM_004_HELP=活动事务的总数。 2187 2188 2189 XACT_SNP_NUM_004_NAME=Snapshot Transactions 2190 XACT_SNP_NUM_004_HELP=活动快照事务的总数。 2191 2192 2193 XACT_UPD_SNP_NUM_004_NAME=Update Snapshot Transactions 2194 XACT_UPD_SNP_NUM_004_HELP=执行更新操作的活动快照事务的总数。 2195 2196 2197 XACT_NSNP_VER_NUM_004_NAME=NonSnapshot Version Transactions 2198 XACT_NSNP_VER_NUM_004_HELP=生成版本记录的活动非快照事务的总数。 2199 2200 2201 XACT_LONGEST_RUNNING_004_NAME=Longest Transaction Running Time 2202 XACT_LONGEST_RUNNING_004_HELP=任意事务的最长运行时间(秒)。 2203 2204 2205 XACT_UPD_CONFLICTS_RATIO_004_NAME=Update conflict ratio 2206 XACT_UPD_CONFLICTS_RATIO_004_HELP=存在更新冲突的更新快照事务与更新快照事务总数的比值。 2207 2208 2209 XACT_UPD_CONFLICTS_RATIO_BASE_004_NAME=Update conflict ratio base 2210 XACT_UPD_CONFLICTS_RATIO_BASE_004_HELP=更新快照事务的总数。 2211 2212 2213 XACT_TEMPDB_FREE_SPACE_004_NAME=Free Space in tempdb (KB) 2214 XACT_TEMPDB_FREE_SPACE_004_HELP=tempdb 中的可用空间(KB)。 2215 2216 2217 XACT_VER_STORE_GEN_RATE_004_NAME=Version Generation rate (KB/s) 2218 XACT_VER_STORE_GEN_RATE_004_HELP=版本生成速率(KB/秒)。 2219 2220 2221 XACT_VER_STORE_CLEANUP_RATE_004_NAME=Version Cleanup rate (KB/s) 2222 XACT_VER_STORE_CLEANUP_RATE_004_HELP=版本清除速率(KB/秒)。 2223 2224 2225 XACT_VER_STORE_SIZE_004_NAME=Version Store Size (KB) 2226 XACT_VER_STORE_SIZE_004_HELP=版本存储区的大小(KB)。 2227 2228 2229 XACT_VER_STORE_UNIT_COUNT_004_NAME=Version Store unit count 2230 XACT_VER_STORE_UNIT_COUNT_004_HELP=版本存储区中的单元数。 2231 2232 2233 XACT_VER_STORE_UNIT_CREATION_004_NAME=Version Store unit creation 2234 XACT_VER_STORE_UNIT_CREATION_004_HELP=在版本存储区中创建新单元。 2235 2236 2237 XACT_VER_STORE_UNIT_TRUNCATION_004_NAME=Version Store unit truncation 2238 XACT_VER_STORE_UNIT_TRUNCATION_004_HELP=截断版本存储区中的单元。 2239 2240 2241 BO_SEND_RATE_004_NAME=SQL SENDs/sec 2242 BO_SEND_RATE_004_HELP=Broker 每秒处理的 SQL SEND 命令数。 2243 2244 2245 BO_TOTAL_SENDS_004_NAME=SQL SEND Total 2246 BO_TOTAL_SENDS_004_HELP=Broker 处理的 SQL SEND 命令总数。 2247 2248 2249 BO_RECEIVE_RATE_004_NAME=SQL RECEIVEs/sec 2250 BO_RECEIVE_RATE_004_HELP=Broker 每秒处理的 SQL RECEIVE 命令数。 2251 2252 2253 BO_TOTAL_RECEIVES_004_NAME=SQL RECEIVE Total 2254 BO_TOTAL_RECEIVES_004_HELP=Broker 处理的 SQL RECEIVE 命令总数。 2255 2256 2257 BO_XACT_ROLLBACKS_004_NAME=Broker Transaction Rollbacks 2258 BO_XACT_ROLLBACKS_004_HELP=已回滚的 Service Broker 相关事务数。 2259 2260 2261 BO_DEP_TIMER_EVENTS_004_NAME=Dialog Timer Event Count 2262 BO_DEP_TIMER_EVENTS_004_HELP=Broker 中与对话框端点相关的计时器事件数。 2263 2264 2265 BO_ENQUEUED_MSG_RATE_004_NAME=Enqueued Messages/sec 2266 BO_ENQUEUED_MSG_RATE_004_HELP=每秒成功地从本地端点和传输层传递到队列的就绪消息数。 2267 2268 2269 BO_ENQUEUED_LOCAL_MSG_RATE_004_NAME=Enqueued Local Messages/sec 2270 BO_ENQUEUED_LOCAL_MSG_RATE_004_HELP=每秒成功地从本地端点传递到队列的就绪消息数。 2271 2272 2273 BO_ENQUEUED_TRANSPORT_MSG_RATE_004_NAME=Enqueued Transport Msgs/sec 2274 BO_ENQUEUED_TRANSPORT_MSG_RATE_004_HELP=每秒成功地从传输层传递到队列的就绪消息数。 2275 2276 2277 BO_ENQUEUED_TRANSPORT_FRAG_RATE_004_NAME=Enqueued Transport Msg Frags/sec 2278 BO_ENQUEUED_TRANSPORT_FRAG_RATE_004_HELP=每秒成功地从传输层传递到队列的消息片段数。请注意,相应的消息可能仍不完整或者顺序不对,因此该消息在队列中处于禁用状态。 2279 2280 2281 BO_ENQUEUED_MSGS_TOTAL_004_NAME=Enqueued Messages Total 2282 BO_ENQUEUED_MSGS_TOTAL_004_HELP=成功地从本地端点和传输层传递到队列的就绪消息片段总数。 2283 2284 2285 BO_ENQUEUED_LOCAL_MSGS_TOTAL_004_NAME=Enqueued Local Messages Total 2286 BO_ENQUEUED_LOCAL_MSGS_TOTAL_004_HELP=成功地从本地端点传递到队列的就绪消息片段总数。 2287 2288 2289 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_004_NAME=Enqueued Transport Msgs Total 2290 BO_ENQUEUED_TRANSPORT_MSGS_TOTAL_004_HELP=成功地从传输层传递到队列的就绪消息总数。 2291 2292 2293 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_004_NAME=Enqueued Transport Msg Frag Tot 2294 BO_ENQUEUED_TRANSPORT_FRAGS_TOT_004_HELP=成功地从传输层传递到队列的消息片段总数。请注意,相应的消息可能仍不完整或者顺序不对,因此该消息在队列中处于禁用状态。 2295 2296 2297 BO_FORWARDED_PENDING_MSGS_004_NAME=Forwarded Pending Msg Count 2298 BO_FORWARDED_PENDING_MSGS_004_HELP=尚未成功发送的转发消息数。 2299 2300 2301 BO_FORWARDED_PENDING_MSG_BYTES_004_NAME=Forwarded Pending Msg Bytes 2302 BO_FORWARDED_PENDING_MSG_BYTES_004_HELP=尚未成功发送的转发消息字节数。 2303 2304 2305 BO_FORWARDED_DISCARDED_MSG_RATE_004_NAME=Forwarded Msgs Discarded/sec 2306 BO_FORWARDED_DISCARDED_MSG_RATE_004_HELP=每秒因转发消息内存限制、保留时间限制等原因而放弃的转发消息数。 2307 2308 2309 BO_FORWARDED_DISCARDED_MSG_TOTAL_004_NAME=Forwarded Msg Discarded Total 2310 BO_FORWARDED_DISCARDED_MSG_TOTAL_004_HELP=因转发消息内存限制、保留时间限制等原因而放弃的转发消息总数。 2311 2312 2313 BO_FORWARDED_MSG_RATE_004_NAME=Forwarded Messages/sec 2314 BO_FORWARDED_MSG_RATE_004_HELP=每秒成功发送的转发消息数。 2315 2316 2317 BO_FORWARDED_MSG_TOTAL_004_NAME=Forwarded Messages Total 2318 BO_FORWARDED_MSG_TOTAL_004_HELP=成功发送的转发消息总数。 2319 2320 2321 BO_FORWARDED_MSG_BYTE_RATE_004_NAME=Forwarded Msg Bytes/sec 2322 BO_FORWARDED_MSG_BYTE_RATE_004_HELP=每秒成功发送的转发消息字节数。 2323 2324 2325 BO_FORWARDED_MSG_BYTE_TOTAL_004_NAME=Forwarded Msg Byte Total 2326 BO_FORWARDED_MSG_BYTE_TOTAL_004_HELP=成功发送的转发消息字节总数。 2327 2328 2329 BTO_OPEN_CONNECTIONS_004_NAME=Open Connection Count 2330 BTO_OPEN_CONNECTIONS_004_HELP=当前打开的传输连接总数。 2331 2332 2333 BTO_SEND_IO_RATE_004_NAME=Send I/Os/sec 2334 BTO_SEND_IO_RATE_004_HELP=每秒传输发送 I/O 的数目。请注意,传输发送 I/O 可能包含一个以上的消息片段。 2335 2336 2337 BTO_SEND_IO_BYTE_RATE_004_NAME=Send I/O bytes/sec 2338 BTO_SEND_IO_BYTE_RATE_004_HELP=每秒传输发送 I/O 字节数。 2339 2340 2341 BTO_SEND_IO_LEN_AVG_004_NAME=Send I/O Len Avg 2342 BTO_SEND_IO_LEN_AVG_004_HELP=传输发送 I/O 操作的平均字节长度。 2343 2344 2345 BTO_SEND_IO_LEN_AVG_BASE_004_NAME=Send I/O Len Avg Base 2346 BTO_SEND_IO_LEN_AVG_BASE_004_HELP=传输发送 I/O 操作的平均字节长度的基数。 2347 2348 2349 BTO_RECEIVE_IO_RATE_004_NAME=Receive I/Os/sec 2350 BTO_RECEIVE_IO_RATE_004_HELP=每秒传输接收 I/O 的数目。请注意,传输接收 I/O 可能包含一个以上的消息片段。 2351 2352 2353 BTO_RECEIVE_IO_BYTE_RATE_004_NAME=Receive I/O bytes/sec 2354 BTO_RECEIVE_IO_BYTE_RATE_004_HELP=每秒传输接收 I/O 字节数。 2355 2356 2357 BTO_RECV_IO_LEN_AVG_004_NAME=Receive I/O Len Avg 2358 BTO_RECV_IO_LEN_AVG_004_HELP=传输接收 I/O 操作的平均字节长度。 2359 2360 2361 BTO_RECV_IO_LEN_AVG_BASE_004_NAME=Receive I/O Len Avg Base 2362 BTO_RECV_IO_LEN_AVG_BASE_004_HELP=传输接收 I/O 操作的平均字节长度的基数。 2363 2364 2365 BTO_SEND_FRAG_RATE_004_NAME=Message Fragment Sends/sec 2366 BTO_SEND_FRAG_RATE_004_HELP=每秒在传输发送 I/O 操作中发送的消息片段数。 2367 2368 2369 BTO_SEND_FRAG_SIZE_AVG_004_NAME=Msg Fragment Send Size Avg 2370 BTO_SEND_FRAG_SIZE_AVG_004_HELP=在传输发送 I/O 操作中发送的消息片段的平均字节大小。 2371 2372 2373 BTO_SEND_FRAG_SIZE_AVG_BASE_004_NAME=Msg Fragment Send Size Avg Base 2374 BTO_SEND_FRAG_SIZE_AVG_BASE_004_HELP=在传输发送 I/O 操作中发送的消息片段的平均字节大小的基数。 2375 2376 2377 BTO_RECEIVE_FRAG_RATE_004_NAME=Message Fragment Receives/sec 2378 BTO_RECEIVE_FRAG_RATE_004_HELP=每秒在传输接收 I/O 操作中接收的消息片段数。 2379 2380 2381 BTO_RECV_FRAG_SIZE_AVG_004_NAME=Msg Fragment Recv Size Avg 2382 BTO_RECV_FRAG_SIZE_AVG_004_HELP=在传输接收 I/O 操作中接收的消息片段的平均字节大小。 2383 2384 2385 BTO_RECV_FRAG_SIZE_AVG_BASE_004_NAME=Msg Fragment Recv Size Avg Base 2386 BTO_RECV_FRAG_SIZE_AVG_BASE_004_HELP=在传输接收 I/O 操作中接收的消息片段的平均字节大小的基数。 2387 2388 2389 BTO_SEND_IO_PEND_FRAG_COUNT_004_NAME=Pending Msg Frags for Send I/O 2390 BTO_SEND_IO_PEND_FRAG_COUNT_004_HELP=当前正在封送或已封送好可通过传输层发送的消息片段数。 2391 2392 2393 BTO_SEND_IO_CURR_FRAG_COUNT_004_NAME=Current Msg Frags for Send I/O 2394 BTO_SEND_IO_CURR_FRAG_COUNT_004_HELP=与当前尚未完成的传输发送 I/O 操作相关的当前消息片段数。 2395 2396 2397 BTO_SEND_IO_PEND_BYTES_004_NAME=Pending Bytes for Send I/O 2398 BTO_SEND_IO_PEND_BYTES_004_HELP=与正在封送或已封送好可通过发送 I/O 操作发送的消息片段相关的缓冲区字节数。 2399 2400 2401 BTO_SEND_IO_CURR_BYTES_004_NAME=Current Bytes for Send I/O 2402 BTO_SEND_IO_CURR_BYTES_004_HELP=与当前尚未完成的传输发送 I/O 操作相关的缓冲区字节数。 2403 2404 2405 BTO_RECV_IO_PEND_FRAG_COUNT_004_NAME=Pending Msg Frags for Recv I/O 2406 BTO_RECV_IO_PEND_FRAG_COUNT_004_HELP=在尚未排队(或拒绝)的传输接收 I/O 操作中接收的当前消息片段数。 2407 2408 2409 BTO_RECV_IO_CURR_BYTES_004_NAME=Current Bytes for Recv I/O 2410 BTO_RECV_IO_CURR_BYTES_004_HELP=与当前尚未完成的传输接收 I/O 操作相关的字节数。 2411 2412 2413 BTO_RECV_IO_PEND_BYTES_004_NAME=Pending Bytes for Recv I/O 2414 BTO_RECV_IO_PEND_BYTES_004_HELP=与其消息片段尚未排队(或拒绝)的未完成传输接收 I/O 操作相关的字节数。 2415 2416 2417 BTO_RECV_IO_COMPACT_MFB_004_NAME=Recv I/O Buffer Copies Count 2418 BTO_RECV_IO_COMPACT_MFB_004_HELP=传输接收 I/O 操作必须将缓冲区片段移入内存的次数。 2419 2420 2421 BTO_RECV_IO_COMPACT_MFB_RATE_004_NAME=Recv I/O Buffer Copies bytes/sec 2422 BTO_RECV_IO_COMPACT_MFB_RATE_004_HELP=传输接收 I/O 操作必须将缓冲区片段移入内存时的速率。 2423 2424 2425 BAO_TASK_START_RATE_004_NAME=Tasks Started/sec 2426 BAO_TASK_START_RATE_004_HELP=每秒正在启动的已激活任务的数目。 2427 2428 2429 BAO_TASKS_RUNNING_004_NAME=Tasks Running 2430 BAO_TASKS_RUNNING_004_HELP=当前正在运行的已激活任务的总数。 2431 2432 2433 BAO_TASK_ABORT_RATE_004_NAME=Tasks Aborted/sec 2434 BAO_TASK_ABORT_RATE_004_HELP=每秒正在中止的已激活任务的数目。 2435 2436 2437 BAO_TASK_LIMIT_RATE_004_NAME=Task Limit Reached/sec 2438 BAO_TASK_LIMIT_RATE_004_HELP=每秒队列中的已激活任务达到限额的次数。 2439 2440 2441 BAO_TASK_LIMIT_REACHED_004_NAME=Task Limit Reached 2442 BAO_TASK_LIMIT_REACHED_004_HELP=队列中的已激活任务达到限额的总次数。 2443 2444 2445 BAO_SP_INVOKE_RATE_004_NAME=Stored Procedures Invoked/sec 2446 BAO_SP_INVOKE_RATE_004_HELP=每秒正在调用的存储过程数。 2447 2448 2449 WAITSTATS_LOCKS_004_NAME=Lock waits 2450 WAITSTATS_LOCKS_004_HELP=等待锁的进程的统计信息。 2451 2452 2453 WAITSTATS_RESOURCE_004_NAME=Memory grant queue waits 2454 WAITSTATS_RESOURCE_004_HELP=等待内存授予的进程的统计信息。 2455 2456 2457 WAITSTATS_MEMTHREAD_004_NAME=Thread-safe memory objects waits 2458 WAITSTATS_MEMTHREAD_004_HELP=等待线程安全内存分配器的进程的统计信息。 2459 2460 2461 WAITSTATS_WRITELOG_004_NAME=Log write waits 2462 WAITSTATS_WRITELOG_004_HELP=等待写入日志缓冲区的进程的统计信息。 2463 2464 2465 WAITSTATS_LOGBUFFER_004_NAME=Log buffer waits 2466 WAITSTATS_LOGBUFFER_004_HELP=等待日志缓冲区可用的进程的统计信息。 2467 2468 2469 WAITSTATS_NETWORKIO_004_NAME=Network IO waits 2470 WAITSTATS_NETWORKIO_004_HELP=与等待网络 IO 相关的统计信息。 2471 2472 2473 WAITSTATS_PAGEIOLATCH_004_NAME=Page IO latch waits 2474 WAITSTATS_PAGEIOLATCH_004_HELP=与页 IO 闩锁相关的统计信息。 2475 2476 2477 WAITSTATS_PAGELATCH_004_NAME=Page latch waits 2478 WAITSTATS_PAGELATCH_004_HELP=与页闩锁(不包括 IO 闩锁)相关的统计信息 2479 2480 2481 WAITSTATS_NPAGELATCH_004_NAME=Non-Page latch waits 2482 WAITSTATS_NPAGELATCH_004_HELP=与非页闩锁相关的统计信息。 2483 2484 2485 WAITSTATS_SOS_WORKER_004_NAME=Wait for the worker 2486 WAITSTATS_SOS_WORKER_004_HELP=与等待工作线程变得可用的进程相关的统计信息。 2487 2488 2489 WAITSTATS_XACTWORKSPACE_004_NAME=Workspace synchronization waits 2490 WAITSTATS_XACTWORKSPACE_004_HELP=与同步访问工作区的进程相关的统计信息。 2491 2492 2493 WAITSTATS_TRANSACTION_004_NAME=Transaction ownership waits 2494 WAITSTATS_TRANSACTION_004_HELP=与同步访问事务的进程相关的统计信息。 2495 2496 2497 EXECSTATS_MSQL_XP_004_NAME=Extended Procedures 2498 EXECSTATS_MSQL_XP_004_HELP=与执行 XP 调用相关的统计信息。 2499 2500 2501 EXECSTATS_DTC_004_NAME=DTC calls 2502 EXECSTATS_DTC_004_HELP=与执行 DTC 调用相关的统计信息。 2503 2504 2505 EXECSTATS_OLEDB_004_NAME=OLEDB calls 2506 EXECSTATS_OLEDB_004_HELP=与执行 OLEDB 调用相关的统计信息。 2507 2508 2509 EXECSTATS_DQ_004_NAME=Distributed Query 2510 EXECSTATS_DQ_004_HELP=与执行分布式查询相关的统计信息。 2511 2512 2513 SQLCLR_TOTAL_EXECTIME_004_NAME=CLR Execution 2514 SQLCLR_TOTAL_EXECTIME_004_HELP=在 CLR 中的总执行时间(微秒)。 2515 2516 2517 MD_CACHE_HIT_RATIO_004_NAME=Cache Hit Ratio 2518 MD_CACHE_HIT_RATIO_004_HELP=目录元数据缓存中命中次数和查找次数之比 2519 2520 2521 MD_CACHE_HIT_RATIO_BASE_004_NAME=Cache Hit Ratio Base 2522 MD_CACHE_HIT_RATIO_BASE_004_HELP=优先项的基数 2523 2524 2525 MD_CACHE_ENTRY_COUNT_004_NAME=Cache Entries Count 2526 MD_CACHE_ENTRY_COUNT_004_HELP=目录元数据缓存中的项数 2527 2528 2529 MD_CACHE_PINNED_COUNT_004_NAME=Cache Entries Pinned Count 2530 MD_CACHE_PINNED_COUNT_004_HELP=目录元数据缓存中已固定的项数
1777 LATCH_AVG_WAIT_NP_004_NAME=Average Latch Wait Time (ms)
1778 LATCH_AVG_WAIT_NP_004_HELP=必须等待授予的闩锁请求的平均等待时间(毫秒)。
1779
1780
1781 LATCH_AVG_WAIT_BASE_004_NAME=Average Latch Wait Time Base
1782 LATCH_AVG_WAIT_BASE_004_HELP=闩锁平均等待时间的基数。
1783
1784
1785 LATCH_TOTAL_WAIT_NP_004_NAME=Total Latch Wait Time (ms)
1786 LATCH_TOTAL_WAIT_NP_004_HELP=在上一秒钟内必须等待授予的闩锁请求的总等待时间(毫秒)。
1787
1788
1789 LATCH_SUPERLATCHES_004_NAME=Number of SuperLatches
1790 LATCH_SUPERLATCHES_004_HELP=目前是 SuperLatch 的闩锁数。
1791
1792
1793 LATCH_PROMOTIONS_004_NAME=SuperLatch Promotions/sec
1794 LATCH_PROMOTIONS_004_HELP=已提升为 SuperLatch 的闩锁数