SQL Server

The Technical Specifications below provide details on metrics collected by the SQL Server application, how those metrics are evaluated by Longitude, and the available preconfigured reports. For additional details on the Longitude SQL Server application, see the SQL Server Application User Guide or contact Heroix Support.

Events

Longitude Events are generated when collected performance and availability metrics are evaluated by Longitude’s rule engine and a potential problem is detected.

The rules use best-practice thresholds, displayed below, which can be customized as needed.

Reports

Longitude reports display performance and availability metrics over time. Summary reports display average metrics across multiple devices, while detail reports drill down and present a more granular view of metrics for a selected device.

 

Buffer Manager
Metrics Events
Buffer Cache Hit Ratio
Free Pages
Total Pages
Low Buffer Cache Efficiency: Buffer Cache Hit % < 95%
Reports
Summary Summary Buffer Cache Hit Pct Used per SQL Instance
Detail Detailed Buffer Cache Hit Pct Used for a specific SQL Instance
Databases
Metrics Events
Database Name
Data Files Size (KB)
Log Files Size (KB)
Percent Log Used
Transactions Started Per Second
Active Transactions
Pending Replication Transactions
Replication Transaction Rate
Log Growth
Transaction Logs Full: Log Files Used % > 85%
Reports
Summary Database Files Usage per SQL Server instances
Detail Database Files Usage per database on a specific SQL Server Instance
Disk
Metrics Events
Device
Disk Free Space Pct
Disk Free Space (KB)
% Disk Time
Current Disk Queue
Disk Space Low: Low Free % < 4%
Low Free MB < 1000
Failed Jobs
Metrics Events
Sample Time
Job ID
Step ID
Name
Server
Run Status
Severity
Run Date
Run Time
Message Text
Failed Jobs: Event created for any failed jobs
Reports
Detail Failed Job Details for a specific SQL Server Instance
Frequent Queries
Metrics Events
Last Execution Time
SQL Handle
Statement Start Offset
Statement End Offset
Execution Count
Query Text
Query Too Frequent: Query Count > 1000
Reports
Detail Most Frequently Performed Queries for a specific SQL Server Instance
Index
Metrics Events
Database Name
Table Name
Index ID
Partition Number
Index Type Description
Allocation Unit Type
Average Fragmentation Percent
High Index Fragmentation Pct: Index Frag % > 70%
Latches
Metrics Events
Average Wait Time
Latch Waits/sec
High Latch Wait Time: High Latch Wait Time > 500
Reports
Summary Latches Usage across multiple SQL Server Instances
Detail Latches Usage per SQL Server Instance
Locks
Metrics Events
Name
Average Wait Time
High Lock Wait Time: High Lock Wait Time > 1
Usual Percent Change > .35%
Longest Jobs
Metrics Events
Sample Time
Job ID
Step ID
Name
Server
Run Status
Severity
Run Date
Run Time
Duration
Message Text
Job Too Long: Job Duration (seconds) > 10
Reports
Detail Longest Job Details for a specific SQL Server Instance
Longest Queries
Metrics Events
Maximum Elapsed time (ms)
SQL Handle
Query Text
Query Too Slow: Query Elapsed Time (ms) > 1000
Reports
Detail Longest Queries for a specific SQL Server Instance
Memory Manager
Metrics Events
Memory Grants Pending
Memory Grants Outstanding
Target Server Memory (KB)
Total Server Memory (KB)
UserConnections
Low Free Memory: Memory Free % < 20
Too Many User Connections: # User Connections > 250
Reports
Summary Memory Grants across multiple SQL Server Instances
Detail Detailed Memory Grants per SQL Server Instance
Summary Memory Usage across multiple SQL Server Instances
Detail Detailed Memory Usage per SQL Server Instance
Summary User Connection across multiple SQL Server Instances
Detail Detailed User Connection per SQL Server Instance
Processes
Metrics Events
Handle
SQL Server Name
CPU Time
Memory Usage
Blocking Process ID
Hostname
Login
State
Command
Blocked Processes: Creates an event for each Blocked Process
High CPU Processes: Process CPU Time (seconds) > 600
Replication Distribution
Metrics Events
Distributor Name
Dist Delivered Cmds/sec
Dist Delivered Trans/sec
Dist Delivery Latency
Replication Latency High: Replication Latency (ms)>10000
Reports
Summary Replication Distribution Latency across multiple SQL Server Instances
Detail Detailed Replication Distribution Latency per SQL Server Instance
Summary Replication Distribution Rates across multiple SQL Server Instances
Detail Detailed Replication Distribution Rates per SQL Server Instance
Replication Logreader
Metrics Reports
Logreader Name
Logreader Delivered Cmds/sec
Logreader Delivered Trans/sec
Logreader Delivery Latency
Summary Replication Logreader Latency across multiple SQL Server Instances
Detail Detailed Replication Logreader Latency per SQL Server Instance
Summary Replication Logreader Rates across multiple SQL Server Instances
Detail Detailed Replication Logreader Rates per SQL Server Instance
Replication Merge
Metrics Reports
Merge Name
Conflicts/sec
Downloaded Changes/sec
Uploaded Changes/sec
Summary Replication Merge Rates across multiple SQL Server Instances
Detail Replication Merge Rates Detailed Replication Log Latency per SQL Server Instance
Replication Snapshot
Metrics Reports
Snapshot Name
Snapshot Delivered Cmds/sec
Snapshot Delivered Trans/sec
Summary Replication Snapshot Rates across multiple SQL Server Instances
Detail Detailed Replication Snapshot Rates per SQL Server Instance
Resources
Metrics Events
Memory Available MBytes
Memory Paging Per Second
Percent Processor Time
Processor Queue Length
Disk Read Time Seconds
Disk Write Time Seconds
High Disk Read Time: Disk Read Time (seconds)>10
High Disk Write Time: Disk Write Time (seconds)>10
High Page Rate: Pages per Second>1000
High Processor Pct: Processor Pct >90
High Processor Queue Length: Processor Pct >90
Processor Queue Length > 2
Low Available Memory: Available Memory MB < 50
Service
Metrics Events
Service Name
Exit code
Started
Start Mode
Is Server
Service Not Running: Sends alerts on stopped SQLServer services
Statistics
Metrics Events
Batch Requests/sec
Unsafe Auto-Params/sec
Unsafe Auto Params Rate High: Unsafe Autoparam Rate > 1
Data Throughput Low: Batch Requests Rate < .03
Reports
Summary Summary Batch Request Rate across multiple SQL instances
Detail Detailed Batch Request Rate per SQL instance
Wait Stats
Metrics Reports
Name
Lock Waits
Log Buffer waits
Lock write waits
Memory Grant Queue Waits
Network IO Waits
Non-page latch waits
Page IO latch waits
Page latch waits
Threadsafe memory object waits
Threadsafe ownership waits
Wait for the worker
Workspace Synchronization
Summary Summary Average I/O Wait across multiple SQL instances
Detail Detailed Average I/O Wait per SQL instance
Summary Summary Average Lock and Latch Wait across multiple SQL instances
Detail Detailed Average Lock and Latch Wait per SQL instances
Summary Summary Average Memory Wait across multiple SQL instances
Detail Detailed Average Memory Wait per SQL instances
Summary Summary Average Network Wait across multiple SQL instances
Detail Detailed Average Network Wait per SQL instances
Worst Queries
Metrics Events
Average CPU time (ms)
SQL Handle
Query Text
Query High Cpu: Query Avg CPU Time (ms) > 1000
Reports
Detail Worst Queries for a specific SQL Server Instance

Top
SNMP Trap Syslog