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?

Answer rating: 100% (QA)

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 the full answer