Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
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
Page: HANA_Alerts_Definition Page: HANA_Alerts_Definition_Rev74+_ESS Page: HANA_Alerts_Reported Page: HANA_Configuration_HybridLOBActivation_CommandGenerator Page: HANA_Configuration_MiniChecks_Rev70+ Page: HANA_Configuration_Overview Page: HANA_Configuration_Parameters Page: HANA_Configuration_PatchLevel Page: HANA_Configuration_Schemas Page: HANA_Connections_Statistics Page: HANA_Consistency_ColumnStore_DuplicateKeys_CommandGenerator Page: HANA_Consistency_LOBContainers_CommandGenerator Page: HANA_Data_ColumnValueCounter_CommandGenerator Page: HANA_Data_ColumnValueSearch_CommandGenerator Page: HANA_Disks_Fragmentation Page: HANA_ErrorCodes Page: HANA_Features Page: HANA_GarbageCollection_ColumnStore_Overview Page: HANA_Hosts_Disks Page: HANA_Hosts_Network Page: HANA_Hosts_Overview Page: HANA_Indexes_Columns Page: HANA_Indexes_LargestIndexes Page: HANA_InitializationFiles Page: HANA_Jobs_Executors Page: HANA_LandscapeReorg_Details Page: HANA_Limits Page: HANA_Memory_TopConsumers_History Page: HANA_Network_Clients Page: HANA_Network_Services Page: HANA_Objects_ObjectDependencies Page: HANA_Replication_Overview Page: HANA_Replication_ParameterDeviations Page: HANA_Repository_Objects_Versions Page: HANA_Security_Roles Page: HANA_Security_Users_Rev72+ Page: HANA_Sequences_Overview Page: HANA_Services Page: HANA_Sessions Page: HANA_SQL_ExplainPlan Page: HANA_SQL_StatementHash_KeyFigures Page: HANA_Startup_StartupAndRecoveryTimes_Internal Page: HANA_Startup_StartupTime Page: HANA_Table_ColumnStore_Columns Page: HANA_Tables_Columns Page: HANA_Tables_ColumnStore_Overview Page: HANA_Tables_ColumnStore_Records Page: HANA_Tables_ColumnStore_TableHostMapping Page: HANA_Tables_ColumnStore_TableHostMapping_Fallback Page: HANA_Tables_ColumnStore_TableSize_History Page: HANA_Tables_InconsistentDSOTables Page: HANA_Tables_InconsistentDSOTables_Fallback Page: HANA_Tables_InconsistentFactTables Page: HANA_Tables_Partitions Page: HANA_Tables_QCMTables Page: HANA_Tables_RowStore_TableSize_History Page: HANA_Tables_RowStore_Versions Page: HANA_Tables_TableClasses Page: HANA_Tables_TopGrowingTables_Records_History Page: HANA_Threads_CurrentCallingCallerDependencies_Rev70+.txt Page: HANA_Threads_CurrentThreads_Rev70+ Page: HANA_Threads_ThreadSamples_AggregationPerTimeSlice_Rev70+ Page: HANA_Threads_ThreadSamples_FilterAndAggregation_Rev70+ Page: HANA_Threads_ThreadSamples_FilterAndAggregation_Rev74+_ESS Page: HANA_TraceFiles_Content Page: HANA_TraceFiles_Overview Page: HANA_Views_Definition Page: HANA Backup Runs Page: HANA Backups Catalog Size Page: HANA Heap Memory Objects Page: HANA Heap Translation Tables Internal Rev70+ Page: HANA Histories Retention Time Page: HANA IO Snapshots Page: HANA License Overview Page: HANA License Usage Page: HANA Locks Internal Lock Waits Overview Page: HANA Locks Transactional Current Page: HANA Locks Transactional Lock Waits Current Page: HANA Locks Transactional Lock Waits History Page: HANA Locks Transactional Total Page: HANA Log Buffers Page: HANA Log Segments Page: HANA Memory Overview Rev60+ Page: HANA MEMORY Top Consumers Page: HANA Resources CPU And Memory History Page: HANA Row Store Overview Page: HANA Security Granted Roles And Privileges Page: HANA SQL Cache Page: HANA SQL Cache Overview Page: HANA SQL Cache Overview Rev70+ Page: HANA SQL Expensive Statements Page: HANA SQL Expensive Statements Bind Values Rev60 Page: HANA SQL Statement Hash Bind Values Rev80+ Page: HANA SQL Statement Hash SQL Cache History Page: HANA SQL Statement Hash SQL Text Page: HANA Tables Column Store Delta Storage Page: HANA Tables Column Store Merges Page: HANA Tables Column Store Unloads Page: HANA Tables Largest Tables Page: HANA Tables Top Growing Tables Size History Page: HANA Workload