{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right 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 ® ° Additional Components & Features ° 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 Document Right 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 Document Right 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.

{[ snackBarMessage ]}