imajaydwivedi/sqlmonitor

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

About Me	Contact Me	ajaydwivedi.com	LinkedIn	YouTube	StackOverflow

sqlmonitor's Issues

Dashboard Exposing Latest Backup History

Is your feature request related to a problem? Please describe.
Sometimes backups are not happening, and we find out very late.

Having a dashboard will help in timely detection of miss backup issues.

Dashboard for AlwaysOn Latency

Create a dashboard for AlwaysOn Latency.

This dashboard should be able to expose latency across time.

Setup Alerting Infra

Design Email & Slack Alerts for following -

• Instance Unavailability
• Database Unvailability
• CPU (High/Critical)
• Blocking
• Memory Grant Pending
• Low SQL Server Ram
• Jobs Alert
• ErrorLog based Alerts
• Login Failures
• Backups not happening
• TempDbSaver based alert
• LogSaver based alert
• Incorrect tempdb config
• Alert for long running transaction

Add Parameters to Skip Particular Wait Type in `usp_waits_per_core_per_minute`

Is your feature request related to a problem? Please describe.
On some of my servers, there are some WaitTypes that always occurring, and overshadowing other relevant wait types.

Describe the solution you'd like
Below 2 options -

1. A parameter to ignore comma separate list of wait types
2. A table that keeps a list of wait types that can be ignored for easy handling. This table should be present on each server.

`Remove-SQLMonitor` - Save InstanceDetails are until the Instance is Removed Full

If Remove-SQLMonitor fails after step 49__DropTable_InstanceDetails, then with current code, its not possible to finish the unistallation as the details of instance are lost.

In order to get around this issue, kindly save the instance_details somewhere at start of installation, and remove same after successfull uninstallation.

Enable `-TrustServerCertificate -EncryptConnection` flag in Invoke-DbaQuery

Is your feature request related to a problem? Please describe.
With latest SMO, connections fails with weird messages.

So need to enable -TrustServerCertificate -EncryptConnection flag in Invoke-DbaQuery

Audit To Trace DDL Changes

Audit To Trace DDL Changes

Capture `sp_Blitz` Result & Create Dashboard

Is your feature request related to a problem? Please describe.
sp_Blitz exposes lots of issues that could be helpful to DBA & Developers.

Describe the solution you'd like
Capture sp_Blitz result at least once a week, and create dashboards exposing various kind of informations from same.

Dashboard exposing Statistics Information

Delta update stats query can be used for this infra - https://ajaydwivedi.com/query/indexoptimize

Also, expose result of DBCC SHOW_STATISTICS

Dashboard - Deadlock Analysis

Dashboard - Deadlock Analysis

Below query can be used for this infra -

declare @_endDate datetime;
set @_startDate = dateadd(hour,-24,getdate());
set @_endDate = GETDATE()

exec sp_BlitzLock @StartDate = @_startDate, @EndDate = @_endDate
				,@OutputDatabaseName = 'tempdb'
go

select *
from tempdb..BlitzLock

Data Distribution of Table Partition

Is your feature request related to a problem? Please describe.
There are times when I need to check data distribution of a partitioned table in order to figure of if the table partitioning is working fine or not.

Query to use - https://github.com/imajaydwivedi/SQLMonitor/blob/dev/Sql-Queries/QRY-Get-Partitions-Record-Count-Metrics.sql

Control Immediate Removal of Perfmon File in Job `(dba) CollectPerfmonData`

Is your feature request related to a problem? Please describe.
I was to analyze the generated perfmon blg files on my server. So don't want to remove them immediately.

Describe the solution you'd like
A parameter in script SQLMonitor\perfmon-collector-push-to-sqlserver.ps1 to decide if immediately remove a file or not.

Infra to Track Server and Database Configuration Changes

Need to capture any server-level changes like max memory, ad hoc distributed queries, clr enabled, database mail, remote access, xp_cmdshell.

Some reference blogs -

• Capturing and Alerting on SQL Server Configuration Changes
• Spotting Unauthorized Configuration Settings in SQL Server

Self-Sign PowerShell Scripts

In highly secured environment, only remote-signed powershell scripts are allowed.

Self-signing SQLMonitor powershell scripts will help in smooth deployments.

Add Latency Trend Over Time on `t__Database File IO Stats`

Add Latency Trend Over Time on t__Database File IO Stats

Job `(dba) Collect-DiskSpace` failing

Describe the bug
Job (dba) Collect-DiskSpace failing with below error message after upgrade of dbatools to latest release.

2023Nov22_1832 INFO:      Fetch disk space on $HostName = [21L-LTPABL-1187]..
2023Nov22_1832 INFO:      Push disk info to SqlServer [21L-LTPABL-1187].[DBA].[dbo].[disk_space]..
The certificate chain was issued by an authority that is not trusted
At line:97904 char:9
+         throw $records[0]
+         ~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ConnectionError: (21L-LTPABL-1187:String) [], Exception
    + FullyQualifiedErrorId : dbatools_Write-DbaDbTableData

Daily Mailer for `All Server Health` Dashboard

Folks are requesting for a daily mail representing the same data as on the dashboard Monitoring - Live - All Servers.