Why does the Alert Details table in the ERRORLOG Alerts workspace show only some error messages?
The Alert Detail table is parsing the SQL server instance ERRORLOG file. Only the messages having severity greater than "17" will be shown by default.
In order to view also the messages having other severities, you need to add a new COLL_ALERT_SEV environment variable.
Eg. If you set the above environment variable value to "15", then the error messages having a severity greater than "15" will be displayed on the portal.
Below the steps to add the environment variable:
Go to MTEMS (Manage Tivoli Enterprise Monitoring Services) window > right click on the 'Monitoring agent for Microsoft SQL server" instance name > Advanced > Edit Variables > Add.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.