Add additional verification step for Instance-Availability

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.

MIT License

25 stars 14 forks source link

Add additional verification step for Instance-Availability #29

Closed imajaydwivedi closed 8 months ago

imajaydwivedi commented 8 months ago

Is your feature request related to a problem? Please describe. Sometimes job (dba) Check-InstanceAvailability may fail due to various reasons like file reuse, temporary glitch, etc Due to this, the job sets a server OFFLINE

Describe the solution you'd like Add additional verification using tsql method to reset the OFFLINE flag for offline servers.

imajaydwivedi commented 8 months ago

Procedure DDLs\SCH-usp_check_instance_availability.sql has been created. Also added to auto compile as part of Install-SQLMonitor.ps1.

But, the procedure dbo.usp_check_instance_availability has not been added in any of the existing jobs. Execution of this procedure should be DBAs exclusive decision, and can be added as 2nd step in job (dba) Check-InstanceAvailability