Premium Essay

A Comparative Investigation and Evaluation of Oracle9I and Sql Server2000 with Respect to Performance and Scalability

In: Computers and Technology

Submitted By phathi
Words 3061
Pages 13
A Comparative Investigation and Evaluation of Oracle9i and SQL server2000 with respect to Performance and Scalability
By Phathisile Sibanda
Supervisor: Mr John Ebden
Computer Science Department, Rhodes University
26 September 2005
Abstract: Performance and scalability are two omnipotent factors determining database availability and reliability. This is especially true for modern computer systems due to the inclusion of the Internet in Online transaction processing (OLTP) and E-commerce applications which use databases. This evolution gave birth to an enduring need for high throughput, good response time, excellent data consistency and concurrency control. This paper evaluates SQL server 2000 and Oracle 9i with respect to performance and scalability. Initial performance tests showed that at low to medium workload both database systems behaved in a similar fashion in terms of throughput and response time. At high load however Oracle 9i emerged victorious in both cases.

market and use of the Internet in databases. The first point has lead to competition between commercial and open source database vendors while the second has resulted in a need for high performance database systems. This whole controversy has in the past lead database vendors to employ numerous tricks in bid to improve the processing speed of their systems during benchmarking and thus falsely prove that their databases products are superior to other competitors. Some of their tricks include using high-speed CPUs and clusters, caching up data rows and storing SQL execution plans into
RAM prior to testing thus bypassing disk I/O access and tremendously increasing performance
(Burleson D, 2002).AS a result the author seeks to provide an independent third voice that will aid DBA in decision making.

1. Introduction
This project explores and evaluates…...

Similar Documents

Free Essay

Sql Performance Analyzer

...SQL Performance Analyzer in Oracle Database 11g Release 1 The concept of SQL tuning sets, along with the DBMS_SQLTUNE package to manipulate them, was introduced in Oracle 10g as part of the Automatic SQL Tuning functionality. Oracle 11g makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as: •Database, operating system, or hardware upgrades. •Database, operating system, or hardware configuration changes. •Database initialization parameter changes. •Schema changes, such as adding indexes or materialized views. •Refreshing optimizer statistics. •Creating or changing SQL profiles. Unlike Database Replay, the SQL Performance Analyzer does not try and replicate the workload on the system. It just plugs through each statement gathering performance statistics. The SQL Performance Analyzer can be run manually using the DBMS_SQLPA package or using Enterprise Manager. This article gives an overview of both methods. •Setting Up the Test •Creating SQL Tuning Sets using the DBMS_SQLTUNE Package •Running the SQL Performance Analyzer using the DBMS_SQLPA Package •Creating SQL Tuning Sets using Enterprise Manager •Running the SQL Performance Analyzer using Enterprise Manager •Optimizer Upgrade Simulation •Parameter Change •Transferring SQL Tuning Sets Setting Up the Test The SQL......

Words: 1591 - Pages: 7

Premium Essay

Performance Evaluations

...Performance Evaluations Abstract An engineer at a manufacturing plant received a poor review and reacted even more poorly to the results. He is now to be evaluated again but the current evaluation methods seem inadequate. There are advantages and disadvantages to using any performance evaluation method but a mix of both objective measurements including productivity and timeliness and soft skills provide a better solution to view an employee’s whole performance. The paper reviews some of these methods and makes suggestion at improving the evaluation methods currently used. Performance Evaluations An engineer at a manufacturing plant received a poor review and reacted even more poorly to the results. He is now to be evaluated again but the current evaluation methods seem inadequate. The plant manager has reviewed and learned about the 360-degree evaluation method and wonders if it might be a better solution than the current method. There are other evaluation methods that should be considered and revised before evaluating any employee. A combination of methods will probably work best. The engineer is currently evaluated based on friendliness, neatness of workspace and attitude. The first point of concern is that attitude and friendliness are the same thing or at least very closely related. Another concern is that neatness of workspace is not a quantifiable objective; it cannot be easily measured. The engineer frequently has stacks of paper and a......

Words: 1877 - Pages: 8

Premium Essay

Performance Evaluation

...benefits to organizations at every level of work performance. The benefits range from those of the individual workers or jobs to those of teams, core processes, performance management of work execution, business problem solving, and the alignment of work levels to cultural issues and their resolutions. (Pershing, 2006). HPT works at determining the business needs of the organization and all other needs that emanate from them. This is what makes HPT the partner that management cannot do without, management’s must-have-partner, the go-to partner to continuously identify or help solve issues of work performance as they emerge. While the business needs focus on entities, performance need focuses on people. HPT helps management to align both. HPT helps management to identify performance gaps and assist management with developing qualitative and quantified interventions to improve performance and increasing the value of the organization’s human assets. HPT can become a partner that is not eliminated or severely reduced in numbers and influence in hard economic times by ensuring that managers not only use it, but to ensure they own it, rather than perceiving that the practitioner owns it and has come to use it for them. The goal of becoming management’s partner builds on the direction management has set by defining work as identified in the HPT model under environmental analysis. Managers need to be provided with a work and performance model that mirrors or reflects......

Words: 472 - Pages: 2

Premium Essay

Performance Evaluation

...Journal Publisher: Global Journals Inc. (USA) Online ISSN: 2249-4588 & Print ISSN: 0975-5853 Performance Evaluation of Prime Bank Limited in Terms of Capital Adequacy By Md. Abdullah Al Mamun Pabna University of Science and Technology, Bangladesh Abstract - The study aims at evaluating performance of prime bank. Data of the bank is analyzed using capital adequacy ratio, debt equity ratio and advance to asset ratio for the period 2008 to 2012. The study finds, though high debt equity ratio bank maintains capital above regulatory requirement. This will help the researcher and bank to further improvement in capital adequacy to meet regulatory requirement and enhance bank performance. Keywords : capital, capital adequacy ratio, performance. GJMBR-C Classification : JEL Code: G21 PerformanceEvaluationofPrimeBank LimitedinTermsofCapitalAdequacy Strictly as per the compliance and regulations of: © 2013. Md. Abdullah Al Mamun. This is a research/review paper, distributed under the terms of the Creative Commons Attribution-Noncommercial 3.0 Unported License http://creativecommons.org/licenses/by-nc/3.0/), permitting all non-commercial use, distribution, and reproduction in any medium, provided the original work is properly cited. Performance Evaluation of Prime Bank Limited in Terms of Capital Adequacy Md. Abdullah Al Mamun Abstract - The study aims at evaluating performance of prime bank. Data of the bank is analyzed using capital adequacy ratio, debt equity......

Words: 2430 - Pages: 10

Premium Essay

Performance Evaluation

...“budget of indecent ambition” The Daily Star wrote “budget lavish, plan poor” as the government tended to count more on corrupt people for earning offering scopes to whiten black money particularly in the real estate sector alongside banking on bank borrowing and more taxes for revenue. The Financial Express newspaper, however, came in government defence calling it a “mixed Bag of populist, pragmatic moves”. My own perception After reading the overall budget (2013-2014) and approaches given by the specialists I have got a controversial opinion. According to me this budget may influenced both positively and negatively in our county economy. Positive Influence | Negative Influence | It is a budget with a vision of “high performance growth” and stabilization of commodity prices also looks unfulfilled four years down the line. | The budget has not come up with any innovative investment plan. | If the budget successfully implement the GDP will increase. | The size of the development budget is huge and no new thoughts on improving | The budget clearly states the sources that will mobilize funds. | There is no clear statement on improved ways of aid mobilization. | | Budget did not clearly spell out the financing issue. | | The budget carries political risks, comes from the trial of the war criminals. | Conclusion So as we see the budget is lavish and ambitious and it is quite difficult for developing country like Bangladesh to be achieved, but it......

Words: 728 - Pages: 3

Premium Essay

Performance Evaluation

...As you requested, I have finished my evaluation of Kyle Houston, who works as management consultants in Anders. I suggest that you have a second thought about promoting Kyle as the team leader in Dallas. My opinion is based on the observation of his performance during the three months' strategic planning with a division of RPG Financial Services. The ratings and evaluations collected from 15 team members, with whom Kyle worked during the last three months, support my observation. The ratings in the evaluation cover three aspects in Kyle’s performance in team works: contributing, listening, and the facilitating group problem solving. Kyle’s ability in team working is evaluated fairly according to these aspects. Kyle has an open characteristic, which attributes to his high rating in contributing part of the evaluations with four of the rating score at three points.. Kyle is very enthusiastic and passion in his work. Many of the evaluations point out that Kyle is willing to provide his own opinions and never gets lazy on his jobs. In short, he is the most active, even aggressive member in the team. However, from my observation, he puts quantity before quality of his ideas. From the very beginning to the end of a meeting, he would raise his hand to express his own perspective every three minutes. He is very initiative and has a lot of ideas, but he expresses them so soon that some of the ideas seem to lack considerations. This behavior would lead to greater proportion of low......

Words: 831 - Pages: 4

Premium Essay

Performance Evaluation

...productivity will decrease and he would not show interest in teamwork. There are various techniques which are used for evaluating the performance of employees: 1. Essay appraisal method Here, the evaluator puts in writing a short essay offering estimation of the potencies, flaws and vigor of the subject. In order for this technique to be carried out without prejudice, it is essential that the evaluator is aware of the subject and should have intermingled with the employees being assessed. These results of the essay are not easy to be contrasted, as the span and matter of the essay show discrepancies between evaluators. 2. Management by objectives Here, the employees are required to lie down or assist in laying down their personal performance objectives. This technique eliminates the feeling amongst employees that they are being evaluated by dishonestly lofty values. At present, this technique is being extensively made use of, however, not for all time in its true morale. Although the employees are conferred with, in many situations, management results in forcing its values and aims. Also, employees, in many cases, may not be fond of being authorized or directed. 3. Graphic rating scale Here, the person is evaluated on the quality of the work done by him. It may be rated as average, above average, outstanding or unsatisfactory. This evaluation can also be based upon the attributes of the employees especially those attribute that can be observed such as dependability,......

Words: 1417 - Pages: 6

Premium Essay

Performance Evaluation

...Topic: Analyzing Performance Evaluations involves evaluating three characteristics: a Bank’s liquidity, profitability and efficiency. A short-term creditor, such as a bank, is primarily interested in liquidity---the ability of the borrower to pay obligations when they come due. The liquidity of the borrower is extremely important in evaluating the safety of a loan. A long-term creditor, such as a bondholder, looks to profitability and solvency measures that indicate the Bank’s ability to survive over a long period of time. Long-term creditors consider such measures as the amount of debt in the Bank’s capital structure and its ability to meet interest payments. Similarly, stockholders look at the profitability and solvency of the Bank. They want to assess the likelihood of dividends and the growth potential of the stock. Performance managers review and analyze the firm’s Performance Evaluations periodically, both to uncover developing problems and to assess the firm’s progress toward achieving its goal. These actions are aimed at preserving and creating value for the firm’s owner. Performance ratios enable Performance managers to monitors the pulse of the firm and its progress towards its strategic goals. Although Performance Evaluations and Performance ratios rely on accrual concepts, they can provide useful insights into important aspects of risk and return that affect share price, which management is attempting to maximize. Performance Evaluation analysis is a......

Words: 5680 - Pages: 23

Premium Essay

Performance Evaluation

...Annual Performance Review Employee Name | Cathy Smith | Title | HR Receptionist | Date of Review Period | 2010 | Supervisor Name | Dianne Das | Department | Human Resource | Exceeds Expectations = 5[employee has exceeded objective, time and quality] | More Than Satisfactory = 4[employee has slightly exceeded either time and/or quality] | Satisfactory = 3[employee has met objective, may be just under objective on time and quality] | Less Than Satisfactory = 2[employee has not met objective on either time or quality] | Needs Improvement = 1[employee far below on both time and quality] | Task | Objective/Measurement | Results | Comments | Ranking | Typing | 96% accuracy | 90% | Not too far below the goal, can improve | 3 | | Complete within 48 hours of submission | Within 24 hours | Positive | 5 | Filing | 98% accuracy | 82%, unable to find files for labor issues | Subpar room for improvement. Needs more organization | 2 | | Complete by end of the day | By end of each week | Does not meet requirement | 2 | Answer phones | Answer within 3 rings | Within 2 rings | Meets requirement | 5 | | Screens calls | Forwards all calls where she could have provided information | Should attempt to deal with calls before rerouting. Room for improvement | 3 | | Provide messages upon return or availability of staff | Feedback that messages not always given to staff | Subpar, hinders day to day business. Needs improvement | 1 | Provide information |......

Words: 564 - Pages: 3

Premium Essay

Evaluation of Mutual Fund Performance

...EVALUATION OF MUTUAL FUND PERFORMANCE TUGAS IV MAY 1, 2016 KIKI NINDYA ASIH AND NICKO ALBART DMB 10 ABSTRACT This article attempts to measure performance of three stock-based mutual funds in Indonesia over the period of January 1, 2015 – July 30, 2015 using daily data. Each of the stock-based mutual fund was picked randomly from foreign, SOE, and local investment houses. The performance evaluation employs different methods namely Sharpe, Treynor, and Jensen indices. Analysis revealed that different methods yield different result. In order to enrich evaluation, Modigliani-risk adjusted performance metric and qualitative approach were included in the analysis. By using the mix criteria, it was found that the best investment is Schoder 90 Plus Equity Fund followed by Manulife Dana Saham and Mandiri Investa Dynamic Equity. This findings show that even though stock market performed negatively over the period, stock-based mutual fund may yield slightly better than the market. Key Words: Mutual Fund, Sharpe Index, Treynor Index, Jansen Index, M2. I. INTRODUCTION This paper aims at measuring portfolio performance of stock-based mutual funds from three different investment manager over the period of January 1, 2015 – July 30, 2015. Three randomly mutual fund was chosen, namely Schoder 90 Plus Equity Fund (Schroder Investment Management Indonesia), Mandiri Investa Dynamic Equity (Mandiri Manajemen Investasi), and Manulife Dana Saham (Manulife Aset......

Words: 3075 - Pages: 13

Premium Essay

Performance Evaluation

...I. TIME CONTENT The case study is based on a Case Study presented by Brian J. Hall and Carleen Madigan entitled “Compensation and Performance Evaluation at Arrow Electronics” (HBR, 2011; case no. 800290). When Chief Financial Officer (CFO) Anita Fierst arrived from her recent trip to Asia, she talked to the human resource VP Nils Ekdahl about $20 million cut from the payroll at the Circale Corporation (Paragraph 1, Sentence 3; HBR Jul-Aug 2011, p.157). Circale Corporation1 is a global provider of products, services, and solutions to industrial and commercial users of electronic components and enterprise computing solutions, with 2010 sales of $18.7 billion. Arrow serves as supply channel partner for over 1,200 suppliers and 115,000 original equipment manufacturers, contract manufacturers and commercial customers through a global network of more than 340 locations in three (3) regional site: Asia Pacific, North America and Europe. A Fortune 200 company with 12,700 employees worldwide, Arrow brings technology solutions to breadth of markets, including telecommunications, information systems, transportation, medical, industrial and consumer electronics. They are committed to serve the communities where their employees live and work. They demonstrate commitment to corporate citizenship extends beyond the boundaries of their business to the global community that they are part of. Arrow is the benefactor of a number of worthy causes across the United States and......

Words: 272 - Pages: 2

Premium Essay

Performance Evaluations

...Performance Evaluations Introduction XXXXXXXXXX is an electronics manufacturing company and for years has been known as the pioneers in the design, production, and support of innovative solutions for customers in aerospace and defense. They have expertise in flight deck avionics, cabin electronics, mission communications, information management, and simulation and training. This international organization has over 20,000 employees worldwide. Their organization spans to over 27 countries. The yearly sales for this organization are about 4 billion dollars; approximately half of their business comes from the government with the other half from the commercial industry. XXXXXXXXXX is a strong believer of Lean Manufacturing and utilizes these tools in every aspect of the business. They also believe in strong ethical practices and utilizing diversity as a means to get the best ideas from multiple backgrounds and experiences. This research will concentrate primarily on the Miami facility. It was opened in the late 1970’s and its primary customers are those in the Business and Regional markets (i.e. Bombardier, Airbus, Cessna, etc.). The Miami facility employs approximately 1,250 employees and is primarily a manufacturing facility. However, due to the availability of test equipment, it is also considered a repair center. A repair center means that the Miami facility may be called upon to repair service units that are owned by customers. As part of the curriculum for......

Words: 5216 - Pages: 21

Free Essay

Performance-Counter-for-Sql-Server

...Few of my friends who wish to do a performance tuning in their servers, they asked me what are the counters that they should check that gave me an idea to prepare this document and publish across. Disk Related Counters: Object Name: Physical Disk Counters: Current Queue Length: Sustained high queue for a period of time means that the IO subsystem has a problem. Average Queue Length: If the Average Queue Length for the disk is high more than 2. Then this indicates a potential IO subsystem problem. This would also make the disk sec/read and disk sec/write high. Disk Sec/Read: This counter should measure not more than 15ms in normal situation. Continuous values of more than 20ms indicate that the disks have a problem. Under these conditions, consider the following Move the files to additional drives. Check for proper indexing on the tables. Check for the CPU and memory counters to find any other potential bottlenecks. Disk Sec/Writes: This counter should measure not more than 15ms in normal situation. Continuous values of more than 20ms indicate that the disks have a problem. Under these conditions, consider the following Move the files to additional drives. Check for proper indexing on the tables. Check for the CPU and memory counters to find any other potential bottlenecks. Placing transactional log files in separate drives to remove additional pressure on the drives Memory/Cache: Object Name: Memory: Counters: Page Faults/Sec: Page faults occur......

Words: 1126 - Pages: 5

Premium Essay

Performance Evaluations

...MPS Group Performance Appraisal Process Human Resource Management October 14, 2009 Table of Contents History of MPS Group MPS Group Organization Strategy Human Resources: Strategy and Role within MPS Group MPS Performance Appraisals MPS Group Performance Appraisal Analysis Recommendations Summary Appendices History of MPS Group MPS Group is a Jacksonville, Florida company that provides consulting and staffing services in the areas of information technology, finance and accounting, law, e-business, human capital automation, engineering, executive search, and workforce management. After becoming a regional power in the early 1990s, the company has engaged in an aggressive acquisition campaign, rolling up scores of temp agencies across the country and transforming itself into a national staffing firm large enough to rival much better known Manpower and Kelly Services. MPS Group has sold off its clerical staffing business, the traditional base of the temp industry, in favor of higher margin professional and technical placement. Aside from its extensive North America operation, MPS also operates in the United Kingdom and continental Europe. Originally a provider of temporary employees of all categories and job skills, the firm has grown to become one of the world’s largest providers of white-collar staffing services. While temporary staffing accounts for less than 2 percent of the...

Words: 1757 - Pages: 8

Premium Essay

Performance Evaluation

...Performance evaluation methods in commercial banks and associated risks for managing assets and liabilities 97 Performance evaluation methods in commercial banks and associated risks for managing assets and liabilities University Reader PhD. Claudiu CICEA, Academy of Economic Studies Bucharest, Romania email : claudiu.cicea@man.ase.ro University Professor PhD. Daniela HINCU, Academy of Economic Studies Bucharest, Romania email : daniela.hincu@man.ase.ro Abstract Commercial banks represent the core of the credit for any national economy. In turn, the credit is the engine that put in motion the financial flows that determine growth and economic development of a nation. As a result, any efficiency in the activities of commercial banks has special implications on the entire economy. That is why we consider very useful to present an analysis of possibilities for evaluating the performance in the commercial banks. The management of every commercial bank must establish a system for assessing investment performance which suits its circumstances and needs and this evaluation must be done at consecutive intervals to ensure the achievement of the Bank's investment objectives of hand; and to know the general direction of the behavior of investment activity in the past and therefore predictable as it in the future on the other hand. The main objective for this paper is to analyze some quantitative methods used in assessing the performance of investment activity in commercial banks......

Words: 3780 - Pages: 16

Terri Irwin | LAVAMOTORI SPRAY 400ml AUTO MOTO BARCA SCOOTER CATENE LAVA MOTORI VMD29 PROFESSI | file_downloadTélécharger