Share:|

In this session, Rajeev will review the OOTB overview console architecture, key tables, review a customer scenario "untuned" and the methodology necessary to identify the changes needed to tune the SQL statements issued by the Overview Console.  Tuning is done using Oracle's Explain Plan utility in an Oracle 11.2.0.3 database, but the methodology described is applicable to MSSQL using SQL Management Studio.

 

Rajeev Patel is a Senior Product Developer

 

Below is the recording from the live webinar including Q&A asked during the event.  The recording is also available as a podcast on iTunes.

 

 

 

 

Presentation References

Oracle Explain Plan

https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm#g42231

 

Query Tuning in MS SQL Server

https://technet.microsoft.com/en-us/library/ms176005(v=sql.105).aspx

 

For more information, or if you have questions, please contact Gregory Kiyoi or Steven Duncan

Remedy AR System Remedy ITSM Atrium Digital Workplace / MyIT HR Case Management  Discovery / ADDM