Reference no: EM131327048
Objectives:
1. Gather and analyze data for database performance and tuning.
2. Configure and tune a database for optimal performance.
Task # 1 Submit a work proposal for this assignment by the end of week 8th i.e. 3rd
December, 2016 (11:55 pm) which must include:
- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 and task-3.
- Timeline to complete the tasks and resources identified
The work proposal must be submitted in a word file through the link available in Moodle.
Task # 2 a)
i. Explain the installation steps and the key decisions you would take during installation of any STATSPACK utility to collect data useful for measuring performance of database system. Your solution must also include the steps to generate the report having performance data between two snapshots of a database with necessary SQL
commands. The installation and usage procedure must be demonstrated in the college lab in Week 12th as part of the viva.
Screenshots must be included in the solution.
ii. Interpret the buffer cache and log buffer performance ratios from the report and suggest whether tuning is required or not. Necessary screenshot(s) must be included from the STATSPACK report.
b) Discuss with practical examples using necessary SQL commands, how you would gather statistics related with shared pool tuning. Your solution must include the dynamic performance views related with shared pool tuning.
Task # 3 Prepare for a presentation in Week 12th on any one of the following topics:
- Automatic memory management
- Tuning database system I/O usage
- Tuning e-commerce applications Note:
- You must upload the presentation slides as a separate file (.PPT) in Moodle.
- You may include up to 7-8 slides in the presentation document
- Duration of presentation is 10 minutes.
|
Environmental factors that can affect the health of infants
: Develop a pamphlet to inform parents and caregivers about environmental factors that can affect the health of infants. Explain how the environmental factor you selected can potentially affect the health or safety of infants
|
|
Calculate its after-tax weighted average cost of capital
: Given the tax rate of 40% of this corporation, calculate its after-tax weighted average cost of capital (WACC) for Duke Corporation. Answer true, false or uncertain and explain briefly on the following statement. "the after-tax wacc cannot ever be hi..
|
|
Write a reaction paper on the given video
: Write a reaction paper on this video, and specifically on Mr. Burtynsky's work as it relates to our discussion on Landscape. Make sure you read in your book, and utilize concepts, which can be applied to his work, here.
|
|
How do facebooks operations promote or hinder
: Make a case in favor of Facebook taking more responsibility for the fake news stories. On what principles would these responsibilities be based? What actions would be required?Talk about Facebook's role in a functioning democracy. How do Facebook'..
|
|
Gather and analyze data for database performance
: Gather and analyze data for database performance and tuning - Configure and tune a database for optimal performance.
|
|
Write an essay about violence on television
: English 101- Write an essay about Violence on Television. Return this form to me with your name and the date you want to deliver your presentation (or give me the information on a separate sheet of paper).
|
|
Explain your strategy in the market simulation game
: Explain your strategy in the market simulation game. Provide examples of trades that reflect your execution of your strategy, be specific. Discuss any changes to your strategy as the game progressed, did you increase your risk taking, reduce you..
|
|
Annuity from life insurance company
: Your grandmother brought an annuity from a life insurance company for $290,000 when she retires. In exchange for the $290,000 the insurance company will pay her $50,000 per year until she dies. The interest rate is 4%. How long much she live after th..
|
|
Is it possible to live in a world without crime
: Review this Web site, and answer the following questions: Define folkways, mores, taboos, and laws, and then discuss what happens when each one of these is broken. Is it possible to live in a world without crime? What about deviance
|