SQL Server Tools

Our repository of SQL Server scripts used in our own client engagements are available to the community on GitHub.

These tools are openly shared to support accidental and intentional DBAs in diagnosing issues, improving reliability, and gaining operational visibility into in their SQL Server environments.

The sp_Monitor Toolkit

free SQL Server Monitoring scripts

Our team began developing the sp_Monitor Toolkit collection to provide free practical monitoring scripts that help keep your SQL Servers reliable and performant, and fill gaps in monitoring. We use them in our own clients environments and wanted to share them with the community too.

Our team began developing the sp_Monitor Toolkit collection to provide free practical monitoring scripts that help keep your SQL Servers reliable and performant, and fill gaps in monitoring.
We use them in our own clients environments and wanted to share them with the community too. Each script identifies and alerts on issues, some even have optional parameters to automatically resolve problems as they happen.

Development Updates & Releases

sp_Monitor Roadmap

In Development

sp_MonitorQueryStore

Monitor Query Store with the ability to generate alerts,

automatically resolve issues, identify parameter sniffing and provide recommendations on Query Store related settings.

Monitor Query Store with the ability to generate alerts, automatically resolve issues, identify parameter sniffing and provide recommendations on Query Store related settings.

sp_MonitorSysadmin

Audit and alert on membership changes to the sysadmin role

sp_MonitorTempDB

Audit and alert on membership changes to the sysadmin role

Researching

sp_MonitorAvailabilityGroup

Alert on and provide recommendations on various aspects of SQL Server Availability Groups

sp_MonitorDiskSpace

Monitor and alert on available disk space with customizable thresholds and alert actions

PLANNED

sp_MonitorFailedQueries

sp_MonitorLoginFailures

sp_MonitorPermissions

Have an idea for a script or improvement? Reach out and let us know — we’re always looking for ways to make the toolkit even better.