SQL Server Performance Monitoring framework
Free and Open Source, developed by SQL Server DBAs.
Because every environemnt is a production environemnt for someone.
DemoGet started
Quick installation using dbatools:
Install-DbaSqlWatch -SqlInstance YourSqlServer
Performance Dashboard Demo
Check out a working demo of the Power BI Dashbaord. This example runs in the Power BI Servie and it will look and work exactly the same in the free Power BI Desktop. Best experienced in Full Screen.
Features
Flexible with Zero maintenance
SQLWATCH was built to help you monitor all your enviroments, not to become another thing to worry about. It has been designed with set and fortget approach.
Written in T-SQL, no additional hardware or VM provisioning required. You can tweak and adjust as you wish.
Schema optimised for long term storage means minimal growth and ability to compare months or even years of performance statistics.
Provides insight into index usage, missing indexes, database growth and disk utilisation.
Default installation will collect most critical metrics and if this is not good enough it is super easy to enable new metrics or even add your own.
Decentralised monitoring
No complex infrastructure provisioning required.
No additional monitoring services or central servers to worry about, no additional VMs to be provisioned, no agents to install.
Optional central repository database for central reporting.
Each server monitors itself. SQLWATCH uses SQL Agent jobs for data collection which is then stored locally and not affected by network blips. This approach allows it to work in isolated networks yet it still allows for central reporting but with the benefit of distributed storage and monitoring.
Perfect for consultants that do not have 24/7 access to the client network. You can collect data from remote instances into central repository every few minutes or every few days. It's up to you.
Alerts, Reports and Integrations
Fully customisable and flexible alerting engine with actions executed via PowerShell allows almost unlimited integrations including HTTP calls, launching programs and executing T-SQL queries.
Text based alerts delivered via email, Pushover, Slack or any other service that accepts HTTP calls.
More sophisticated notifications using html reports.
Saving files to shared drives or creating "trigger" files to integrate with other systems.
Pushing data to monitoring platforms such as Zabbix and Nagios and log collectors such as GrayLog and Splunk
How it works
1. Collect
Collects pre-defined, high-granularity performance metrics.
2. Store
Stores collected data in a local schema optimised for performance.
3. Check
Check engine ensures all metrics are within the thresholds.
4. Action
Raises alerts or triggers actions for failed checks and metrics that breach the set thresholds.
5. Analyse & Report
Analayse Performance data using provided PowerBI Dashboard or get emails with schedueld reports.
6. Archive
Aggregates high granularity data and archives for long term storage and long term analysis.
This site, like most websites, uses cookies. By continuing to use this website, you agree to their use.