'Database name' as a delimiting factor for SQL Server perfmon counters

As a further reading after the performance tuning in shared secure environment, I am posting a list of SQL Server perfmon counters which take ‘database name’ as a delimiting parameter.

\SQLServer:Databases(database_name)\Active Transactions

Number of active update transactions for the database.

\SQLServer:Databases(database_name)\Backup/Restore Throughput/sec

Read/write throughput for backup/restore of a database.

\SQLServer:Databases(database_name)\Bulk Copy Rows/sec

Number of rows bulk copied.

\SQLServer:Databases(database_name)\Bulk Copy Throughput/sec

KiloBytes bulk copied.

\SQLServer:Databases(database_name)\Commit table entries

The size of the in-memory part of the commit table for the database.

\SQLServer:Databases(database_name)\Data File(s) Size (KB)

The cumulative size of all the data files in the database.

\SQLServer:Databases(database_name)\DBCC Logical Scan Bytes/sec

Logical read scan rate for DBCC commands

\SQLServer:Databases(database_name)\Log Bytes Flushed/sec

Total number of log bytes flushed.

\SQLServer:Databases(database_name)\Log Cache Hit Ratio

Percentage of log cache reads that were satisfied from the log cache.

\SQLServer:Databases(database_name)\Log Cache Reads/sec

Reads performed through the log manager cache.

\SQLServer:Databases(database_name)\Log File(s) Size (KB)

The cumulative size of all the log files in the database.

\SQLServer:Databases(database_name)\Log File(s) Used Size (KB)

The cumulative used size of all the log files in the database.

\SQLServer:Databases(database_name)\Log Flush Wait Time

Total wait time (milliseconds).

\SQLServer:Databases(database_name)\Log Flush Waits/sec

Number of commits waiting on log flush.

\SQLServer:Databases(database_name)\Log Flushes/sec

Number of log flushes.

\SQLServer:Databases(database_name)\Log Growths

Total number of log growths for this database.

\SQLServer:Databases(database_name)\Log Shrinks

Total number of log shrinks for this database.

\SQLServer:Databases(database_name)\Log Truncations

Total number of log truncations for this database.

\SQLServer:Databases(database_name)\Percent Log Used

The percent of space in the log that is in use.

\SQLServer:Databases(database_name)\Repl. Pending Xacts

Number of pending replication transactions in the database.

\SQLServer:Databases(database_name)\Repl. Trans. Rate

Replication transaction rate (replicated transactions/sec.).

\SQLServer:Databases(database_name)\Shrink Data Movement Bytes/sec

The rate data is being moved by Autoshrink, DBCC SHRINKDATABASE or SHRINKFILE.

\SQLServer:Databases(database_name)\Tracked transactions/sec

Number of committed transactions recorded in the commit table for the database.

\SQLServer:Databases(database_name)\Transactions/sec

Number of transactions started for the database.

\SQLServer:Databases(database_name)\Write Transactions/sec

Number of transactions which wrote to the database in the last second.

 

So, here is what detailed information you can get from perfmon (or typeperf.exe) for specific databases.

 

 

1 comment to ‘Database name’ as a delimiting factor for SQL Server perfmon counters