Databases Reference
In-Depth Information
and another that does not, you may be able to decrease the performance penalty.
For example, you could establish a connection that uses encryption for accessing
sensitive data such as an individual's tax ID number, and another connection
that does not use encryption for accessing data that is less sensitive, such as an
individual's department and title. Oracle and Microsoft SQL Server are examples
of database systems that allow this. Sybase is an example where either all connec-
tions to the database use encryption or none of them do.
The small company in this case study was concerned about “machine creep”; too
many machines resided in its lab, and some of the machines were outdated. The
company decided to consolidate five of the machines into one 8-CPU virtualized
machine. Each of the existing machines hosts at least one database application.
The company's IT department started deploying the machine's images on the
one virtualized machine. After deploying two of the images on the virtualized
machine, IT ran performance checks. Performance was great. IT continued
deploying machine images one at a time and testing the performance after each
addition.
Environment Details
The environment details are as follows:
•
The database applications on the virtualized machine vary greatly. Some are
used only by one user a few times a week. Others are used by many users sev-
eral times each day.
•
Machine 1 has two applications that are used by the Accounting department.
Only two employees use these applications, and the applications are used a
few times a week.
•
Machine 2 has a timesheet application that is used by all employees once a
month.
•
Machine 3 has an HR application that is used by one or two employees
throughout the day.
•
Machine 4 has one application that is used by the Sales department. Four or
five people use this application many times a day.
•
Machine 5 has one application that supports the Technical Support depart-
ment. This application is used by seven or eight employees who are creating
and updating support cases throughout the day.
