📄 sqlctr.ini
字号:
DB_FLUSHES_009_NAME=Log Flushes/sec
DB_FLUSHES_009_HELP=Number of log flushes.
DB_BYTES_FLUSHED_009_NAME=Log Bytes Flushed/sec
DB_BYTES_FLUSHED_009_HELP=Total number of log bytes flushed.
DB_FLUSH_WAITS_009_NAME=Log Flush Waits/sec
DB_FLUSH_WAITS_009_HELP=Number of commits waiting on log flush.
DB_FLUSH_WAIT_TIME_009_NAME=Log Flush Wait Time
DB_FLUSH_WAIT_TIME_009_HELP=Total wait time (milliseconds).
DB_LOG_TRUNCS_009_NAME=Log Truncations
DB_LOG_TRUNCS_009_HELP=Total number of log truncations for this database.
DB_LOG_GROWTHS_009_NAME=Log Growths
DB_LOG_GROWTHS_009_HELP=Total number of log growths for this database.
DB_LOG_SHRINKS_009_NAME=Log Shrinks
DB_LOG_SHRINKS_009_HELP=Total number of log shrinks for this database.
LATCH_WAITS_NP_009_NAME=Latch Waits/sec
LATCH_WAITS_NP_009_HELP=Number of latch requests that could not be granted immediately and had to wait before being granted.
LATCH_AVG_WAIT_NP_009_NAME=Average Latch Wait Time (ms)
LATCH_AVG_WAIT_NP_009_HELP=Average latch wait time (milliseconds) for latch requests that had to wait.
LATCH_AVG_WAIT_BASE_009_NAME=Average Latch Wait Time Base
LATCH_AVG_WAIT_BASE_009_HELP=Base for Average Latch Wait Time.
LATCH_TOTAL_WAIT_NP_009_NAME=Total Latch Wait Time (ms)
LATCH_TOTAL_WAIT_NP_009_HELP=Total latch wait time (milliseconds) for latch requests that had to wait in the last second.
AM_FULL_SCAN_009_NAME=Full Scans/sec
AM_FULL_SCAN_009_HELP=Number of unrestricted full scans. These can either be base table or full index scans.
AM_RANGE_SCAN_009_NAME=Range Scans/sec
AM_RANGE_SCAN_009_HELP=Number of qualified range scans through indexes.
AM_PROBE_SCAN_009_NAME=Probe Scans/sec
AM_PROBE_SCAN_009_HELP=Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
AM_SCAN_REPOSITION_009_NAME=Scan Point Revalidations/sec
AM_SCAN_REPOSITION_009_HELP=Number of times the scan point had to be revalidated to continue the scan.
AM_WORKFILES_CREATED_009_NAME=Workfiles Created/sec
AM_WORKFILES_CREATED_009_HELP=Number of workfiles created in the last second.
AM_WORKTABLES_CREATED_009_NAME=Worktables Created/sec
AM_WORKTABLES_CREATED_009_HELP=Number of worktables created in the last second.
AM_WORKTABLES_FROM_CACHE_009_NAME=Worktables From Cache Ratio
AM_WORKTABLES_FROM_CACHE_009_HELP=Percent of worktables created where the initial pages were available in the worktable cache.
AM_WORKTABLES_FROM_CACHE_BASE_009_NAME=Worktables From Cache Base
AM_WORKTABLES_FROM_CACHE_BASE_009_HELP=Percent of worktables from cache base.
AM_FORWARDED_RECS_009_NAME=Forwarded Records/sec
AM_FORWARDED_RECS_009_HELP=Number of records fetched through forwarded record pointers.
AM_GHOSTED_SKIPS_009_NAME=Skipped Ghosted Records/sec
AM_GHOSTED_SKIPS_009_HELP=Number of ghosted records skipped during scans.
AM_INDEX_SEARCHES_009_NAME=Index Searches/sec
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.
AM_FREESPACE_SCANS_009_NAME=FreeSpace Scans/sec
AM_FREESPACE_SCANS_009_HELP=Number of scans initiated to search for free space to insert a new record fragment.
AM_FREESPACE_PAGES_009_NAME=FreeSpace Page Fetches/sec
AM_FREESPACE_PAGES_009_HELP=Number of pages returned by free space scans to satisfy requests to insert record fragments.
AM_PAGES_ALLOCATED_009_NAME=Pages Allocated/sec
AM_PAGES_ALLOCATED_009_HELP=Number of pages allocated to database objects for storing index or data records.
AM_EXTENTS_ALLOCATED_009_NAME=Extents Allocated/sec
AM_EXTENTS_ALLOCATED_009_HELP=Number of extents allocated to database objects for storing index or data records.
AM_SINGLE_PAGE_ALLOCS_009_NAME=Mixed page allocations/sec
AM_SINGLE_PAGE_ALLOCS_009_HELP=Number of pages allocated from mixed extents. Used for storing the first eight pages allocated to an index or table.
AM_EXTENTS_DEALLOCATED_009_NAME=Extent Deallocations/sec
AM_EXTENTS_DEALLOCATED_009_HELP=Number of extents deallocated from database objects.
AM_PAGE_DEALLOCS_009_NAME=Page Deallocations/sec
AM_PAGE_DEALLOCS_009_HELP=Number of pages deallocated.
AM_PAGE_SPLITS_009_NAME=Page Splits/sec
AM_PAGE_SPLITS_009_HELP=Number of page splits occurring as the result of index pages overflowing.
AM_LOCKESCALATIONS_009_NAME=Table Lock Escalations/sec
AM_LOCKESCALATIONS_009_HELP=The number of times locks on a table were escalated.
SQL_BATCH_REQ_009_NAME=Batch Requests/sec
SQL_BATCH_REQ_009_HELP=Number of SQL batch requests received by server.
SQL_AUTOPARAM_REQ_009_NAME=Auto-Param Attempts/sec
SQL_AUTOPARAM_REQ_009_HELP=Number of auto-parameterization attempts.
SQL_AUTOPARAM_FAIL_009_NAME=Failed Auto-Params/sec
SQL_AUTOPARAM_FAIL_009_HELP=Number of failed auto-parameterizations.
SQL_AUTOPARAM_SAFE_009_NAME=Safe Auto-Params/sec
SQL_AUTOPARAM_SAFE_009_HELP=Number of safe auto-parameterizations.
SQL_AUTOPARAM_UNSAFE_009_NAME=Unsafe Auto-Params/sec
SQL_AUTOPARAM_UNSAFE_009_HELP=Number of unsafe auto-parameterizations.
SQL_COMPILES_009_NAME=SQL Compilations/sec
SQL_COMPILES_009_HELP=Number of SQL compilations.
SQL_RECOMPILES_009_NAME=SQL Re-Compilations/sec
SQL_RECOMPILES_009_HELP=Number of SQL re-compiles.
CACHE_HIT_RATIO_009_NAME=Cache Hit Ratio
CACHE_HIT_RATIO_009_HELP=Ratio between cache hits and lookups
CACHE_HIT_RATIO_BASE_009_NAME=Cache Hit Ratio Base
CACHE_HIT_RATIO_BASE_009_HELP=Base for prior entry
CACHE_PGS_IN_USE_009_NAME=Cache Pages
CACHE_PGS_IN_USE_009_HELP=Number of 8k pages used by cache objects
CACHE_OBJECT_COUNT_009_NAME=Cache Object Counts
CACHE_OBJECT_COUNT_009_HELP=Number of cache objects in the cache
CACHE_USE_COUNT_009_NAME=Cache Use Counts/sec
CACHE_USE_COUNT_009_HELP=Times each type of cache object has been used
MEMORY_CONNECTION_MEMORY_009_NAME=Connection Memory (KB)
MEMORY_CONNECTION_MEMORY_009_HELP=Total amount of dynamic memory the server is using for maintaining connections
MEMORY_MEMGRANT_OUTSTANDING_009_NAME=Granted Workspace Memory (KB)
MEMORY_MEMGRANT_OUTSTANDING_009_HELP=Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations.
MEMORY_LOCK_MEMORY_009_NAME=Lock Memory (KB)
MEMORY_LOCK_MEMORY_009_HELP=Total amount of dynamic memory the server is using for locks
MEMORY_LOCKS_ALLOCATED_009_NAME=Lock Blocks Allocated
MEMORY_LOCKS_ALLOCATED_009_HELP=The current number of allocated lock blocks.
MEMORY_LOCKOWNERS_ALLOCATED_009_NAME=Lock Owner Blocks Allocated
MEMORY_LOCKOWNERS_ALLOCATED_009_HELP=The current number of allocated lock owner blocks.
MEMORY_LOCKS_009_NAME=Lock Blocks
MEMORY_LOCKS_009_HELP=The current number of lock blocks that are in use on the server. Refreshed periodically.
MEMORY_LOCKOWNERS_009_NAME=Lock Owner Blocks
MEMORY_LOCKOWNERS_009_HELP=The number of lock owner blocks that are currently in use on the server. Refreshed periodically.
MEMORY_MEMGRANT_MAXIMUM_009_NAME=Maximum Workspace Memory (KB)
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.
MEMORY_MEMGRANT_ACQUIRES_009_NAME=Memory Grants Outstanding
MEMORY_MEMGRANT_ACQUIRES_009_HELP=Current number of processes that have successfully acquired a workspace memory grant
MEMORY_MEMGRANT_WAITERS_009_NAME=Memory Grants Pending
MEMORY_MEMGRANT_WAITERS_009_HELP=Current number of processes waiting for a workspace memory grant
MEMORY_OPTIMIZER_MEMORY_009_NAME=Optimizer Memory (KB)
MEMORY_OPTIMIZER_MEMORY_009_HELP=Total amount of dynamic memory the server is using for query optimization
MEMORY_SQL_CACHE_MEMORY_009_NAME=SQL Cache Memory (KB)
MEMORY_SQL_CACHE_MEMORY_009_HELP=Total amount of dynamic memory the server is using for the dynamic SQL cache
MEMORY_SERVER_MEMORY_TARGET_009_NAME=Target Server Memory(KB)
MEMORY_SERVER_MEMORY_TARGET_009_HELP=Total amount of dynamic memory the server is willing to consume
MEMORY_SERVER_MEMORY_009_NAME=Total Server Memory (KB)
MEMORY_SERVER_MEMORY_009_HELP=Total amount of dynamic memory the server is currently consuming
QUERY_INSTANCE_009_NAME=Query
QUERY_INSTANCE_009_HELP=As defined by the user.
RUNNING_INSTANCE_009_NAME=Running
RUNNING_INSTANCE_009_HELP=The number of replication agents currently running.
UPLOAD_INSTANCE_009_NAME=Uploaded Changes/sec
UPLOAD_INSTANCE_009_HELP=The number of rows per second merged from the Subscriber to the Publisher.
DOWNLOAD_INSTANCE_009_NAME=Downloaded Changes/sec
DOWNLOAD_INSTANCE_009_HELP=The number of rows per second merged from the Publisher to the Subscriber.
MERGE_CONFLICTS_INSTANCE_009_NAME=Conflicts/sec
MERGE_CONFLICTS_INSTANCE_009_HELP=The number of conflicts per second occurring during the merge process.
LOGREADER_LATENCY_INSTANCE_009_NAME=Logreader:Delivery Latency
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.
LOGREADER_COMMANDS_INSTANCE_009_NAME=Logreader:Delivered Cmds/sec
LOGREADER_COMMANDS_INSTANCE_009_HELP=The number of commands per second delivered to the Distributor.
LOGREADER_TRANSACTIONS_INSTANCE_009_NAME=Logreader:Delivered Trans/sec
LOGREADER_TRANSACTIONS_INSTANCE_009_HELP=The number of transactions per second delivered to the Distributor.
DISTRIBUTION_LATENCY_INSTANCE_009_NAME=Dist:Delivery Latency
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.
DISTRIBUTION_COMMANDS_INSTANCE_009_NAME=Dist:Delivered Cmds/sec
DISTRIBUTION_COMMANDS_INSTANCE_009_HELP=The number of commands per second delivered to the Subscriber.
DISTRIBUTION_TRANS_INSTANCE_009_NAME=Dist:Delivered Trans/sec
DISTRIBUTION_TRANS_INSTANCE_009_HELP=The number of transactions per second delivered to the Subscriber.
SNAPSHOT_COMMANDS_BCPED_009_NAME=Snapshot:Delivered Cmds/sec
SNAPSHOT_COMMANDS_BCPED_009_HELP=The number of commands per second delivered to the Distributor.
SNAPSHOT_TRANSACTIONS_BCPED_009_NAME=Snapshot:Delivered Trans/sec
SNAPSHOT_TRANSACTIONS_BCPED_009_HELP=The number of transactions per second delivered to the Distributor.
DB_BCK_DEV_THROUGHPUT_009_NAME=Device Throughput Bytes/sec
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -