sap expert monitor for emc - doag.org · sap expert monitor for emc monitoring emc symmetrix within...
TRANSCRIPT
![Page 1: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/1.jpg)
1
SAP Expert Monitor for EMCMonitoring EMC Symmetrix within SAP
![Page 2: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/2.jpg)
2
SAP R/3 Two-Tier Architecture
DBSAP Instance DVEBMGS00
DIA, UPD
SAP GUI SAP GUI SAP GUI SAP GUI
Application server withCentral InstanceDatabase server
![Page 3: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/3.jpg)
3
SAP R/3 Three-Tier Architecture
SAP Instance D00
DIA, UPD
SAP Instance DVEBMGS00
DIA, UPD
DBDB
DB
SAP GUI SAP GUI SAP GUI SAP GUI
Applicationserver with
dialoginstance
Applicationserver with
CentralInstance
Stand-alonedatabase
server
![Page 4: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/4.jpg)
4
Performance Tools and Transactions:Tuning ABAP, SQL, and the Database
?Workload analysis ST03
? SQL, RFC, and Enqueue tracing ST05
? ABAP runtime analysis SE30
? Optimizer statistics SAPDBA
? Operating system monitor OS07, ST06
? Database buffer hit rates ST04
? Computing Center ManagementSystem (CCMS) RZ20
![Page 5: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/5.jpg)
5
What Information Does RZ20 Provide?
All Information About the R/3 System
?Buffers
?Database
?Operating system
?Security
?System configuration
?CCMS Technical Expert Monitors
![Page 6: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/6.jpg)
6
Database Information within RZ20
![Page 7: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/7.jpg)
7
Operating System Information within RZ20
![Page 8: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/8.jpg)
8
Among Other Sources of Information…
% syminqSymmetrix ID: 000183600181
Device Name Directors Device--------------------------- ------------ -------------------------------------- CapSym Physical SA :P DA :IT Config Attribute Sts (MB)--------------------------- ------------ --------------------------------------02F \\.\PHYSICALDRIVE17 16B:0 02A:C0 Unprotected N/Grp'd RW 1078030 \\.\PHYSICALDRIVE18 16B:0 01A:C0 Unprotected N/Grp'd RW 1078031 \\.\PHYSICALDRIVE19 16B:0 01A:C0 Unprotected N/Grp'd RW 1078
% sar –dSunOS l82aq023 5.7 Generic_106541-19 sun4u 05/15/02
15:12:32 device %busy avque r+w/s blks/s avwait avserv
15:12:42 fd0 2 0.1 12 10 0.0 0.8 nfs155 4 0.3 21 82 0 4.7 sd0 1 0 0.9 12 12 20.6 sd0,a 1 0 6 22 0.3 8.7 sd0,b 4 0.3 14 19 0.3 6.6 sd0,c 5 0.3 20 14 0 3.0
![Page 9: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/9.jpg)
9
Basis Performance Monitoring Transactions
? RZ20: CCMS Monitor Sets— CCMS— SAP Expert Monitor for EMC
![Page 10: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/10.jpg)
10
How to Get to the Symmetrix Information?
/nrz20
Symmetrix
Click on any of the Symmetrix attributes
![Page 11: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/11.jpg)
11
What Configuration Information Doesthe SAP Expert Monitor for EMC Provide?
?Host and operating system information
?Symmetrix general information
?Disk Directors
?Front-end Directors
?Disks
?Hyper volumes
![Page 12: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/12.jpg)
12
Configuration InformationSymmetrix General Information
![Page 13: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/13.jpg)
13
Configuration InformationFront-End Director Information
![Page 14: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/14.jpg)
14
Front-End Director Performance Information
![Page 15: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/15.jpg)
15
Front-End Director Performance InformationDouble Click for Sortable Table Form
![Page 16: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/16.jpg)
16
Configuration InformationBack-End Director Information
![Page 17: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/17.jpg)
17
Disk Director Performance Information
![Page 18: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/18.jpg)
18
Disk Director Performance InformationDouble Click for Sortable Table Form
![Page 19: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/19.jpg)
19
Configuration InformationHyper Volume Information
![Page 20: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/20.jpg)
20
Hyper Volume Performance Information
![Page 21: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/21.jpg)
21
Hyper Volume Performance InformationDouble Click for Sortable Table Form
![Page 22: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/22.jpg)
22
Configuration InformationDatabase Information
![Page 23: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/23.jpg)
23
Datafile Performance InformationDouble Click for Sortable Table Form
![Page 24: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/24.jpg)
24
For Example: Datafile Response Times
Problem:High datafile response times, waits, and I/O rate;unpredictable user response times
Cause:Possible datafile contention and hot volumes;possible database log file contention
Solution:Use SAP transactions OS07, ST04Use SAP Expert Monitor for EMC RZ20
![Page 25: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/25.jpg)
25
Basis Performance Monitoring Transactions
? OS07, ST06: Operating System Monitor— CPU, memory, disk, and network usage— Logical volume queue lengths and wait times— Detail analysis menu ? Disk
![Page 26: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/26.jpg)
26
Basis Performance Monitoring Transactions
? ST04: Database Performance Analysis— Examine database buffer hit rates— Examine datafile response times and wait times— Detail analysis menu ? File system requests
![Page 27: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/27.jpg)
27
![Page 28: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/28.jpg)
28
![Page 29: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/29.jpg)
29
![Page 30: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/30.jpg)
30
Installation Details
? Required files (all downloadable from SAPSERVx andhttp://service.sap.com)— emcmon.dll— sapccmsr.exe— install.cmd— Two SAP transport files
? On Windows NT / 2000, run install.cmd and enter theinformation when prompted
? On UNIX, run “sapccmsr –R” to register the agent
? Currently for Symmetrix only, not available onCLARiiON or Celerra
![Page 31: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/31.jpg)
31
Requirements
?SAP software— SAP Basis 4.6C on the network for the Central
Monitoring System— Installation of CCMS monitoring agent executable
and the EMC plug-in
?EMC software— EMC ControlCenter Resource Availability, EMC
ControlCenter Automated Resource Manager, orEMC WideSky SRM Enabler
— SYMAPI installed and running on the databasehost connected to the Symmetrix
![Page 32: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/32.jpg)
32
Optimizing SAP Performance: Summary
?Database-specific tools— Oracle Enterprise Manager and Performance
Pack— DB2 Performance Monitor and SQL
Performance Analyzer— SQL Server Performance Monitoring Tool
?EMC ControlCenter family— Symmetrix Optimizer— Workload Analyzer— Database Tuner for Oracle and DB2 UDB
![Page 33: SAP Expert Monitor for EMC - doag.org · SAP Expert Monitor for EMC Monitoring EMC Symmetrix within SAP. 2 SAP R/3 Two-Tier Architecture DB SAP Instance DVEBMGS00 DIA, UPD ... sd0,b](https://reader031.vdocuments.us/reader031/viewer/2022021801/5b30d3997f8b9a744a8b533a/html5/thumbnails/33.jpg)
33