Baseline SQLServer with SQLMonitor v1.6.0
|I have been using SQLMonitor extensively for monitoring & performance tuning of my SQLServers. To make it more and more useful, I have added more functionalities to the tool in version v1.6.0.
Below are some enhancements made in release v1.6.0 –
- Added AG Latency dashboard
- Added features like Save State, PreQuery, and PostQuery in Remove-SQLMonitor
- Added parameters like XEventDirectory, JobsExecutionWaitTimeoutMinutes, UpdateSQLAgentJobsThreshold, etc in Install-SQLMonitor
- Added sp_Blitz infra & dashboards
- Renamed resource_consumption infra to xevent_metrics infra
- Added more panels in the Job Activity Monitor dashboard
- Removed any usage of TrustWorthy database attribute dependency
- Added parameters for All Servers Dashboards to provide more controls on thresholds
Some common help URLs –
- Github -> https://ajaydwivedi.com/github/sqlmonitor
- Demo site -> https://ajaydwivedi.com/demo/sqlmonitor
- Credentials for Demo site -> https://ajaydwivedi.com/go/sqlmonitor
- YouTube Playlist -> https://ajaydwivedi.com/youtube/sqlmonitor
- Blogs on Troubleshooting Performance Issues using SQLMonitor -> https://ajaydwivedi.com/category/sqlmonitor
- Community Help using #sqlmonitor channel on SQL Community Workspace -> https://ajaydwivedi.com/go/slack
The below video provides an overview of dashboards in the current version –
The below video provides a demo of how to remove & install SQLMonitor on Inventory & another SQLInstance-
I hope this will help SQL Server users looking to baseline their SQLServers using SQLMonitor.
One Comment