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.
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.
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.
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
Collects pre-defined, high-granularity performance metrics.
Stores collected data in a local schema optimised for performance.
Check engine ensures all metrics are within the thresholds.
Raises alerts or triggers actions for failed checks and metrics that breach the set thresholds.
Analayse Performance data using provided PowerBI Dashboard or get emails with schedueld reports.
Aggregates high granularity data and archives for long term storage and long term analysis.
The aim of this this project is to provide a free, repository backed, SQL Server Monitoring for everyone. Using Power BI Q&A capabilities, we want to change the way performance monitoring is done and given an actual advice rather than just cold raw numbers. SQL Server is very popular and used by a lot of companies and people but not every one can afford expensive, enterprise monitoring solution. We are here to fill this gap!
Constantly growing volumes mean that it is more critical than ever to be able to performance baseline your environemnts, all of them, not just production. Repository backed monitoring gives you the benefit of being able to review historical behaviour.