Getting The Most From Unisphere Database Storage Analyzer
Database Storage Analyzer (DSA) is a feature of Dell EMC Unisphere for PowerMax, that provides a full representation of the mapping and performance between database objects and Dell EMC PowerMax storage devices.
DSA can clearly highlight the location of a potential problem with a database (Oracle/Microsoft SQL Server) or associated local Dell EMC PowerMax storage array.With no additional cost associated it’s definitely worth kicking the Unisphere Database Storage Analyzer tires!
Array properties, devices, storage groups and allocated capacity associated with the Database storage are just some information available in DSA. The DSA Storage group(s) link allows you to drill down into the performance and masking view (host initiator, ports etc) details of your environment.
Database objects with the most IO wait time associated host, host device, sessions, wait classes focusing troubleshooting and diagnostic efforts for a particular database can all be easily identified.
As well as viewing performance, the DSA FAST hinting feature on PowerMax Hybrid arrays allows you to accelerate your mission critical processes while maintaining the designated service level enabled by the FAST engine on your Storage Groups.
WHERE TO LOCATE DSA?
Simply login to Unisphere for PowerMax
Select HOME > DATABASES
Initial Setup/Registration of your Database with DSA
To add Oracle or MS SQL Server Database(s) use the Register Monitored Environment wizard.As root (or superuser) access over SSH is often disabled, but DSA can also cater for SUDO users where the DB Host Administrator would set up a designated account and grant them the necessary subset of the root privileges via SUDO. This /etc/sudoers config allows the qa11 user to run the mapper_agent.sh as root without a password, from ALL hosts.
"qa11 ALL=NOPASSWD:/var/tmp/UnisphereMapper_Unispherehostname_ora33_on_dbhostname/mapper_agent.sh map -file dbfiles.dat -log_file dbc_mapper.log, /bin/ksh"
From a security view point, DSA uses role based access, so restricting who does what with respect to the database and storage areas of Unisphere for PowerMax, very useful indeed!
Let’s take a look at some Database Storage Analyzer use cases :
Use Case #1: Host CPU impacting Database Performance
The Database Storage Analyzer list view clearly indicates that the Oracle database ora33 is experiencing poor performance response time by colouring part of the database response time status red.
The storage read response time appears to be as expected however the database read response time is high at 84.83.
Select the VIEW ALL DETAILS button to investigate further.
The Active Session Wait chart illustrates that there is a large amount of CPU Count and OS CPU activity on the database host.
For further confirmation that the storage is performing as expected the database and storage reads, writes and redo writes can be investigated on the Response Time and IOPS charts.
Use Case #2: Determine the cause of high response time for both DB and storage, potentially caused by a long running Database backup.
Database ocrlhercules has a high DB and Storage Read Response time
View details, graph titled ‘Response Time ms’ showing the high DB and Storage reads response times for a defined time period.
Select the Analytics tab, the database object with the largest IO wait time can be quickly identified.
Details about this object such as the program with the largest IO wait time is also ease to find.
The associated devices for this database object are obtained by clicking the devices tab.
Shout, if you require any assistance getting started with Database Storage Analyzer!
Hopefully you enjoyed this blog !
For a video on DSA please visit here: Database Storage Analyzer - Troubleshooting a DB RT Issue
Blog Authored by Derek O'Mahony @DerekOMah