Скачать или смотреть 05 - SQLMonitor - Dashboard - Analyze Query Workload

SQLMonitor is open source tool designed by Ajay Dwivedi.
Available on https://ajaydwivedi.com/github/sqlmon...

SQLMonitor is designed as open-source tool to replace expensive enterprise monitoring or to simply fill the gap and monitor all environments such as DEV, TEST, QA/UAT & PROD.

In this video, we take a look at our 5th dashboard that helps us find out the active requests/queries runing on our server. This dashboard provides live query/session requests information for troubleshooting purpose.

Features
-----------------
-- Highly customizable granularity to capture important spikes in server workload.
-- Grafana for real-time dashboarding
-- Minimal performance impact (around 1% on a single core SQL Instance)
-- Out of the box collection with minimal configuration required to get it up and running
-- Zero maintenance. It has been designed to maintain itself.
-- Unlimited scalability. As each instance monitors itself, we are not constraint by the capacity of the monitoring server.
-- Works with all supported SQL Servers (with some limitations on 2008R2).