Question

Discuss how SQL Nexus assist in developing proper hypothesis for performance issues? 2. What recommendations do you provide a novice DBA for using SQL Nexus?

Answer 1

Solution for the problem is provided below, please comment if any doubts:

1. SQL Nexus assistance in developing the proper hypothesis to handle performance issues:
   • The SQL nexus is a database utility and it is mainly used to identify the performance related issues with the database server.
   • The SQL Nexus mainly process the database log data collects by the tools PSSDIAG and SQLDIAG, the data collected will be subjected to analysis and visualization.
   • This visualization of the data enable to make proper hypothesis since the visualization is the best way to analyze the data to extract the critical data in a fast manner.
   • The data obtained from the PSSDIAG and SQLDIAG is very tough to understand and to extract a proper hypothesis from that data as such is not possible.
   • The SQL nexus will work as a proper tool to use the data obtained from other tools to obtain meaning full hypothesis about the performance issues.
2. Recommendations do you provide a novice DBA for using SQL Nexus:
   • SQL Nexus is a wonderful tool to aid to check the system performance and find the real-time performance issues.
   • Use the real-time performance checker is a useful tool, use it to assess the performance of the system in constant intervals to avoid the service outage and related issues.
   • Use the bottleneck analysis tool to find the bottlenecks in the system, it will help to increase the system performance by avoiding the bottle necks.
   • Use the SQL Nexus as a final tool to analyze the data obtained from other data capturing tools, since the SQL Nexus provides the best visualization among the tools available in the market, it will help you to make proper hypothesis.