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

 

where is dsa.png

 

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.

 

image2.png

 

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.

 

image3.png

 

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.

 

image4.png

 

Use Case #2: Determine the cause of  high response time for both DB and storage, potentially caused by a long running Database backup.

 

image5.png

 

Database ocrlhercules has a high DB and Storage Read Response time

 

image6.png

 

View details, graph titled ‘Response Time ms’ showing the high DB and Storage reads response times for a defined time period.

 

image7.png

 

Select the Analytics tab, the database object with the largest IO wait time can be quickly identified.

 

image8.png

 

Details about this object such as the program with the largest IO wait time is also ease to find.

 

image9.png

 

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