SQLSERVER性能计数器的简单剖析 今晚看了这篇文章： SQL Server 2012新performance counter：非常实用的Batch Resp Statistics 文章里介绍到SQLSERVER2012新的性能计数器Batch Resp Statistics 其实我有一个问题： 当我的电脑里有多个版本的SQLSERVER或者多
SQLSERVER性能计数器的简单剖析
今晚看了这篇文章： SQL Server 2012新performance counter：非常实用的Batch Resp Statistics
文章里介绍到SQLSERVER2012新的性能计数器[Batch Resp Statistics]
其实我有一个问题： 当我的电脑里有多个版本的SQLSERVER或者多个SQLSERVER实例，SQLSERVER是怎麽区分不同版本的不同计数器的呢？
比如下面SQL脚本，在SQL2012里执行可以看到新的性能计数器Batch Resp Statistics的信息
1 SELECT [ counter_name ] , 2 "CPU Time:Total(ms)" , 3 "CPU Time:Requests" , 4 "Elapsed Time:Total(ms)" , 5 "Elapsed Time:Requests" 6 FROM ( SELECT [ counter_name ] , 7 [ instance_name ] , 8 [ cntr_value ] 9 FROM sys.dm_os_performance_counters -- 计数器视图 10 WHERE OBJECT_NAME LIKE ' %Batch Resp Statistics% ' 11 ) os_pc PIVOT( AVG ( [ cntr_value ] ) FOR [ instance_name ] IN ( "CPU Time:Total(ms)", 12 "CPU Time:Requests", 13 "Elapsed Time:Total(ms)", 14 "Elapsed Time:Requests" ) ) AS Pvt;
而在SQL2005里执行上面的SQL语句则什么都查询不到，因为在SQL2005里没有这个计数器
在性能监视器里添加[Batch Resp Statistics]性能计数器
第一步：
第二步：
第三步：
第四步：
MSDN关于sys.dm_os_performance_counters性能计数器视图的描述
http://technet.microsoft.com/zh-cn/library/ms187743(SQL.90).aspx
更新日期： 2007 年 9 月 15 日
为服务器维护的每个性能计数器返回一行。 有关每个性能计数器的信息，请参阅使用 SQL Server 对象。
列名 数据类型 说明object_name
nchar(128)
该计数器所属的类别。
counter_name
nchar(128)
计数器的名称。
instance_name
nchar(128)
计数器特定实例的名称。 通常包含数据库名称。
cntr_value
bigint
计数器的当前值。
对于每秒计数器，该值是累积的。 速率值必须通过对离散时间间隔的值抽样来进行计算。 任何两个连续抽样值之间的差等于针对所使用时间间隔的速率。
注意：
cntr_type
int
Windows 性能体系结构定义的计数器类型。 有关性能计数器类型的详细信息，请参阅 WMI Performance Counter Types（WMI 性能计数器类型）或 Windows Server 文档。
权限
需要对服务器具有 VIEW SERVER STATE 权限。
备注
如果 SQL Server 的安装实例无法显示 Windows 操作系统的性能计数器，请使用下面的 Transact-SQL 查询来确认性能计算器已禁用。
1 SELECT COUNT ( * ) FROM sys.dm_os_performance_counters
如果返回值为 0 行，则性能计数器已禁用。 此时，您应查看安装日志并搜索错误 3409[请为此实例重新安装 sqlctr.ini ，
并确保实例登录帐户具有正确的注册表权限]，该错误表示性能计数器未启用。
紧列在 3409 前的错误应指示导致性能计数器启用失败的根本原因。 有关安装日志文件的详细信息，
请参阅How to: View SQL Server 2005 Setup Log Files。
分析
我的电脑里安装了 SQL2005 、 SQL2008 SQLEXPRESS版本 、 SQL2012
我安装各个SQLSERVER的路径
SQL2005
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
SQL2008 SQLEXPRESS版本
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn
SQL2012
D:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Binn
上面三个路径都有一个sqlctr.ini文件
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_
查看更多关于SQLSERVER性能计数器的简单剖析的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did95367