1 / 42

Our Mission

Our Mission. To enable today’s businesses to achieve 24x7 operation of mission-critical applications. Hardware/Network. HP Cisco Sun EMC Veritas Legato. Operating System. CA Tivoli BMC. Quest Software. Quest Software. The eBusiness Infrastructure Landscape. Application/Database.

jenis
Download Presentation

Our Mission

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Our Mission To enable today’s businesses to achieve 24x7 operation of mission-critical applications

  2. Hardware/Network HP Cisco Sun EMC Veritas Legato Operating System CA Tivoli BMC Quest Software Quest Software The eBusinessInfrastructure Landscape Application/Database DEVELOP/DEPLOY MANAGE Apps DB

  3. DEVELOP/DEPLOY MANAGE DB Server Development DB Change Management Database Performance Management High Availability DB & Application Monitoring Application Offloading The Complete Quest Solution

  4. SQL Impact™ Predicting the Impact of Database Change 4

  5. Intended Audience • If you’re making changes to database objects and/or application source code, and need to … • Identify and document application impact and dependency information • Scope plans for development, testing, QA, deployment • Pinpoint problems or assess risk of changing indexes, tables, triggers, PL/SQL, programs… • Better understand how the application and the database interact together • Identify and resolve application SQL performance and tuning related issues • Assess and identify SQL related anomalies • QA application changes 5

  6. Presentation Agenda and Contents • SQL Impact Customer Issues and Solutions • SQL Impact Benefits • SQL Impact Tour • Summary • Further Questions 6

  7. SQL Impact™Customer Issues • Application Releases “It’s difficult to implement and release change requests without adversely affecting other dependent code. Things like critical queries, reports and applications may fail due to incompatibilities between the application code and the database structures.” “What’s needed is a way to analyze the contents of a release and identify what other objects are affected.” 7

  8. Release programs Impact Engine Release Schema changes PROD Index problems Missing objects SQL Impact Solution “Delta Impact” Prior to releasing your application you need to avoid the risk of objects being missing. You need to also be sure that the release, as well as everything that interacts with it, is going to perform well. 8

  9. SQL Impact™Customer Issues • Application Releases • Application Performance “It’s difficult to ensure that all new or modified source code components and indexes will perform adequately prior to actually migrating and executing the changes.” “What’s needed is a way to identify and correct problem SQL in the source code before customers are affected by it.” 9

  10. Programs DATA- BASE objects Impact Engine New index candidates Tuning Advise From SQLab Xpert Bad explain plans Unused indexes Table join problems SQL Impact Solution “Proactive Application Performance and Tuning” Proactively identify performance problems through extensive explain analysis of all SQL in an application without executing a single line of code. Then get expert advise to tune. 10

  11. SQL Impact™Customer Issues • Application Releases • Application Performance • Application Complexities “Large applications often have single database columns referenced in thousands of different places throughout the source code. This code is often written in many different languages. Multiple applications sharing a common database compounds the problem even further.” “What’s needed is a simple way to step through typical database change scenarios and have the impact dependencies identified for me.” 11

  12. Table impact Impact Engine Stored Code impact View impact Trigger impact Index impact SQL Impact Solution “Change Impact Wizards” Reporting Impact Analysis on any component being changed. Point to the object being changed and let SQL Impact step you through to the results. 12

  13. SQL Impact™Customer Issues • Application Releases • Application Performance • Application Complexities • Application Documentation “Documenting comprehensive change impact analysis often requires extensive knowledge of the database and source code interrelationships and a great deal of time. This can adversely result in development and testing bottlenecks.” “What’s needed is a way to automatically generate documentation for different changes.” 13

  14. Programs DATA- BASE objects Impact Engine Quality Audit Reports Catalog Reports DBA Reports Anomaly Reports Program Reports SQL Impact Solution “Built in Reports” Extensive reporting available for DBA’s, developers, QA, test, and project leads 14

  15. SQL Impact™Customer Issues • Application Releases • Application Performance • Application Complexities • Application Documentation • Application Visibility “When a database or source code component is modified, manually identifying and viewing all affected code is difficult, time-consuming and error prone.” “What’s needed is a way to collect, view, and edit the source code and database information from one environment” 15

  16. A C B F E D Server End programs Impact Engine S G DATA- BASE objects N K V T H O Client End programs Z M J W Programs in configuration MGT tool SQL Impact Solution “Total Understanding” Comprehensive impact analysis information is gathered from the database objects, stored code, client end programs, server end programs and programs stored in configuration management tools. 16

  17. SQL Impact™Benefits Overview • Perfect Complement to Your Development And Deployment Methodology • Risk Elimination • Performance and Tuning • Timely Releases • Audited Changes • Total Understanding 17

  18. SQL Impact Tour Application Performance & Quality Reports 18

  19. SQL Impact Tour… Scan and Catalog your Source Code First, you would want to scan and analyze your applications. SQL Impact supports many development environments. This includes languages such as COBOL or C, as well as Forms and Reports, VB, PowerBuilder, SQL and shell scripts, Delphi, Perl, Java, and report writers in addition to the stored PL/SQL, functions, triggers, views, and procedures… 19

  20. SQL Impact Tour… Scan and Catalog your Source Code…Continued When you have completed the scan, SQL Impact will present a summary listing showing all scanned code and any SQL errors or warnings encountered. Re-registration can also be scheduled with any popular scheduler and run in batch mode for ‘hands-off’ scanning. You can set conditions that SQL Impact will use during the scanning process. SQL Impact can directly inventory local files, remote files (ftp), data dictionary objects, SQLab repository collectors, and also version control systems such as PVCS and Visual Source Safe. 20

  21. SQL Impact Tour…Source Code Quality Audit Running the Source Code Quality Audit is a good way to validate your SQL statements against the Oracle data dictionary. It records any anomalies that it finds and assigns them a severity rating based on their potential impact, (missing database objects, index usage analysis, mismatched joins, and more). You can tailor the report for your applications’ individual needs by selecting and storing the results of the report. 21

  22. SQL Impact Tour…Wizards...Ease of Use SQL Impact wizards make it easy for you to step through proposed database object changes to reveal what other database objects and source code will be impacted. These wizards include changes for tables, views, indexes, triggers, and stored PL/SQL. 22

  23. SQL Impact Tour…Table Change Wizard First, let’s run through the impact wizard for a table change to the OW_CUSTOMERS table to see what applications might be affected by our change request... We propose to modify the CUST_ID column. 23

  24. SQL Impact Tour…Table Change Wizard…Continued SQL Impact provides us with a summary listing of impacted database objects and code. Notice the “Joins with” icon. SQL Impact has realized that the application is joining these two tables on the CUST_ID column, which we are planning to modify. So a change to CUST_ID in OW_CUSTOMERS will indirectly impact OW_ORDERS. Additionally, we see a list of files directly referencing OW_CUSTOMERS and the SQL code contained in those files. 24

  25. SQL Impact Tour… Viewing Source for More Details SQL Impact drills down to the actual source code, highlighting the lines affected by our change to CUST_ID. You can call your favorite editor directly from SQL Impact to update the code. This allows you to make decisions on your changes faster and with more reliability and confidence. 25

  26. SQL Impact Tour…Development…Integration with SQL Navigator™ & TOAD™ When we make our change using SQL Navigator or Toad, developers and DBA’s can identify areas of concern early by launching the SQL Impact ‘Where Used Report’ and the ‘Source Code Quality Audit Report’. 26

  27. SQL Impact Tour… Index Change Wizard Additionally, SQL Impact Index Change wizard can be used to compare explain plans both before and after a change. 27

  28. SQL Impact Tour…Tree Navigator…the Source Code and Database Perspectives Additionally, you can drill down into the targetdatabaseand see references to source code as well as other database accesses and dependencies. With the navigator on the left you can drill down into the source code and see references to database objects and stored code, as well as what other source objects are dependent on the program. 28

  29. SQL Impact Tour…Reporting SQL Impact provides formal documentation through a variety of reports…database object analysis, anomalies, performance, DBA change scenarios, audit summaries and much more. These reports are directly viewable and can be output in many popular formats. 29

  30. SQL Impact Tour… Reporting…Database Object dependencies For our change request, we would run the table/column change report on OW_CUSTOMERS, save the results, and notify the affected development groups to use for estimating the TIME required to analyze, develop, and test. Many more analysis reports exist to assist in finding and documenting impacts, dependencies, and performance issues. 30

  31. SQL Impact Tour…Queries Ad-hoc queries give you the flexibility to precisely define your criteria to get the specific impact information you want. You can also filter what columns of information will be shown in the output. Reports and Queries are very useful for code walk-thru’s and documenting the scope of changes for development and testing. 31

  32. SQL Impact Tour…Diagrams…Database and Program Dependencies SQL Impact has the ability to graphically ‘view’ database and source code relationships. Here is a great way for both DBA’s and Developers to visualize and communicate how the application is accessing the database. Selecting “Join Analysis” provides the user the ability to see which code is responsible for the joins between tables. 32

  33. SQL Impact Tour…Deployment…Integration with Schema Manager™ Prior to deployment of the delta change to the OW_CUSTOMERS table using Quest Software’s Schema Manager, DBA’s can run the SQL Impact wizard to see what other source objects are affected by the change or what database objects may be missing prior to deployment. More insurance for your critical deployments. 33

  34. SQL Impact Tour…Performance and Tuning…Identify Problem SQL Use the SQL Impact Batch Explain Plan Wizard to identify SQL statements in the code that may benefit from tuning. You can also use the execution plans as reference if you are adding a new index or changing an existing one. 34

  35. SQL Impact Tour… Performance and Tuning…Fix SQL with SQLab Xpert ™ Once you have identified the offending SQL with the Explain Plans query, you can fix the problem SQL statements with the SQLab Xpert comprehensive tuning and advice integration. 35

  36. SQL Impact Tour…Performance and Tuning…Get advice from SQLab Xpert ™ Once SQLab Xpert displays its advice, you can highlight the recommended changes and …. 36

  37. SQL Impact Tour…Performance and Tuning…Search SQL Impact Repository from SQLab Xpert ™ Search the SQL Impact repository for any other programs containing the given SQL. 37

  38. SQL Impact Tour… And…Dynamic SQL, SGA, SQL Tester, Synonyms… Finally, SQL Impact can be used to scan the SGA, test your SQL statements, compare explain plans, resolve dynamic SQL and synonyms, and much more… 38

  39. SQL Impact Summary • Get the complete application impact and dependency picture when changing indexes, tables, views, triggers, PL/SQL, or programs • SQL Impact also helps you to… • Enhance understanding of database and source code relationships • Simplify discovery of problem SQL • Determine scope of changes more accurately • Improve performance by finding source code SQL problems • Save DBA and Developer time • Provide QA with the information to ensure better quality • Give management the tools for productivity improvements 39

  40. SQL Impact Summary ? ? Questions? ? ? ? ? 40

  41. Don’t miss the Schema/Data Manager call Thursdays @ 10 am pst • End-to-end schema management solution • Make complex schema changes quickly and accurately • Generate “apply” and “rollback” scripts automatically • Compare, version, and synchronize the schemas and PL/SQL • Automatically document all changes • Instantly setup storage and privileges • Pre and post audits identify potential and actual problems before and after implementing changes • A data management solution that makes complex data extracts/moves easily and quickly • Speed the extraction of reliable test data • Reduce bottlenecks in testing due to missing data • Simplify creating data scripts for complex databases • Save DBA and Developer time • Reduce test and dev storage and machine requirements 41

More Related