SQL Server、Databases 物件SQL Server, Databases Object

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions)

SQL Server 中的 SQLServer:Databases 物件提供計數器,可用來監視大量複製作業、備份和還原輸送量以及交易記錄活動。The SQLServer:Databases object in SQL Server provides counters to monitor bulk copy operations, backup and restore throughput, and transaction log activities. 監視交易和交易記錄檔,可以判斷資料庫中有多少使用者活動,以及交易記錄檔有多滿。Monitor transactions and the transaction log to determine how much user activity is occurring in the database and how full the transaction log is becoming. 使用者活動量可用來判斷資料庫的效能,並且會影響記錄檔大小、鎖定和複寫。The amount of user activity can determine the performance of the database and affect log size, locking, and replication. 監視低階記錄檔活動,則可量測使用者活動和資源使用量,以協助您找出效能瓶頸。Monitoring low-level log activity to gauge user activity and resource usage can help you to identify performance bottlenecks.

您可同時監視 Databases 物件的多個執行個體,每個執行個體都代表一個資料庫。Multiple instances of the Databases object, each representing a single database, can be monitored at the same time.

下表描述 SQL Server Databases 計數器。This table describes the SQL Server Databases counters.

SQL Server Databases 計數器SQL Server Databases counters 描述Description
Active TransactionsActive Transactions 資料庫的使用中交易數。Number of active transactions for the database.
Avg Dist From EOL/LP RequestAvg Dist From EOL/LP Request 從每個記錄集區要求的記錄檔結尾之平均距離 (以位元組為單位),供最後一個 VLF 中的要求之用。Average distance in bytes from end of log per log pool request, for requests in the last VLF.
Backup/Restore Throughput/secBackup/Restore Throughput/sec 每秒的資料庫備份和還原作業之讀取/寫入輸送量。Read/write throughput for backup and restore operations of a database per second. 例如,您可以測量同時使用更多個備份裝置或是使用了更快的裝置時,資料庫備份作業的效能改變情形。For example, you can measure how the performance of the database backup operation changes when more backup devices are used in parallel or when faster devices are used. 資料庫備份或還原作業的輸送量,可讓您判斷備份和還原作業的進度和效能。Throughput of a database backup or restore operation allows you to determine the progress and performance of your backup and restore operations.
Bulk Copy Rows/secBulk Copy Rows/sec 每秒大量複製 (Bulk Copy) 的資料列數。Number of rows bulk copied per second.
Bulk Copy Throughput/secBulk Copy Throughput/sec 每秒大量複製的資料量 (以 KB 為單位)。Amount of data bulk copied (in kilobytes) per second.
Commit table entriesCommit table entries 資料庫認可資料表之記憶體內部部分的大小 (資料列計數)。The size (row count) of the in-memory portion of the commit table for the database. 如需詳細資訊,請參閱 sys.dm_tran_commit_table (Transact-SQL)For more information, see sys.dm_tran_commit_table (Transact-SQL).
Data File(s) Size (KB)Data File(s) Size (KB) 資料庫內的所有資料檔案總計大小 (以 KB 為單位),包含任何自動的成長。Cumulative size (in kilobytes) of all the data files in the database including any automatic growth. 監視此計數器很有用,例如可決定 tempdb 的正確大小。Monitoring this counter is useful, for example, for determining the correct size of tempdb.
DBCC Logical Scan Bytes/secDBCC Logical Scan Bytes/sec 資料庫主控台命令 (DBCC) 每秒的邏輯讀取掃描位元組數。Number of logical read scan bytes per second for database console commands (DBCC).
Group Commit Time/secGroup Commit Time/sec 每秒的群組延遲時間 (百萬分之一秒)。Group stall time (microseconds) per second.
Log Bytes Received/secLog Bytes Flushed/sec 轉存的記錄檔位元組總數。Total number of log bytes flushed.
Log Cache Hit RatioLog Cache Hit Ratio 記錄檔快取所滿足的記錄檔快取讀取百分比。Percentage of log cache reads satisfied from the log cache.
Log Cache Hit Ratio BaseLog Cache Hit Ratio Base 僅供內部使用。For internal use only.
Log Cache Reads/secLog Cache Reads/sec 每秒透過記錄檔管理員快取所執行的讀取數。Reads performed per second through the log manager cache.
Log File(s) Size (KB)Log File(s) Size (KB) 資料庫內所有交易記錄檔的總計大小 (以位元組為單位)。Cumulative size (in kilobytes) of all the transaction log files in the database.
Log File(s) Used Size (KB)Log File(s) Used Size (KB) 資料庫中所有記錄檔的總計使用大小。The cumulative used size of all the log files in the database.
Log Flush Wait TimeLog Flush Wait Time 排清記錄檔的等候時間總計 (以毫秒為單位)。Total wait time (in milliseconds) to flush the log. 在 AlwaysOn 次要資料庫上,此值表示記錄檔記錄強行寫入磁碟的等候時間。On an Always On secondary database, this value indicates the wait time for log records to be hardened to disk.
Log Flush Waits/secLog Flush Waits/sec 每秒鐘等候記錄檔排清的認可數。Number of commits per second waiting for the log flush.
Log Flush Write Time (ms)Log Flush Write Time (ms) 執行在最後一筆記錄中完成之記錄檔排清寫入的時間 (以毫秒為單位)。Time in milliseconds for performing writes of log flushes that were completed in the last second.
Log Flushes/secLog Flushes/sec 每秒的記錄檔排清數目。Number of log flushes per second.
Log GrowthsLog Growths 資料庫之交易記錄檔的擴大總次數。Total number of times the transaction log for the database has been expanded.
Log Pool Cache Misses/secLog Pool Cache Misses/sec 記錄檔區塊無法在記錄檔集區中使用的要求數目。Number of requests for which the log block was not available in the log pool. 「記錄集區」是交易記錄的記憶體中快取。The log pool is an in-memory cache of the transaction log. 此快取是用來最佳化記錄的讀取,以便進行復原、交易複寫、回復和 Always On 可用性群組Always On availability groupsThis cache is used to optimize reading the log for recovery, transaction replication, rollback, and Always On 可用性群組Always On availability groups.
Log Pool Disk Reads/secLog Pool Disk Reads/sec 由記錄檔集區發出來提取記錄檔區塊的磁碟讀取數目。Number of disk reads that the log pool issued to fetch log blocks.
Log Pool Hash Deletes/secLog Pool Hash Deletes/sec 從記錄集區刪除原始雜湊項目的比率。Rate of raw hash entry deletes from the Log Pool.
Log Pool Hash Inserts/secLog Pool Hash Inserts/sec 原始雜湊項目插入記錄集區的速率。Rate of raw hash entry inserts into the Log Pool.
Log Pool Invalid Hash Entry/secLog Pool Invalid Hash Entry/sec 因為無效而導致雜湊查閱失敗的比率。Rate of hash lookups failing due to being invalid.
Log Pool Log Scan Pushes/secLog Pool Log Scan Pushes/sec 可能來自於磁碟或記憶體而由記錄掃描所發送的記錄區塊比率。Rate of Log block pushes by log scans, which may come from disk or memory.
Log Pool LogWriter Pushes/secLog Pool LogWriter Pushes/sec 記錄寫入器執行緒所發送的記錄區塊比率。Rate of Log block pushes by log writer thread.
Log Pool Push Empty FreePool/secLog Pool Push Empty FreePool/sec 因可用集區空白而造成記錄區塊發送失敗的比率。Rate of Log block push fails due to empty free pool.
Log Pool Push Low Memory/secLog Pool Push Low Memory/sec 因記憶體不足而造成記錄區塊發送失敗的比率。Rate of Log block push fails due to being low on memory.
Log Pool Push No Free Buffer/secLog Pool Push No Free Buffer/sec 因可用緩衝區無法使用而造成記錄區塊發送失敗的比率。Rate of Log block push fails due to free buffer unavailable.
Log Pool Req.Behind Trunc/secLog Pool Req. Behind Trunc/sec 因為要求的區塊在截斷 LSN 後面,所以遺漏了記錄集區快取。Log pool cache misses due to block requested being behind truncation LSN.
Log Pool Requests BaseLog Pool Requests Base 僅供內部使用。For internal use only.
Log Pool Requests Old VLF/secLog Pool Requests Old VLF/sec 不在日誌最後一個 VLF 中的記錄集區要求。Log Pool requests that were not in the last VLF of the log.
Log Pool Requests/secLog Pool Requests/sec 記錄檔集區處理的記錄檔區塊要求數目。The number of log-block requests processed by the log pool.
Log Pool Total Active Log SizeLog Pool Total Active Log Size 儲存在共用快取緩衝區管理員中的目前使用中記錄總計 (位元組)。Current total active log stored in the shared cache buffer manager in bytes.
Log Pool Total Shared Pool SizeLog Pool Total Shared Pool Size 共用快取緩衝區管理員的目前憶體使用量總記 (位元組)。Current total memory usage of the shared cache buffer manager in bytes.
Log ShrinksLog Shrinks 這個資料庫的記錄壓縮總數。Total number of log shrinks for this database.
Log TruncationsLog Truncations 交易記錄截斷的次數 (在簡單復原模式下)。The number of times the transaction log has been truncated (in Simple Recovery Model).
Percent Log UsedPercent Log Used 使用中的記錄檔空間百分比。Percentage of space in the log that is in use.
Repl.Pending XactsRepl. Pending Xacts 標示成複寫、但未傳送到散發資料庫的發行集資料庫內的交易記錄檔之交易數。Number of transactions in the transaction log of the publication database marked for replication, but not yet delivered to the distribution database.
Repl.Trans.RateRepl. Trans. Rate 每秒自發行集資料的交易記錄檔讀取並傳送至散發資料庫的交易數。Number of transactions per second read out of the transaction log of the publication database and delivered to the distribution database.
Shrink Data Movement Bytes/secShrink Data Movement Bytes/sec 經由自動壓縮作業或是 DBCC SHRINKDATABASE 或 DBCC SHRINKFILE 陳述式移動的每秒資料量。Amount of data being moved per second by autoshrink operations, or DBCC SHRINKDATABASE or DBCC SHRINKFILE statements.
Tracked transactions/secTracked transactions/sec 資料庫的認可資料表中記錄的已認可交易數目。Number of committed transactions recorded in the commit table for the database.
Transactions/secTransactions/sec 每秒針對資料庫啟動的交易數。Number of transactions started for the database per second.

[Transactions/sec] 並未計入僅限 XTP 交易 (由原生編譯的預存程序啟動的交易)。Transactions/sec does not count XTP-only transactions (transactions started by a natively compiled stored procedure)..
Write Transactions/secWrite Transactions/sec 上一秒寫入資料庫並認可的交易數目。Number of transactions that wrote to the database and committed, in the last second.
XTP Controller DLC Latency BaseXTP Controller DLC Latency Base 僅供內部使用。For internal use only.
XTP Controller DLC Latency/FetchXTP Controller DLC Latency/Fetch 從記錄區塊輸入直接記錄取用者到 XTP 控制器加以擷取之間,每秒的平均延遲 (微秒)。Average latency in microseconds between log blocks entering the Direct Log Consumer and being retrieved by the XTP controller, per second.
XTP Controller DLC Peak LatencyXTP Controller DLC Peak Latency XTP 控制器所記錄,從直接記錄取用者提取的最長延遲時間 (微秒)。The largest recorded latency, in microseconds, of a fetch from the Direct Log Consumer by the XTP controller.
XTP Controller Log Processed/secXTP Controller Log Processed/sec XTP 控制器執行緒每秒處理的記錄檔位元組數量。The amount of log bytes processed by the XTP controller thread, per second.
XTP Memory Used (KB)XTP Memory Used (KB) 資料庫中 XTP 所使用的記憶體數量。The amount of memory used by XTP in the database.

另請參閱See Also

監視資源使用量 (系統監視器) Monitor Resource Usage (System Monitor)
SQL Server 的 Database ReplicaSQL Server, Database Replica