This topic details the MSSQL 2008 R2 Database Service metrics.

Log Track Supported: No

Config Track Supported: No

Custom Properties Supported: None

Supported Control Actions: None

Table 1. Supported Metrics

Name

Alias

Units

Category

Default On

Default Interval

Database Free Percent

DatabaseFreePercent

percent

UTILIZATION

false

5 min

Availability

Availability

percentage

AVAILABILITY

true

10 min

Data File Size

DataFileSize

KB

UTILIZATION

true

5 min

Log File Size

LogFileSize

KB

UTILIZATION

false

5 min

Log File Used Size

LogFileUsedSize

KB

UTILIZATION

false

5 min

Percent Log Used

PercentLogUsed

percentage

UTILIZATION

false

5 min

Active Transactions

ActiveTransactions

none

THROUGHPUT

true

5 min

Transactions

Transactions

none

THROUGHPUT

false

10 min

Transactions per Minute

Transactions1m

none

THROUGHPUT

true

10 min

Transactions

Transactions

none

THROUGHPUT

false

5 min

Replication Pending Transactions

ReplPendingTx

none

UTILIZATION

false

5 min

Replication Transaction Rate

ReplTransRate

none

UTILIZATION

false

5 min

Log Cache Hit Ratio

LogCacheHitRatio

none

UTILIZATION

false

5 min

Log Flush Wait Time

LogFlushWaitTime

none

UTILIZATION

false

5 min

Log Truncations

LogTruncations

none

UTILIZATION

false

5 min

Log Growths

LogGrowths

none

UTILIZATION

false

5 min

Log Shrinks

LogShrinks

none

UTILIZATION

false

5 min

Configuration Help