We have several mssql databases but no DBA. One of our network guys has set up some alerts and has asked me what would be the best vlalues to use. Is the a rule of thumb to go by? . The alerts are:
check_wmi_mssql _buffer_cache_h its
check_wmi_mssql _buffer_deadloc ks
check_wmi_mssql _fullscans
check_wmi_mssql _lockwaits
check_wmi_mssql _lock_wait_time
check_wmi_mssql _log_growths
check_wmi_mssql _log_used
check_wmi_mssql _memory_grants_ pending
check_wmi_mssql _transactions
check_wmi_mssql _users
check_wmi_mssql _buffer_cache_h its
check_wmi_mssql _buffer_deadloc ks
check_wmi_mssql _fullscans
check_wmi_mssql _lockwaits
check_wmi_mssql _lock_wait_time
check_wmi_mssql _log_growths
check_wmi_mssql _log_used
check_wmi_mssql _memory_grants_ pending
check_wmi_mssql _transactions
check_wmi_mssql _users