Skip to end of metadata
Go to start of metadata

Purpose

This purpose for this page is help with specify what situations the SQL queries from SAP Note 1969700 - SQL statement collection for SAP HANA can be used to help troubleshoot an issue.

High CPU

HANA_Workload

HANA_Resources_CPUAndMemory_History

HANA_Tables_ColumnStore_Unloads

HANA_Tables_ColumnStore_Merges

HANA_Tables_ColumnStore_DeltaStorage

 

High Memory usage

HANA_MEMORY_TopConsumers

HANA_Memory_TopConsumers_History

HANA_Indexes_LargestIndexes

HANA_Resources_CPUAndMemory_History

HANA_Memory_Overview_Rev60+

HANA_Heap_TranslationTables_Internal_Rev70+

HANA_Heap_MemoryObjects

HANA_Tables_ColumnStore_DeltaStorage

HANA_Tables_TopGrowingTables_Size_History

HANA_Tables_LargestTables

HANA_RowStore_Overview

 

SQL performance

HANA_SQL_ExpensiveStatements

HANA_SQL_StatementHash_KeyFigures

HANA_SQL_SQLCache

HANA_SQL_SQLCache_Overview_Rev70+

HANA_SQL_StatementHash_BindValues_Rev80+

HANA_SQL_StatementHash_SQLText

HANA_SQL_StatementHash_SQLCache_History

HANA_SQL_SQLCache_Overview

 

Partition

HANA_Tables_Partitions

 

Alerts

HANA_Histories_RetentionTime

HANA_Alerts_Definition

HANA_Alerts_Definition_Rev74+_ESS.txt

HANA_Alerts_Reported

Hardware

HANA_Hosts_Disks

HANA_IO_KeyFigures_Total_History

HANA_Network_Services

HANA_IO_KeyFigures_Details

HANA_IO_KeyFigures_Details_History

HANA_IO_KeyFigures_Total

HANA_IO_Savepoints_Rev71+

HANA_Disks_Fragmentation

HANA_Network_Clients

HANA_Hosts_Network

HANA_Hosts_Overview

 

 

Backup

HANA_Log_LogSegments

HANA_Log_LogBuffers

HANA_Backups_BackupRuns

HANA_Backups_CatalogSize

HANA_IO_Snapshots

 

Locks

HANA_Locks_Transactional_LockWaits_Current

HANA_Locks_Transactional_LockWaits_History

HANA_Locks_Transactional_Total

HANA_Locks_Transactional_Current

HANA_Locks_Internal_LockWaits_Overview

 

Security

HANA_Security_GrantedRolesAndPrivileges

HANA_Security_Roles

 

License

HANA_License_LicenseUsage

HANA_License_Overview

 

BW

HANA_Tables_InconsistentDSOTables

HANA_Tables_InconsistentFactTables

HANA_Tables_InconsistentDSOTables_Fallback

Development

HANA_Views_Definition

HANA_Repository_Objects_Versions

HANA_Objects_ObjectDependencies

HANA_Threads_CurrentCallingCallerDependencies_Rev70+.txt

HANA_Consistency_ColumnStore_DuplicateKeys_CommandGenerator

 

 

About HANA system

HANA_Services

HANA_Configuration_Parameters

HANA_TraceFiles_Content.

HANA_Startup_StartupTime

HANA_Configuration_MiniChecks_Rev70+

HANA_Configuration_Overview

HANA_Startup_StartupAndRecoveryTimes_Internal

HANA_TraceFiles_Overview

HANA_InitializationFiles

HANA_Limits

HANA_Configuration_PatchLevel

HANA_Features

 

MISC

HANA_SQL_ExplainPlan

HANA_ErrorCodes

HANA_Table_ColumnStore_Columns

HANA_Consistency_LOBContainers_CommandGenerator

HANA_Replication_ParameterDeviations

HANA_Sessions

HANA_LandscapeReorg_Details

HANA_Tables_ColumnStore_TableHostMapping

HANA_Tables_ColumnStore_TableHostMapping_Fallback

HANA_Threads_ThreadSamples_FilterAndAggregation_Rev74+_ESS

HANA_Threads_ThreadSamples_FilterAndAggregation_Rev70+

HANA_Threads_CurrentThreads_Rev70+

HANA_Tables_ColumnStore_TablesMovedLogically_Rev72+.txt

Output param doesn’t match the example

Displays tables that were moved logically

 

HANA_Tables_ColumnStore_TableSize_History

HANA_Tables_ColumnStore_Records

HANA_Sequences_Overview

HANA_Threads_ThreadSamples_AggregationPerTimeSlice_Rev70+

HANA_Tables_TableClasses 

HANA_Tables_RowStore_TableSize_History

HANA_Tables_ColumnStore_Overview

HANA_Jobs_Executors

HANA_GarbageCollection_ColumnStore_Overview

HANA_Configuration_HybridLOBActivation_CommandGenerator

HANA_Tables_QCMTables

HANA_Indexes_Columns

HANA_Tables_Columns

HANA_Data_ColumnValueSearch_CommandGenerator

HANA_Data_ColumnValueCounter_CommandGenerator

HANA_Tables_TopGrowingTables_Records_History

HANA_Replication_Overview

HANA_Configuration_Schemas

HANA_Security_Users_Rev72+

HANA_Tables_RowStore_Versions

HANA_Connections_Statistics

 

Related Documents:

 

Related Videos:

 

Related SAP Notes/KBAs

 SAP Note 1969700 - SQL statement collection for SAP HANA

 

 

 

 

 

 

 

 

 

  • No labels