SELECT
/*
[NAME]
- HANA_Configuration_MiniChecks_1.00.120+
[DESCRIPTION]
- General SAP HANA checks
[SOURCE]
- SAP Note 1969700
[DETAILS AND RESTRICTIONS]
- Checks below "Available as of revisions <rev>" are not possible with earlier revisions
- Some checks related to extended statistics server are not possible with standalone statistics server
- Long runtimes might be linked to TABLES_MOVED_LOCALLY check
- NO_SUBPLAN_SHARING hint required to avoid terminations with "339: invalid number: not a valid number string 'yes' at function __typecast__()" (bug 124947)
- The following checks are deprecated and no longer considered:
( SELECT 230, 'MEMORY_USED_CURRENT', 'Current memory utilization (%)', '1999997', '<=', '90', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 231, 'MEMORY_USED_HISTORY', 'Time since memory utilization > 95 % (h)', '1999997', '>=', '12.00', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 240, 'SWAP_SPACE_USED_CURRENT', 'Current swap utilization (GB)', '1999997', '=', '0', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 241, 'SWAP_SPACE_USED_HISTORY', 'Time since swap utilization > 1 GB (h)', '1999997', '>=', '480', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 310, 'MIN_IO_READ_THROUGHPUT_DATA', 'I/O read throughput data min. (MB/s, last day)', '1999930', '>=', '20', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 311, 'AVG_IO_READ_THROUGHPUT_DATA', 'I/O read throughput data avg. (MB/s, last day)', '1999930', '>=', '100', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 320, 'MIN_IO_READ_THROUGHPUT_LOG', 'I/O read throughput log min. (MB/s, last day)', '1999930', '>=', '30', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 321, 'AVG_IO_READ_THROUGHPUT_LOG', 'I/O read throughput log avg. (MB/s, last day)', '1999930', '>=', '100', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 325, 'MIN_IO_WRITE_THROUGHPUT_LOG', 'I/O write throughput log min. (MB/s, last day)', '1999930', '>=', '10', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 326, 'AVG_IO_WRITE_THROUGHPUT_LOG', 'I/O write throughput log avg. (MB/s, last day)', '1999930', '>=', '20', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 328, 'AVG_4K_WRITE_DURATION_LOG', '4 KB write duration log avg. (ms)', '1999930', '<=', '10.00', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 350, 'HIGH_CRIT_SAVEPOINT_PHASE', 'Blocking savepoint phases > 10 s (last day)', '2100009', '=', '0', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 352, 'MAX_CRIT_SAVEPOINT_PHASE', 'Blocking savepoint phase max. (s, last day)', '2100009', '<=', '10.00', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 365, 'WRONG_IO_PARAMETER_SETTINGS', 'Wrong SAP HANA I/O parameter settings', '1999930', '=', 'no', 122.04, -1 FROM DUMMY ) UNION ALL
( SELECT 453, 'CONCAT_ATTRIBUTES_SIZE', 'Size of non-unique concat attributes (GB)', '1986747', '<=', '30.00', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 1330, 'USER_EXPIRATION', 'Number of users with expiration date', '', '=', '0', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 1335, 'SAP_USER_PASSWORD_EXPIRATION', 'Number of SAP users with password expiration', '1702224', '=', '0', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 1850, 'SR_LOGREPLAY', 'System replication op. mode logreplay used', '1999880', '=', 'yes', 110, -1 FROM DUMMY ) UNION ALL
( SELECT 1930, 'SYNONYM_TABLE_NAMES', 'Synonyms with names identical to table name', '', '=', '0', -1, -1 FROM DUMMY ) UNION ALL
( SELECT 2112, 'LAST_STATSERVER_CTC_RUN', 'Last consistency check via stat. server (days)', '2116157', '<=', '32', -1, -1 FROM DUMMY ) UNION ALL
[VALID FOR]
- Revisions: >= 1.00.120
[SQL COMMAND VERSION]
- 2014/04/13: 1.0 (initial version)
- 2014/05/09: 1.1 (grouping of checks)
- 2014/11/14: 1.2 (dedicated command for ESS)
- 2015/01/29: 1.3 (dedicated command for ESS and Rev. 90 and higher)
- 2015/11/12: 1.4 (dedicated command for Rev. 100 and higher)
- 2016/01/19: 1.5 (dedicated command for Rev. 102.01 and higher)
- 2016/10/28: 1.6 (dedicated command for Rev. 1.00.120 and higher)
- 2017/06/22: 1.7 (CHECK_ID and CHECK_GROUP filtering included)
[INVOLVED TABLES]
- various
[INPUT PARAMETERS]
- HOST
Host name
'saphana01' --> Specic host saphana01
'saphana%' --> All hosts starting with saphana
'%' --> All hosts
- ONLY_POTENTIALLY_CRITICAL_RESULTS
Possibility to restrict the output to potentially critical issues
'X' --> Output only contains issues that can potentially indicate a problem
' ' --> no output restriction
- MAX_VALUE_LENGTH
Maximum length of VALUE output column
48 --> Maximum length of 48 characters
-1 --> no length limitation
- CHECK_ID
Possibility to restrict the output to a specific check ID
250 --> Restrict output to check ID 250
-1 --> No restriction to a particular check ID
- CHECK_GROUP
Possibility to restrict output to a specific check group (i.e. checks below a check group heading)
'DISKS' --> Perform checks for check group DISKS
'%' --> No restriction related to check groups
- ORDER_BY
Sort criteria (available values are provided in comment)
'HOST' --> Sorting by host name
'CHECK' --> Sorting by check identifier (CHID column)
[OUTPUT PARAMETERS]
- CHID: Check identifier (defined and used by this Mini Check command)
- DESCRIPTION: Check description
- HOST: Host name (empty if not host specific)
- VALUE: Check value found on the system
- EXPECTED_VALUE: Expected check values
- C: 'X' if value found on the system is outside of the expected values (indication for potentially critical problem)
- SAP_NOTE: Related SAP Note
[EXAMPLE OUTPUT]
------------------------------------------------------------------------------------------------------------------------------------------------------
|CHID |DESCRIPTION |HOST |VALUE |EXPECTED_VALUE |C|DETAILS |
------------------------------------------------------------------------------------------------------------------------------------------------------
|**** |GENERAL | | | | | |
| | | | | | | |
| 10|Analysis date | |2014/05/30 12:27:35 | | | |
| 11|Database name | |HP1 | | | |
| 12|Revision level | |1.00.74.00.390550 (NewDB100_REL) | | | |
| 110|Everything started | |yes |yes | | |
| 111|Startup time variation (s) | |1108 |<= 600 |X| |
没有合适的资源?快使用搜索试试~ 我知道了~
SAP HANA SQL
共390个文件
txt:390个
需积分: 50 17 下载量 171 浏览量
2018-12-11
16:41:06
上传
评论 3
收藏 1.23MB RAR 举报
温馨提示
SAP HANA SQL scripts,包含各种资源查看SQL,performance SQL等
资源推荐
资源详情
资源评论
收起资源包目录
SAP HANA SQL (390个子文件)
HANA_Configuration_MiniChecks_1.00.120+.txt 234KB
HANA_Configuration_MiniChecks_2.00.010+.txt 234KB
HANA_Configuration_MiniChecks_2.00+.txt 232KB
HANA_Configuration_Parameters_1.00.70+.txt 228KB
HANA_Configuration_MiniChecks_1.00.102.01+.txt 227KB
HANA_Configuration_MiniChecks_1.00.90+_ESS.txt 183KB
HANA_Configuration_MiniChecks_1.00.74+_ESS.txt 171KB
HANA_Configuration_MiniChecks_1.00.70+_SSS.txt 167KB
HANA_Configuration_MiniChecks_SSS.txt 147KB
HANA_Global_DiffReport_1.00.110+.txt 102KB
HANA_SQL_StatementHash_DataCollector_1.00.120+.txt 96KB
HANA_Global_DiffReport.txt 83KB
HANA_Global_TimeFrameReport_1.00.120+.txt 82KB
HANA_Multitenant_Overview_2.00.000+_MDC.txt 81KB
HANA_Multitenant_Overview_1.00.100+_MDC.txt 80KB
HANA_Multitenant_Overview_1.00.90+_MDC.txt 79KB
HANA_Configuration_Parameters_1.00.69-.txt 78KB
HANA_Security_MiniChecks.txt 43KB
HANA_SQL_SQLCache_1.00.120+.txt 42KB
HANA_SQL_SQLCache_1.00.102.01+.txt 38KB
HANA_TraceFiles_Content.txt 37KB
HANA_Configuration_Infrastructure_1.00.90+.txt 36KB
HANA_Configuration_Infrastructure_2.00.010+.txt 36KB
HANA_Memory_TopConsumers_History_1.00.90+_ESS.txt 36KB
HANA_SQL_SQLCache_1.00.120+_Fallback.txt 33KB
HANA_Configuration_Overview_2.00.020+.txt 33KB
HANA_Configuration_Overview_1.00.122.03+.txt 32KB
HANA_Memory_TopConsumers_History_1.00.90+_ESS_MDC.txt 32KB
HANA_Threads_ThreadSamples_FilterAndAggregation_1.00.122.08+.txt 32KB
HANA_Memory_TopConsumers_History_Vertical_1.00.90+_ESS.txt 31KB
HANA_Threads_ThreadSamples_FilterAndAggregation_1.00.120+.txt 31KB
HANA_Memory_TopConsumers_1.00.60+.txt 30KB
HANA_Configuration_Overview_1.00.110+.txt 30KB
HANA_SQL_SQLCache_TopLists_1.00.120+.txt 30KB
HANA_Threads_Callstacks_1.00.100+.txt 30KB
HANA_SQL_SQLCache_1.00.102.01+_Fallback.txt 30KB
HANA_Memory_TopConsumers_History.txt 29KB
HANA_Threads_ThreadSamples_FilterAndAggregation_1.00.100+.txt 29KB
HANA_Configuration_Overview_1.00.100+.txt 28KB
HANA_Data_DuplicateRecords_CommandGenerator_1.00.72+.txt 28KB
HANA_Memory_TopConsumers_History_Vertical_1.00.90+_ESS_MDC.txt 26KB
HANA_Configuration_Overview.txt 25KB
HANA_Threads_ThreadSamples_FilterAndAggregation_1.00.80+_ESS.txt 25KB
HANA_Threads_Callstacks.txt 24KB
HANA_SQL_SQLCache.txt 24KB
HANA_Threads_ThreadSamples_StatisticalRecords_1.00.120+.txt 24KB
HANA_SQL_StatementHash_KeyFigures_1.00.102.01+.txt 24KB
HANA_Tables_ColumnStore_Columns.txt 24KB
HANA_Threads_ThreadSamples_FilterAndAggregation_1.00.70+.txt 23KB
HANA_Threads_ThreadSamples_AggregationPerTimeSlice_1.00.80+_ESS.txt 23KB
HANA_Threads_Callstacks_Vertical_1.00.100+.txt 23KB
HANA_Locks_Transactional_LockWaits_1.00.100+.txt 23KB
HANA_Memory_Overview_1.00.90+.txt 23KB
HANA_StatisticsServer_Histories_RetentionTime_1.00.120+.txt 23KB
HANA_SQL_SQLCache_1.00.74-1.00.89_ESS.txt 23KB
HANA_SQL_ExpensiveStatements_1.00.60+.txt 23KB
HANA_Global_CriticalTimeFrames_1.00.102.05+.txt 22KB
HANA_Tables_LargestTables_1.00.120+.txt 22KB
HANA_Threads_ThreadSamples_StatisticalRecords_1.00.80+_ESS.txt 22KB
HANA_StatisticsServer_Histories_RetentionTime_1.00.100+.txt 22KB
HANA_Tables_LargestTables.txt 22KB
HANA_SQL_StatementHash_KeyFigures.txt 22KB
HANA_Memory_Overview_1.00.70+.txt 21KB
HANA_Data_Clients_CommandGenerator.txt 21KB
HANA_SQL_SQLCache_DiffReport.txt 21KB
HANA_GarbageCollection_Overview_1.00.80+.txt 21KB
HANA_Objects_ObjectDependencies_Hierarchy.txt 21KB
HANA_Tables_ColumnStore_TableHostMapping.txt 21KB
HANA_SQL_StatementHash_KeyFigures_1.00.120+.txt 21KB
HANA_Traces_ActivatedAndModifiedTraces_1.00.70+.txt 20KB
HANA_StatisticsServer_Histories_RetentionTime_1.00.90+_ESS.txt 20KB
HANA_Threads_CurrentThreads_1.00.120+.txt 20KB
HANA_Replication_SystemReplication_KeyFigures_1.00.120+_MDC.txt 20KB
HANA_ABAP_SDFSMON_FilterAndAggregation.txt 20KB
HANA_LoadHistory_Information_1.00.90+.txt 19KB
HANA_IO_KeyFigures_Details_History.txt 19KB
HANA_Threads_CurrentThreads_1.00.100+.txt 19KB
HANA_SQL_StatementHash_DiffReport.txt 19KB
HANA_Tables_TableClasses.txt 19KB
HANA_Replication_SystemReplication_KeyFigures_1.00.120+.txt 19KB
HANA_Threads_ThreadSamples_AggregationPerTimeSlice_1.00.70+.txt 19KB
HANA_Replication_SystemReplication_Overview_1.00.90+_MDC.txt 18KB
HANA_Memory_Overview_1.00.60+.txt 18KB
HANA_StatisticsServer_Histories_RetentionTime_1.00.74+_ESS.txt 18KB
HANA_IO_KeyFigures_Total_History_1.00.110+_MDC.txt 18KB
HANA_Replication_SystemReplication_KeyFigures_1.00.90+_ESS.txt 18KB
HANA_Tables_ColumnStore_Merges_1.00.90+_ESS.txt 18KB
HANA_SQL_ExecutedStatements_1.00.110+.txt 17KB
HANA_Replication_SystemReplication_Overview.txt 17KB
HANA_Locks_Transactional_LockWaits_Hierarchy_1.00.100+.txt 17KB
HANA_Connections_Overview_1.00.100+.txt 17KB
HANA_Replication_SystemReplication_KeyFigures_1.00.110+.txt 17KB
HANA_StatisticsServer_Histories_RetentionTime_1.00.70+_SSS.txt 17KB
HANA_Indexes_Overview.txt 17KB
HANA_StatisticsServer_Histories_RetentionTime_SSS.txt 17KB
HANA_Backups_BackupRuns_1.00.90+_MDC.txt 17KB
HANA_IO_KeyFigures_Total_History_1.00.110+.txt 16KB
HANA_GarbageCollection_Overview.txt 16KB
HANA_Tables_ColumnStore_TableSize.txt 16KB
HANA_SmartDataAccess_SQL_1.00.60+.txt 16KB
共 390 条
- 1
- 2
- 3
- 4
资源评论
Lam910801
- 粉丝: 5
- 资源: 36
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功