In SAP HANA, tenant isolation means multiple tenant databases run within a single system but are logically separated.
Implications:

• Separate users, schemas, and resources per tenant

• Improved security and data isolation

• BASIS admins manage backups, users, and resources per tenant

• Software Update Manager (SUM): Used for system upgrades, EHP upgrades, and migrations

• SPAM/SAINT: Used for applying support packages and add-ons
  👉 SUM is advanced and handles complete lifecycle upgrades

ZDO allows upgrades with minimal business downtime by keeping the system partially available during upgrade phases. It improves business continuity in critical production systems.

• Enhanced security features

• Better memory management

• Improved performance optimization

• Compatibility with latest OS and DB versions

How to

• Analyze workload in ST03N

• Check CPU, memory, and DB performance

• Identify long-running transactions

• Optimize SQL queries and buffer settings

high dialog response time in ST03N?

• Take backup of production system

• Restore DB to target system

• Perform post-copy steps (BDLS, RFC changes)

• Adjust system-specific configurations

Maintenance Planner generates stack XML files required by SUM.
SUM uses this file to execute upgrades and ensure compatibility.

• Monitor using SM12

• Delete old/unnecessary locks

• Increase lock table size if needed

• Analyze programs causing locks

• Client Copy (SCCL/SCC9): Copies client-level data

• System Copy: Copies entire system including database
  👉 System copy is more comprehensive

• Maintain trusted RFCs carefully

• Use authorization objects

• Restrict access via firewall

• Enable logging and monitoring

These files control external program access:

• reginfo: Controls program registration

• secinfo: Controls execution permissions
  👉 Helps prevent unauthorized access

• Schedule jobs during low load

• Use parallel processing

• Monitor via SM37

• Optimize job logic and DB queries

• ASCS (Application Server Central Services): Handles enqueue & message services

• PAS (Primary Application Server): Handles user requests and processing

Secure Network Communication (SNC) provides encryption and secure authentication between SAP components using external security products.

• Use STMS for configuration

• Maintain domain controller

• Implement transport routes properly

• Monitor import queues regularly

• Blue-Green: Parallel environments → switch instantly

• Classical: System downtime during upgrade
  👉 Blue-Green minimizes downtime

SAP integrates via:

• APIs and exporters

• SAP Focused Run

• Monitoring agents for metrics visualization

• ST02 (Buffer)

• DBACOCKPIT

• HANA Studio / Cockpit

• Tables like M_MEMORY

• Use scripts (LSMW, batch jobs)

• Automate BDLS

• Update logical systems

• Schedule background jobs

• ST03N (Workload)

• ST06 (OS level)

• DBACOCKPIT (Database)

• SM50/SM66 (Processes)