Question: You are just employed as a Database Administrator (DBA) at Nusantara Hospital, which now has to cope with increasing number of patients. Currently, the hospital

You are just employed as a Database Administrator (DBA) at Nusantara Hospital, which now has to cope with increasing number of patients. Currently, the hospital is using Microsoft SQL Server as its database software and installed it locally. There are programmers who design the database system and write web-based user interface. However, as the users of the system are growing, the system is getting slower and sometimes unresponsive. Your role as the DBA organization is to configure and optimize SQL Server, monitor its performance and provide troubleshooting of database related problems.

Specifically, there are tasks that you shall work out:

(a) You want to make sure the integrity of the data and the transactions, such as the patient’s medical record or history of prescriptions given by the physicians. How do you turn the log or trace of transactions on, so that you can inspect it later?

(b) Would you choose to turn off the options for the Single Page Allocation for all databases within SQL Server? Why or why not?

(c) Let’s suppose that the hospital management wants to upgrade the hardware and ask you whether to use Symmetric Multiprocessor System or Non-Uniform Memory Access. Which one are you going to recommend?

Step by Step Solution

★★★★★

3.47 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Enabling Transaction Logs for Data Integrity To ensure data integrity and transaction traceability you should enable transaction logging for the SQL Server databases This will create a record of all ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Operating System Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...

Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Based on information available, assess the general strategic planning approach/process used by each of the healthcare organizations: Case 6: Midcare, Inc. M iddleboro Medical Center (MIDCARE) was...

ITM 309: Business Information Technology and Systems Spring 2016 Watson and the new era of cognitive systems Jerry Haan IBM Cloud Ecosystem Development January 27, 2016 2013 International Business...

Data Warehousing Failures Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure...

Provide the details for the proof of part (b) of Theorem 7.7. Theorem 7.7 If A is a set, then (b) Any partition of A gives rise to an equivalence relation R on A.

The survey mentioned in problem 6.5 found that 25 of the 178 households consisted of unmarried couples who were living together. What is your estimate of the population proportion? Use the 95% level.

If F ( x ) = 2 x 4 x 4 e ( e 2 4 ) d t , what is F ' ( x ) ? ( Do not include " F ' ( x ) = " in your answer. )

The segment of a circle is the region bounded by a chord and the arc subtended by the chord. See Figure 3.9. Find the area of a segment of a circle with a central angle of 120 and a radius of 64 cm.

Find the largest negative angle coterminal with (107T)/6.

Find the area of a sector of a circle with central angle of 108 if the radius of the circle is 15cm.

Find the radius of the circle in which a central angle of (5Tt/4) determines a sector of area 32 in?.

In theory of simple bending, it is assumed that the material is non-homogeneous, isotropic and obeys Hookes law. (True/False).

duction to Research Methods In this part of the assignment, we will examine data collected from the General Social Survey (GSS), which was administered to a large, representative sample of American...

As a manager, what would you do? 1. Tell the mortgage company your friend is still employed by the company. Your friend needs a break, and you're confident that he'll find a job in the near future....

How do you feel about forcing employees to donate part of the pay to charity? 1. Goldman should not adopt this policy. Charitable donations are a personal decision and an employer should stay out of...

1. Deliver the presentation as planned. 2. Give the presentation but skip over the negative results. 3. Go back to the meeting room and announce that your spouse has had an accident at home and you...

=+(cf. Example 5.8, Section 5.3) and that each component has a .999 probability of functioning without failure. What lower bound can you put on the reliability (i.e., the probability of functioning...

=+12. Suppose that 55% of all adults regularly consume coffee, 45% regularly consume carbonated soda, and 70% regularly consume at least one of these two types of drinks.

=+.01 probability of failing. Find an upper bound on the probability that the entire system fails.