and alsoto introduce new objects to the database. You also want to upgrade the hardware. You have already created a test

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

and alsoto introduce new objects to the database. You also want to upgrade the hardware. You have already created a test

Post by answerhappygod »

and alsoto introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:-> analyze and compare the overall database workload with concurrency and transaction characteristics-> find SQL statements that might get regressed because of the upgrade-> analyze execution plans for SQL statements for which performance might get regressed-> analyze the impact of new schema objects on database performanceWhich two tools would you recommend to achieve the objective? (Choose two.)

A. Database Replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. Automatic Database Diagnostic Monitor (ADDM) compare periods report E. SQL Performance Analyzer F. Automatic Workload Repository (AWR) compare periods report
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply