SAP HANA Administration:
-------------------------
1.installation of SUSE Linux OS for SAP HANA.
2.LVextend, HANA support file system type, Mount point creation.
3.SAP HANA installation.
4.Updating SAP HANA DB.
5.Applying HANA license.
6.Alerts monitoring and taking counter actions.
7.Log volume administration.
8.Trace file monitoring.
9.Install of SAP HANA DB add-ons based on customer requirements.
10.Setting Global allocation limit for each tenant in SAP HANA.
11.Proactive file system monitoring.
12. Monitoring Scale out s/m and it's core services.
13.Adding Scale out systems
14.removing scale out systems
15.Configuring role for host - master /slave/ stand by.
16.Save current table distribution.
17.Redistribution tables before removing a host.
18.Redistribution tables after adding a host.
19.Restore previous table distribution.
20.Optimize table distribution.
21.Optimize table partitioning.
22.Optimize table distribution manually.
23.Monitor table distribution.
24.System replication.
25.Retained free log monitoring and manually moving with SCP command.
26.Increase no. of Log segments.
27.Disable replication.
28.Alerts configuration.
29. email alerts configuration.
30.Creating custom alerts with sql /corntab.
31.Performance and high resource utilization.
32.Slow system wide performance.
33.Slow individual SQL statement.
34.Frequenct OOM
35.Table administration: Table export / import / table consistency check.
36.Memory problems and fixes
37. CPU related issue and fixes
38.Disk related root causes and solutions.
39.I/O related root caused and solutions.
40.Configuring parameter
41. Log_mode parameter.
42.Export and import parameter in SAP HANA DBA.
43.Backup
44.Recovery
45.Delta merge
46.Crating users in SAP HANA DB.
47.Creating roles in SAP HANA DB.
48.Assigning roles to user.
49.Transactional problems --> Blocked transactions.
50.Log shipping: Maximum the size of log file.
51.Network performance and connectivity problems and solutions.
52.Active and configure audit.
53.Data masking.
54.Data provision.
55.Schema password reset.
56.Monitoring disk volume utilization for all tenant DB.
57.Tenant db create/start/stop/global allocation limit/drop.
58.Delete old backup file and respective entries in backup catalog.
59. Table partition - Hash/Range/ round robin.
60.Workload graph monitoring.
61.mini checks.
62.cache clean up.
63.Convert a row store table to column store table.
64.hdbsql
65.System information tab in HANA studio.
66. Diagnosis tab in HANA studio.
67.Trace configuration.
68.Performance tab: Threads/ Session/Block transactions/
69.Execute statistics/Expensive statements/Progress of long-running jobs
70.system load.
71.Sql commands execution in HANA studio.
72.Export and import of HANA system info.
73.Password reset in HANA studio.
74.load and upload of tables.
75.Stopping and start HDB and monitoring while start/stop.
76.Quick sizer.
77. Installation of HANA studio and Cockpit.
78.XSA engine overview.
79.SAP HANA architecture.
80.Upgrages on HA/DR environment.
81. Export and import of DU/systems/Developer objects/CTS/SAP support care(views).
82.export user master data /importing your master data.
-------------------------
1.installation of SUSE Linux OS for SAP HANA.
2.LVextend, HANA support file system type, Mount point creation.
3.SAP HANA installation.
4.Updating SAP HANA DB.
5.Applying HANA license.
6.Alerts monitoring and taking counter actions.
7.Log volume administration.
8.Trace file monitoring.
9.Install of SAP HANA DB add-ons based on customer requirements.
10.Setting Global allocation limit for each tenant in SAP HANA.
11.Proactive file system monitoring.
12. Monitoring Scale out s/m and it's core services.
13.Adding Scale out systems
14.removing scale out systems
15.Configuring role for host - master /slave/ stand by.
16.Save current table distribution.
17.Redistribution tables before removing a host.
18.Redistribution tables after adding a host.
19.Restore previous table distribution.
20.Optimize table distribution.
21.Optimize table partitioning.
22.Optimize table distribution manually.
23.Monitor table distribution.
24.System replication.
25.Retained free log monitoring and manually moving with SCP command.
26.Increase no. of Log segments.
27.Disable replication.
28.Alerts configuration.
29. email alerts configuration.
30.Creating custom alerts with sql /corntab.
31.Performance and high resource utilization.
32.Slow system wide performance.
33.Slow individual SQL statement.
34.Frequenct OOM
35.Table administration: Table export / import / table consistency check.
36.Memory problems and fixes
37. CPU related issue and fixes
38.Disk related root causes and solutions.
39.I/O related root caused and solutions.
40.Configuring parameter
41. Log_mode parameter.
42.Export and import parameter in SAP HANA DBA.
43.Backup
44.Recovery
45.Delta merge
46.Crating users in SAP HANA DB.
47.Creating roles in SAP HANA DB.
48.Assigning roles to user.
49.Transactional problems --> Blocked transactions.
50.Log shipping: Maximum the size of log file.
51.Network performance and connectivity problems and solutions.
52.Active and configure audit.
53.Data masking.
54.Data provision.
55.Schema password reset.
56.Monitoring disk volume utilization for all tenant DB.
57.Tenant db create/start/stop/global allocation limit/drop.
58.Delete old backup file and respective entries in backup catalog.
59. Table partition - Hash/Range/ round robin.
60.Workload graph monitoring.
61.mini checks.
62.cache clean up.
63.Convert a row store table to column store table.
64.hdbsql
65.System information tab in HANA studio.
66. Diagnosis tab in HANA studio.
67.Trace configuration.
68.Performance tab: Threads/ Session/Block transactions/
69.Execute statistics/Expensive statements/Progress of long-running jobs
70.system load.
71.Sql commands execution in HANA studio.
72.Export and import of HANA system info.
73.Password reset in HANA studio.
74.load and upload of tables.
75.Stopping and start HDB and monitoring while start/stop.
76.Quick sizer.
77. Installation of HANA studio and Cockpit.
78.XSA engine overview.
79.SAP HANA architecture.
80.Upgrages on HA/DR environment.
81. Export and import of DU/systems/Developer objects/CTS/SAP support care(views).
82.export user master data /importing your master data.
No comments:
Post a Comment