100% Original, Plagiarism Free, Tailored to your instructions

Order Now!

Database Trouble Shooting & Performance Tuning

Assignment Requirements
Assignment Format
This assignment is laid out as follows:
• Letter of Engagement : 2pages
• Proposal – Part I : 5pages
• Proposal – Part II : 2 pages
Total: 9 pages
Check the additional file for more information on the assignment and the case study for the proposals.
You will be marked according to the following criteria:
l Professional Quality
l Letter of Engagement
l Complete Discussion of Part I
l Complete Discussion of Part II
l Provide an Architecture Diagram of the solution in Part II
l Covers Database Backup concepts
l Covers the approach to database base lining and tuning concepts
Assignment Format
This assignment is laid out as follows:
 Letter of Engagement : 2pages
 Proposal – Part I : 5pages
 Proposal – Part II : 2 pages
Total: 9 pages
Letter of Engagement – Context
You are required to write a proposal to the CIO of Synergy Sol, Peter Pan recommending the steps you would take to fix their problems. The details of your company are as follows:
Superhero Computer Solutions Limited PTY LTD
Logo : Draw one/ Pick one off the internet
Address: 1 Macquarie Park
Talavera Road
Website : www.superhero.com.au
Email: sales@superhero.com.au
Phone: +61 2 9899 8888
Letter of Engagement : Introduction/Executive Summary/Pricing
You are required to do some research, e.g. on the internet for a sample of a ‘letter of engagement’ or you can roll your own.
The objective of this section is to familiarise you with real world requirements. i.e. As a services company, your first engagement with a client is always a Letter of Engagement (LOE) that scopes out what you will do and the price that you will charge. Once the client has accepted your LOE, you will then be commissioned to executed the aforementioned item of work.
Proposal Context
You are a senior Database Performance consultant from Superhero Computer Solutions, and have been engaged by Synergy Sol to help the aging DBAs to fix the performance problems. How would you solve this performance challenge? Please read the case study scenario carefully. You should state any assumptions.
Your proposal response should draw upon the knowledge that you have learned in your lectures as well as having read the required course text book. Additional reading for this assignment through research would enhance your proposal.
Commercial Perspective:
This assignment has been designed to give you a general oversight of the typical issues that you will
face as a database administrator/consultant in most commercial situations. The objective is to prepare with a solid foundation of good database design principles and troubleshooting techniques.
Part I Case Study – CRIM Workflow Scenario
Synergy Sol is a large legal firm based in Sydney. In the 35 years since establishment it has grown into a 150 strong organisation that specialises in helping Government agencies with legal matters relating to large contracts. Over the years Synergy Sol have invested heavily in IT, and in particular a document workflow management system that has been their competitive edge in keeping ahead of the competition and helping keep costs down. The core technology components have been the CRIM document and workflow management system.
Over the last 4 years, CRIM has been stable, but with the recent Infrastructure upgrade, Synergy Sol have gone for the latest Windows 8.1 Operating system as well as upgrading CRIM to work on Windows Server 2013 Release 8. They have invested heavily in New Windows workstations and new Dell Servers.
The basic architecture of the CRIM application has now been enhanced to integrate with the MS Office suite. On the desktop, the old CRIM application was replaced with an MS Office Suite plugin that connects via a SQL adapter to the database that is running on an upgraded server.
On the server side, the CRIM Application Server and Database Server runs one DELL server.
Documents are now directly saved from Outlook and MS Word without the user having to save a local copy. With the old application, the user had to use the stand alone CRIM client application to upload to the CRIM documents management system. It was the promise of this automated feature that prompted the million dollar upgrade.
CRIM Upgrade History
During the infrastructure upgrade the OLD CRIM database was migrated ‘copied’ to the new server and the new CRIM application pointed to the old Database. 3 months after paying $3 million for the upgrade, the application started to slow down dramatically.
The performance symptoms were as follows:
Microsoft Outlook would launch but is very slow. Word documents were taking forever to save. (it can take more than 30 seconds) What used to be a few mouse clicks has become a major service escalation with only pockets of user being affected at any one time. The help desk remedy was to ask their users to reboot their brand new desktops. This used to work initially, but now the solution seems to be ineffective and exacerbates the problem. There also seemed to be no logical groupings of users affected.
Your proposal should recommend a course of action to solve the database performance problems. Hints: Baseline techniques, Physical Database Design; Network Contention; I/O bottlenecks; Performance bottlenecks; database hotspots; Hardware Configuration etc. as discussed in the lectures
Part II Case Study – Piccolo Case Manager Scenario
Piccolo is another standalone application that is used to lodge new cases. For every new client and each subsequent engagement, Synergy Sol logs the activity/investigation as a case. The Piccolo client is also installed on the SOE (Standard Operating Environment – Recommend doing some research to be familiar with this term). Due to the growth in the volume of business, the Piccolo system is currently experiencing a host of performance issues. The MS SQL 2012 Server database seems to be the cause of all the performance issues. As part of the investigation, you discovered the following problems:
1) The Audit logs and the database reside on the same hardware infrastructure.
2) A small group of users are running regular ad hoc reports against the live database – impacting the performance of the application for all users.
3) There seems to be no database backup systems in place!
Prepare a short report that details your recommendations to address these findings.
This section of your report should also present a proposed architecture diagram for your recommended solution.
Hint: This section is about Transaction Log / Audit Log best practices/ Database Replication and reporting copies. Database backup solutions. Consider also: DB performance Base lining Methodology Disk Planning – RAID Types; Database Migration best practice/checklist; Database Securty etc Refer to lecture and tutorials for inspiration.
You will be marked according to the following criteria:
l   Professional Quality
l   Letter of Engagement
l   Complete Discussion of Part I
l   Complete Discussion of Part II
l   Provide an Architecture Diagram of the solution in Part II
l   Covers Database Backup concepts
l   Covers the approach to database base lining and tuning concepts
Order Now

Our Service Charter

  1. Excellent Quality / 100% Plagiarism-Free

    We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
  2. Free Revisions

    We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
  3. Confidentiality / 100% No Disclosure

    We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
  4. Money Back Guarantee

    If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
  5. 24/7 Customer Support

    We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

Instant Quote

Single spaced
approx 275 words per page
Urgency (Less urgent, less costly):
Total Cost: NaN

Get 10% Off on your 1st order!