Gather and analyze data for database performance

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.

Reference no: EM131327048

Questions Cloud

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

Reviews

len1327048

12/26/2016 12:14:30 AM

Task 1 Submission of work proposal • Objectives of the Assignment clearly identified: poor/ fair / clear • Initial understanding of Tasks -2 and Task-3: poor/fair/clear • Resources identified: poor/fair/clear Task 2 Performance Analysis Tool; gather and analyze data Poor/weak/incomple te steps and analysis Partially Successful installation of software utility and fair analysis of output. Very good /successful analysis of utility report and analysis of output Task 3 Database Tuning Contents and structure (Poor / Fair / Good) Presentation (Poor / Fair / Good)

len1327048

12/26/2016 12:13:44 AM

Follow the guidelines mentioned below for your assignment: - Code developed (Soft Copy) should be included. Assignment must be submitted through Moodle and it will undergo plagiarism detection test through turnitin (a plagiarism detection tool). - Handwritten assignments / hard copy will not be accepted. - Use Page Number & proper References. - Assignment should have a Title Page. Title Page should contain the following information. - Assignment Name - Section Name - Student name - Student ID Number - Faculty Name - The Table of Contents Should have, each deliverable task number, content, page number - Assignment should be typed in your own words using Times New Roman font size 12. - Heading should be with Font Size 14, Bold, Underline - Feedback on work proposal shall be given in Moodle within one week from the last date of submission. Feedback on final assignment submission shall be given in Moodle within two weeks from the last date of submission.

Write a Review

Required(*) Message

Compare your war veteran to the likes of timothy mcveigh

Compare and contrast your war veteran to the likes of Timothy McVeigh, who was also a veteran responsible for blowing up the Alfred P. Murrah Building in Oklahoma City on April 19, 1995.

How did you resolve the conflict in your example

Describe a situation from your own life in which you felt uncertain about a decision that you needed to make. Please make sure to use an example that you feel comfortable disclosing with your instructor and classmates.

Why was the annexation of texas so controversial

Why was the annexation of Texas so controversial? What conditions gave rise to the early women's rights movement?

The milgram obedience experiments had ethical problems

The Milgram obedience experiments had ethical problems because

Has no direct concern for the feelings of others

How, according to Nagel, may someone who "has no direct concern for the feelings of others" nevertheless be forced to acknowledge that it is wrong to harm them?

Which of two major parties do you most agree with and why

Which of the two major parties do you most agree with? Why? Create your presentation, making sure to include a source list of at least three research sources.

How did geography help defeat the british at yorktown

How did geography help defeat the British at Yorktown? In what ways might the states have been called the Disunited States in 1781? As Americans fought the revolution, what events were taking place in the present-day Southwest?

Argument for choosing death over escape

What is Socrates' argument for choosing death over escape? Do you think he made the right choice?

Volumetric water content of root zone

Establish a grass cover over a 10ha landfill. The root zone of the grass is 40cm deep. Increase the volumetric water content of root zone from 12% to 24%. How many cubic meters of water are needed?

Legal-ethical and discretionary responsibilities

The criteria for corporate social responsibility suggest that economic responsibilities are of the greatest magnitude, followed by legal, ethical, and discretionary responsibilities. Do you agree? Why or why not? Remember to support your position.

Evaluate the role and importance of personal ethics

Evaluate the role and importance of personal ethics in the field of psychology, the development of principles, and the code of conduct - identify how your ethics style affects how you will apply psychological principles to personal, spiritual, so..

What is the publisher trying to optimize-collation time

What is the publisher trying to optimize? Is he trying to maximize or minimize? Write the objective function to support this analysis. What inputs do you need to support your analysis? Is there any extraneous data you have been given that you will no..

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages