search

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 Parameters to Skip Particular Wait Type in `usp_waits_per_core_per_minute` #21

Closed imajaydwivedi closed 10 months ago

imajaydwivedi commented 10 months ago

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.
imajaydwivedi commented 10 months ago

Added columns IgnorableOnPerCoreMetric and IgnorableOnDashboard on table [dbo].[BlitzFirst_WaitStats_Categories].