Concept explainers
A user complains that her computer is performing slowly. She tells you the problem started about a week ago when new
a. Uninstall the database software and see if performance improves.
b. Use Performance Monitor and Process counters to observe performance.
c. Use the Performance tab of Task Manager to observe database software activity.
d. Install more memory to improve system resources to handle the new software.
Explanation of Solution
Given:
A user installed a software to update the database synced in database servers and users’ workstation. After performing all these tasks, the users’ computer gets slowed down.
To find: The method/tool to solve the hogging problem caused due to the installation of new software.
Solution:
Open the Task Manager and check the application that is using maximum RAM and Disk Space.
This application is responsible for computer hogging. When one program needs all of the CPU’s attention, other programs that also need the CPU might not get enough time to do their work.
Hence, c is the correct option.
Want to see more full solutions like this?
Chapter 14 Solutions
A+ Guide To It Technical Support
- It's recommended that you begin with a database that is administered by a flight service and makes use of "snapshot isolation" to get the most out of this illustration. What if the airline's improved overall performance was not due to a serializable execution, but rather to a non-serializable one?arrow_forwardQuestion 8. If You Didn't Have Access To The Standby Database And You Wanted To Find Out What Error Has Occurred In A Data Guard Configuration, What View Would You Check In The Primary Database To Check The Error Message?arrow_forwardHow do transaction logs assist in maintaining the state of a database during system failures?arrow_forward
- Parallel database systems store replicas of each data item (or partition) onmore than one node.a. Why is it a good idea to distribute the copies of the data items allocatedto a node across multiple other nodes, instead of storing all the copiesin the same node (or set of nodes).b. What are the benefits and drawbacks of using RAID storage instead ofstoring an extra copy of each data item?arrow_forwardAn issue that has to be answered is who is responsible for backing up the database-the administrators of the database or the administrators of the server.arrow_forwardWhen you think about a bank's database, think about how the database system uses "snapshot isolation." People at the bank might have trouble when a non-serializable execution happens, which would be bad for them.arrow_forward
- It's possible that doing a server database migration might come with certain hazards?arrow_forward#ComputerOrganizationandArchitectureCourse 1. Answer the question Performance Measurement. Elaborate your answer in an essay form. a) A company that is selling database management optimization software contacts you to pitch its product. The representative claims that the memory management software will reduce page fault rates for your system. She offers you a 30-day free trial of this software. Before you install it, however, you decide to first determine a baseline for your system. At specific times of the day, you sample and record the page fault rate of your system (using the system’s diagnostic software). You do the same after the software has been installed. How much of an average performance improvement has the new software provided? (Hint: Use the harmonic mean.) The fault rates and times of day are shown in the table below.arrow_forwardIn the case that the database has to be restored, what are the three distinct varieties of backups that may be deployed in this process? To put it simply, what precisely is the role that each succeeding level of backups is supposed to play?arrow_forward
- Do database users have the responsibility of backing up their own databases, or does the database administrator have that responsibility? a someone who is in control of the servers.arrow_forwardSky Connectiva has 300 branches across the world. Indonesian archipelago, therefore the company decided to create a RAID system on the Sky Connectiva database system. You are asked to analyze: i. What is the difference between mirroring, parallel access, and independent access?Ii. If the company can only have a maximum of 3 disks, and the information must beScattered across all those disks, what RAID would you suggest?arrow_forwardYour company has made the decision to clone your product database over many servers in order to increase performance. How many different factors must be considered?arrow_forward
- A+ Guide To It Technical SupportComputer ScienceISBN:9780357108291Author:ANDREWS, Jean.Publisher:Cengage,Systems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher:Cengage Learning