SQLMonitor
SQLMonitor copied to clipboard
imajaydwivedi
This repository contains scripts needed to setup SQL Server baselining and visualizing using Grafana
There are scenarios where we need to check historical metrics to figure out max/min/average/pencentile etc for a metrics within x days. For example, get max memory utilization for last 7...
Due to restrict oranizational security policies, login password should change very 90 days. Due to this, password for `grafana` login should be rotated every 90 days. Need to build the...
Design Email & Slack Alerts for following - - [ ] Instance Unavailability - [ ] Database Unvailability - [ ] CPU (High/Critical) - [ ] Blocking - [ ]...
Design Email & Slack Alerts for following - - [ ] Instance Unavailability - [ ] Database Unvailability - [ ] CPU (High/Critical) - [ ] Blocking - [ ]...
Create following alerts using Python & Slack - - [ ] CPU - [ ] Blocking - [ ] Memory Grants Pending - [ ] Waits Per Core Per Minute...
Create a dashboard Exposing Error Messages from ErrorLogs of all the servers. Idea is to proactively identify issues by reading error logs, and generate alerts if possible.
**Is your feature request related to a problem? Please describe.** There are times when we can not do anything to one issue appearing on dashboard. For example, if a database...
Show counts of issues in each panel on All Server Dashboard similar to below - 
Add Latency Trend Over Time on `t__Database File IO Stats`
Metadata
Owner
Metadata
This repository contains scripts needed to setup SQL Server baselining and visualizing using Grafana