Monitoring, Alerts & Troubleshooting

How many rows does a reset view contain, and what happens when you create a new reset point?

Which three database client APIs have their own SAP HANA client-side trace facilities?

In DBA Cockpit, what can't you change about SAP HANA alerts, and how do you send alert emails instead?

Why is the M_DATABASES monitoring view an exception, and where must you query it for full results?

Which SAP Note explains how to handle the 'Check for New Crash Dump File' alert?

How are individual SAP HANA alerts identified, and where are they defined?

What is the naming form of a standard SAP HANA trace file?

What naming convention identifies a SAP HANA monitoring view?

How do statistics views preserve monitoring data for longer periods?

How do you deactivate an active SAP HANA alert check via SQL?

What term in a SAP HANA dump file's name identifies it as a crash dump, and what does it contain?

Which parameters control trace file size and retention count, and where are they set, with what defaults?

Where are reset-point values stored for a monitoring view that supports them?

What does the Merge Diagnostic Files function in SAP HANA Studio do?

Which hdbsql option runs a script from SAP's SQL collection, and why also use -m?

What does the severity-level field in a SAP HANA trace message indicate, with its possible values?

What happens to monitoring view data when the SAP HANA instance is stopped?

Where in Transaction DBACOCKPIT can an ABAP administrator browse SAP HANA system views?

Which schema owns the monitoring views, and how can you query them without naming a schema?

Which thread controls the alert process in SAP HANA, and where does it run?

Why can't you change SAP HANA alert check times in SAP HANA Studio?

What does the MDC suffix on a SAP SQL collection script name mean?

In which SAP documentation resource is the full reference for SAP HANA monitoring views (M_ views) found?

What is the passport in SAP HANA end-to-end (E2E) tracing?

What does the SAP HANA kernel profile trace collect, and for whom is it intended?

Which configuration parameter must you set before running SAP HANA mini checks to avoid error 463, and to what value?

By default, what reference point does a SAP HANA monitoring view's data accumulate from?

By default, which alert severities does the SAP HANA cockpit's alert list display?

How does an alert trace file differ from a standard trace file in SAP HANA?

When changing SAP HANA alert thresholds in STATISTICS_ALERT_THRESHOLDS via SQL, which column must you update and which must you avoid?

What information does the ALERT_USERACTION column of an alert provide?

In the SAP HANA cockpit, besides changing thresholds, what else can the Apply to Other Databases button do for an alert definition?

In which configuration section is the SAP HANA kernel sentinel controlled, and which SAP Note documents it?

Which schema holds the statistics views, and why must you always name the schema when using them?

Which configuration view controls the collection frequency and retention period of the statistics server's collectors?

Which two SAP HANA monitoring views let you list trace files and read their contents via SQL?

As which SAP Note attachment is SAP's SQL statement collection delivered, and roughly how many scripts does it contain?

What is a reset point for a monitoring view?

Which two _SYS_STATISTICS views hold SAP HANA alert information, and how do they differ?

What do the values 1 through 5 mean in the ALERT_RATING column of STATISTICS_CURRENT_ALERTS?

Why does running SQLStatements_Internal.zip scripts carry risk, and what privilege do they need?

In which directory are SAP HANA trace files located for the system database?

What is the effect of configuring an email recipient for a specific SAP HANA alert?

Where are the SAP HANA statistics views documented?

What must you configure to send SAP HANA alert emails, and what is the default SMTP port?

What does the SAP HANA SQL trace capture, and what is its main purpose?

Which filename terms identify SAP HANA runtime, emergency, and out-of-memory dump files?

In which table does Transaction DBACOCKPIT store uploaded SQL collection scripts, and how do you mass-delete them?

What does the SAP HANA kernel sentinel do, and when was it introduced?

What can user-specific tracing in SAP HANA set trace levels for, and what was added in version 2.0 SPS 03?

Which SQL statement turns the SAP HANA SQL trace on from the command line?

What is the name form of a SAP HANA alert trace file, and which parameter limits its size?

What is the standard data-retention period for almost all of the SAP HANA statistics collectors?

Which two files in the SAP HANA system database's trace directory must not be deleted, and what does each contain?

In monitoring views with one record per service, which two columns identify the service?

In the SAP HANA cockpit, which diagnostic files can you see in a tenant database versus the system database?

What is the purpose of the SAP HANA mini checks?

What file format does the SAP HANA SQL trace produce by default, and why is that significant?

What is the scope of monitoring-view data — shared across databases or limited to one — and what does that mean when querying a view like M_DATA_VOLUMES?

How do you browse and query SAP HANA system views in the SAP HANA cockpit and SAP HANA Studio?

How do you show the service name instead of the port number in a monitoring-view query?

What does the cdtrace alias do when logged in as the <hsid>adm user?

What is special about the monitoring views in the SYS_DATABASES schema of the system database?

What filename term marks a SAP HANA Inter Process Memory Management (IPMM) crash dump?

What security warning applies to the SAP HANA SQL trace .py file regarding credentials?

Which mini check category is considered the most important, and which SAP Note documents it?

What are the five trace levels available for the SAP HANA SQL trace?

Which SQL statement creates a reset point for the M_VOLUME_IO_TOTAL_STATISTICS_RESET view?

When do you need to install SAP's SQL statement collection on the database server itself?

What risk does the ALL_WITH_RESULTS SQL trace level carry?

What is the role of the SAP HANA database trace?

What are the five groups of SAP HANA mini check scripts?

Which four _SYS_STATISTICS views are used to configure SAP HANA alerts from the command line?

In which configuration section is the SAP HANA SQL trace controlled from the command line?

What are the two independent processes of the SAP HANA statistics service?

In a multitenant SAP HANA system, how must the mini checks be run?

Which SQL statement activates SAP HANA alert ID 77 and sets its check interval to 30 minutes?

Which column of STATISTICS_SCHEDULE do you update to change a statistics collector's retention period, and which to change its frequency?

In SAP HANA mini check output, what does an 'X' in the C (criticality) column mean?

What does a version suffix such as _2.00.040+ on a SAP SQL collection script indicate?

How is the content of a SAP HANA monitoring view produced?