当前位置:Gxlcms > mysql > SQLSERVER性能计数器的简单剖析

SQLSERVER性能计数器的简单剖析

时间:2021-07-01 10:21:17 帮助过:47人阅读

SQLSERVER性能计数器的简单剖析 今晚看了这篇文章: SQL Server 2012新performance counter:非常实用的Batch Resp Statistics 文章里介绍到SQLSERVER2012新的性能计数器Batch Resp Statistics 其实我有一个问题: 当我的电脑里有多个版本的SQLSERVER或者多

SQLSERVER性能计数器的简单剖析

今晚看了这篇文章:SQL Server 2012新performance counter:非常实用的Batch Resp Statistics

文章里介绍到SQLSERVER2012新的性能计数器“Batch Resp Statistics”

其实我有一个问题:当我的电脑里有多个版本的SQLSERVER或者多个SQLSERVER实例,SQLSERVER是怎麽区分不同版本的不同计数器的呢?

比如下面SQL脚本,在SQL2012里执行可以看到新的性能计数器Batch Resp Statistics的信息

 1 SELECT  [counter_name] ,
 2         "CPU Time:Total(ms)" ,
 3         "CPU Time:Requests" ,
 4         "Elapsed Time:Total(ms)" ,
 5         "Elapsed Time:Requests"
 6 FROM    ( SELECT    [counter_name] ,
 7                     [instance_name] ,
 8                     [cntr_value]
 9           FROM      sys.dm_os_performance_counters --计数器视图
10           WHERE     OBJECT_NAME LIKE '%Batch Resp Statistics%'
11         ) os_pc PIVOT( AVG([cntr_value]) FOR [instance_name] IN ( "CPU Time:Total(ms)",
12                                                               "CPU Time:Requests",
13                                                               "Elapsed Time:Total(ms)",
14                                                               "Elapsed Time:Requests" ) )AS Pvt;

而在SQL2005里执行上面的SQL语句则什么都查询不到,因为在SQL2005里没有这个计数器


在性能监视器里添加“Batch Resp Statistics”性能计数器

第一步:

第二步:

第三步:

第四步:


MSDN关于sys.dm_os_performance_counters性能计数器视图的描述

http://technet.microsoft.com/zh-cn/library/ms187743(SQL.90).aspx

更新日期: 2007 年 9 月 15 日

为服务器维护的每个性能计数器返回一行。 有关每个性能计数器的信息,请参阅使用 SQL Server 对象。

列名数据类型说明

object_name

nchar(128)

该计数器所属的类别。

counter_name

nchar(128)

计数器的名称。

instance_name

nchar(128)

计数器特定实例的名称。 通常包含数据库名称。

cntr_value

bigint

计数器的当前值。

对于每秒计数器,该值是累积的。 速率值必须通过对离散时间间隔的值抽样来进行计算。 任何两个连续抽样值之间的差等于针对所使用时间间隔的速率。

注意:

cntr_type

int

Windows 性能体系结构定义的计数器类型。 有关性能计数器类型的详细信息,请参阅 WMI Performance Counter Types(WMI 性能计数器类型)或 Windows Server 文档。


权限
需要对服务器具有 VIEW SERVER STATE 权限。
备注
如果 SQL Server 的安装实例无法显示 Windows 操作系统的性能计数器,请使用下面的 Transact-SQL 查询来确认性能计算器已禁用。

1 SELECT COUNT (*) FROM sys.dm_os_performance_counters


如果返回值为 0 行,则性能计数器已禁用。 此时,您应查看安装日志并搜索错误 3409“请为此实例重新安装 sqlctr.ini

并确保实例登录帐户具有正确的注册表权限”,该错误表示性能计数器未启用。

紧列在 3409 前的错误应指示导致性能计数器启用失败的根本原因。 有关安装日志文件的详细信息,

请参阅How to: View SQL Server 2005 Setup Log Files。


分析

我的电脑里安装了SQL2005SQL2008 SQLEXPRESS版本SQL2012

我安装各个SQLSERVER的路径

SQL2005

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

SQL2008 SQLEXPRESS版本

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn

SQL2012

D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Binn

上面三个路径都有一个sqlctr.ini文件

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlctr.ini SQL2005

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

人气教程排行