EDT14SN

EDT14SN - How to Use Unicenter SQL-Station to Effectively...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
How to Use Unicenter ® SQL-Station ® to Effectively Debug, Tune and Optimize SQL Infrastructure Management Session Code: EDT14SN
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Abstract Learn how to get the most from your SQL statements. This session will focus on how Unicenter ® SQL-Station ® can help optimize your SQL environment through efficient debugging and tuning strategies.
Background image of page 2
Agenda How SQL Impacts Business Challenges with SQL SQL Development Tools Unicenter ® SQL-Station ® SQL Tuning Summary Questions and Answers
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
SQL Impacts Business Application performance Problems usually revealed too late in the lifecycle Does not meet expected service level under load Retrieves data by knowledge of data Not what is the best way to get it out of database Different database types, different access path Is the optimizer choosing the best path Hardware just defers performance problems “Bad” SQL will ultimately max-out CPU and memory Excessive I/O inflates storage costs
Background image of page 4
The Challenge With SQL Requires expertise in several domains SQL not an end user language or intuitive Compounded by RDBMS SQL variants SQL design and use of appropriate constructs Pressure to reduce development time SQL optimization and adjustment of execution plan Access to SQL and its statistics Simple methods produce inaccurate results Productivity Different database query access methods Develop, debug, test without impacting production SQL workload always evolving Each path or upgrade requires regression testing
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Unicenter ® SQL-Station ® Simultaneous connections to multiple, heterogeneous databases
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 22

EDT14SN - How to Use Unicenter SQL-Station to Effectively...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online