MsSQL 2005 server
MsSQL 2005 server
Log Track Supported: Yes
Config Track Supported: No
Custom Properties Supported:
| Name | Description |
|---|---|
| version | SQL Server Version |
Supported Control Actions: start,stop,restart
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 | true | 10 min |
| Transactions per Minute | Transactions1m | none | THROUGHPUT | true | 10 min |
| Transactions per Second | TransactionsSec | 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 |
| Worktables From Cache Ratio | WorktablesFromCacheRatio | none | UTILIZATION | false | 5 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 |
| Target Server Memory | TargetServerMemory | KB | UTILIZATION | false | 5 min |
| Total Server Memory | TotalServerMemory | KB | UTILIZATION | false | 5 min |
| Lock Requests | LockRequests | none | UTILIZATION | true | 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 | true | 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 |
| Cache Hit Ratio | CacheHitRatio | none | UTILIZATION | false | 5 min |
| Cache Pages | CachePages | none | UTILIZATION | false | 5 min |
| Cache Object Counts | CacheObjectCounts | none | UTILIZATION | false | 5 min |
Configuration help:
General Log and Config Track Properties
- Enable Log Tracking - Check to enable log tracking.
- Track event log level - Only track events of level greater than or equal to this level. Order is: [Error, Warn, Info, Debug]
- Log Pattern Match - Include messages that match the given regular expression. The given pattern can be a substring to look for in log messages or a regular expression. See: java.util.regex.Pattern.
- Log Pattern Exclude - Exclude messages that match the given regular expression.