Dashboards, alerts and metrics
  • SQLBeat's built-in alerting system is rule based and table driven. Rules are business-hours aware and can be directed to any number of users, and for each any number of email addresses. Category, as well as regular expression matching is available to select messages.

    All automated monitoring output passes through a single rules engine, allowing customized delivery based on server, application, message text or type.

    SQLBeat's integrated ASP.net based Dashboards allow you to easily query and configure monitoring of both Enterprise and SQL resources.

    Included with the base SQLBeat implementation are Enterprise and SQL Server dashboards, which provide access to reports including:

    Active Connections Shows the number of connections to your SQL Server, graphed over time
    Page Life Expectancy Shows SQL's overall page life expectancy measure, graphed over time
    Server CPU and Disk Load by Hour Shows relative CPU and Disk load over time
    Relative CPU Load by Database Shows the relative CPU load per database over time
    Relative Disk Load by Database Shows the relative Disk load per database over time
    Relative CPU Load by Database Shows the relative CPU load per database over the last 24 hours in a pie chart
    Relative Disk Load by Database Shows the relative Disk load per database over the last 24 hours in a pie chart
    CPU and Disk Load by Database Shows a minute-by-minute summary of CPU and Disk activity totals per database
    SQL Job History Breaks the previous 24 hours down into 5 minute windows, and shows whats jobs were running during each window
    SQL Memory Allocation A report on SQL Server's current state of memory
    Long Running Queries Lists long running queries observed
    Query Load Shows the top queries running and the respective CPU and Disk load each generates
    Frequently Recompiling Queries Shows the top recompiled stored procedures, functions and ad-hoc queries
    Remote Queries Shows the top queries accessing remote resources or from remote sources
    Most run queries Shows the queries most often run over the last 48 hours
    Parallelism Shows queries that have blocked themselves due to parallelism
    Blocked Queries Showing the buffer contents and locks status of the queries most often seen to be blocked
    Blocking queries Showing the buffer contents and block duration of the queries most often seen to be blocking
    Blocking Event Detail Shows instances of blocking and locks held by blocker/blockee
    Query CPU Cycles Shows top query CPU consumers
    Query CPU Load by Hour Shows top query CPU consumers by hour
    Query Disk IO Shows top query Disk IO consumers in the previous few hours
    Query Disk IO Shows top query Disk IO consumers in the previous 48 hours
    Process Waits Shows a historical breakdown (wait time and frequency) of SQL Server's wait types, compared to a rolling 24 hour window
    Server Waits Shows a breakdown of sever level waiting, including disk, memory and internal factors
    CPU Waits Shows the times when CPU waiting was observed within the last 48 hours
    Disk Waits Shows the times, database files and disks where Disk waiting was observed within the last 48 hours
    Disk Waits by Hour Shows the number of requests and waiting time, broken down into hour windows aggregated over the last few days
    Buffer Cache - Current Contents Shows a list of the tables/indexes currently in buffer cache memory, and how many buffers each consumes
    Buffer Cache Contents (pie) Shows a pie graph of the objects current in buffer cache memory
    Buffer Cache History Shows a table/index breakdown of buffer cache activity, including high/low number of buffers consumed, as well as an overall buffer cache i/o delta
    Buffer Cache Table History Shows a table-rollup of the Buffer Cache History report
    Buffer Cache Database History Shows a database-rollup of buffer cache activity, including high/low number of buffers consumes as well as an overall buffer cache i/o delta
    Database Growth Summary Shows a summary of the beginning and ending sizes for each database
    Database Weekly Growth Shows a weekly summary of database growth, broken down by week
    Database Growth Event History Shows a list of the times when database files changed in size over the previous week
    Backup Summary Shows when each database was last backed up, where it was backed up and what the size on disk of the backup was
    Database Activity Summary Shows a summary of table and index activity, aggregated by database. This includes total table rows, buffer cache entries, index scans, index seeks, index updates and bookmark lookups
    Database Last User Activity Shows the last recorded date of user activity in each database
    Table Fragmentation Shows the results of the most recent table fragmentation scan
    Table Sizes Shows the number of rows, data and index size for tables in all databases
    Index 24 Hour Summary Shows count of scans, seeks, updates and lookups performed on each index in the past 24 hours
    Index Week Summary Shows count of scans, seeks, updates and lookups performed on each index in the past week
    Missing Indexes Identifies tables where there are a large number of table scans or index scans as potentially needing new indexes
    Indexes Not Used Identifies indexes where there are a large number of updates and few seek/scan/lookup operations
    Bookmark Scans Identifies indexes where there are a large number of bookmark scans, suggesting that a clustered index may be misplaced