SQLBench Overview

SQLBench is an easy to use monitoring and alerting service for Microsoft SQL Server

Monitor your on prem, VM, IaaS or AWS RDS SQL Server systems from a single web based portal which can be accessed by your DBAs, Database Developers, Software Vendors or Infrastructure partners.

Analyse performance bottlenecks, monitor usage of resources such as CPU, Memory & Disk, configure SMTP & mobile alerts securely away from your production database servers.

Platform

SQLBench is a cloud based, global platform with connection end points in many locations around the world.

Our agent-less monitoring software collects SQL Server telemetry centrally from a dedicated host (or VM) within your network before sending it to our cloud based anlaytics, alerting and dashboarding services.

The SQLBench Portal allows you to view and analyse telemetry, or you can access the telemetry data via our API.

Data Collected

The SQLBench agent connects to each instance, continously collecting the following performance and configuration data:

  • Expensive queries (via SQLTrace or Extended Event APIs)

  • Windows O/S Perfmon counters (via Windows Perfmon API)

  • SQL Server Perfmon counters (via SQL Server DMVs)

  • SQL Server Wait Statistics (via SQL Server DMVs)

  • SQL Server Memory Clerks (via SQL Server DMVs)

  • SQL Server Database Virtual File Statistics (via SQL Server DMVs)

  • Exceptions (via SQLTrace or Extended Event APIs)

  • SQL Agent Job execution statistics (via SQL Server DMVs)

  • Server configurations, Database properties, Table & Index structure definitions, Partitions, Files, Filegroups & Views

SQLBench is unable to query database tables when configured using our recommended minimum permissions.

Portal

SQLBench's web based portal allows you to view telemetry, analyse problems or check in on operations from anywhere.

Role based permissions allow access to be shared appropriately with members of your team including DBAs, Database Developers, Software Vendors or IT Ops & IT Sec partners.

API

The SQLBench API provides direct access to telemetry data via our global edge network.

A dashboarding tool is also provided which can be used as a dashboard or as an API expression builder.

Agent

The SQLBench agent requires zero installation on monitored SQL Server systems

It can be installed centrally in your network, monitoring many SQL Server systems from a single location

© 2022 Copyright Terms Privacy