Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management A Practical Introduction

Authors: Angelo Kinicki, Brian Williams

5th edition

978-1111821227, 9781133190363, 1111821224, 1133190367, 978-0078112713

More Books

Students also viewed these Operating System questions

Question

reverse string in java

Answered: 1 week ago