This topic details the MSSQL 2012 Server metrics.

Log Track Supported: Yes

Config Track Supported: No

Table 1. Custom Properties Supported

Name

Description

version

SQL Server Version

Supported Control Actions: start, stop, restart

Table 2. Supported Metrics

Name

Alias

Units

Category

Default On

Default Interval

Availability

Availability

percentage

AVAILABILITY

true

5 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

Full Scans

FullScans

none

UTILIZATION

false

10 min

Full Scans per Minute

FullScans1m

none

UTILIZATION

false

10 min

Worktables Created

WorktablesCreated

none

UTILIZATION

false

10 min

Worktables Created per Minute

WorktablesCreated1m

none

UTILIZATION

false

10 min

Workfiles Created

WorkfilesCreatedSec

none

UTILIZATION

false

10 min

Workfiles Created per Minute

WorkfilesCreatedSec1m

none

UTILIZATION

false

10 min

Worktables From Cache Ratio

WorktablesFromCacheRatio

none

UTILIZATION

false

5 min

Page Splits

PageSplitsSec

none

UTILIZATION

false

10 min

Page Splits per Minute

PageSplitsSec1m

none

UTILIZATION

false

10 min

Logins

Logins

none

UTILIZATION

false

10 min

Logins per Minute

Logins1m

none

UTILIZATION

false

10 min

Logouts

Logouts

none

UTILIZATION

false

10 min

Logouts per Minute

Logouts1m

none

UTILIZATION

false

10 min

User Connections

UserConnections

none

UTILIZATION

false

5 min

Connection Memory

ConnectionMemory

KB

UTILIZATION

false

5 min

Granted Workspace Memory

GrantedWorkspaceMemory

KB

UTILIZATION

false

5 min

Lock Memory

LockMemory

KB

UTILIZATION

false

5 min

Lock Blocks Allocated

LockBlocksAllocated

none

UTILIZATION

false

5 min

Lock Owner Blocks Allocated

LockOwnerBlocksAllocated

none

UTILIZATION

false

5 min

Lock Blocks

LockBlocks

none

UTILIZATION

false

5 min

Lock Owner Blocks

LockOwnerBlocks

none

UTILIZATION

false

5 min

Maximum Workspace Memory

MaximumWorkspaceMemory

KB

UTILIZATION

false

5 min

Memory Grants Outstanding

MemoryGrantsOutstanding

none

UTILIZATION

false

5 min

Memory Grants Pending

MemoryGrantsPending

none

UTILIZATION

false

5 min

Optimizer Memory

OptimizerMemory

KB

UTILIZATION

false

5 min

SQL Cache Memory

SQLCacheMemory

KB

UTILIZATION

false

5 min

Total Server Memory

TotalServerMemory

KB

UTILIZATION

false

5 min

Lock Requests

LockRequests

none

UTILIZATION

false

10 min

Lock Requests per Minute

LockRequests1m

none

UTILIZATION

true

10 min

Lock Timeouts

LockTimeouts

none

UTILIZATION

false

10 min

Lock Timeouts per Minute

LockTimeouts1m

none

UTILIZATION

false

10 min

Number of Deadlocks

NumDeadlocks

none

UTILIZATION

false

10 min

Number of Deadlocks per Minute

NumDeadlocks1m

none

UTILIZATION

false

10 min

Lock Waits

LockWaits

none

UTILIZATION

false

10 min

Lock Waits per Minute

LockWaits1m

none

UTILIZATION

true

10 min

Lock Wait Time

LockWaitTime

ms

UTILIZATION

false

5 min

Average Wait Time

AverageWaitTime

ms

UTILIZATION

false

5 min

Average Latch Wait Time

AverageLatchWaitTime

ms

UTILIZATION

false

5 min

Total Latch Wait Time

TotalLatchWaitTime

ms

UTILIZATION

false

5 min

Free pages

Freepages

none

UTILIZATION

false

5 min

Stolen pages

Stolenpages

none

UTILIZATION

false

5 min

Page life expectancy

Pagelifeexpectancy

sec

UTILIZATION

false

5 min

Lazy Writes

LazyWrites

none

UTILIZATION

false

10 min

Lazy Writes per Minute

LazyWrites1m

none

UTILIZATION

false

10 min

Checkpoint Pages

CheckpointPages

none

UTILIZATION

false

10 min

Checkpoint Pages per Minute

CheckpointPages1m

none

UTILIZATION

false

10 min

Page reads

Pagereads

none

UTILIZATION

false

10 min

Page reads per Minute

Pagereads1m

none

UTILIZATION

false

10 min

Page writes

Pagewrites

none

UTILIZATION

false

10 min

Page writes per Minute

Pagewrites1m

none

UTILIZATION

false

10 min

Buffer Cache hit ratio

BufferCachehitratio

percent

UTILIZATION

false

5 min

Configuration Help