Analisis Alat Bantu Tuning Fisikal Basis Data pada Sql Server 2008

Authors

  • Marlene Martani Bina Nusantara University
  • Hanny Juwitasary Bina Nusantara University
  • Arya Nata Gani Putra Bina Nusantara University

DOI:

https://doi.org/10.21512/comtech.v5i1.2628

Keywords:

information technology, database, tuning, SQL Server 2008

Abstract

Nowadays every company has been faced with a business competition that requires the company to survive and be superior to its competitors. One strategy used by many companies is to use information technology to run their business processes. The use of information technology would require a storage which commonly referred to as a database to store and process data into useful information for the company. However, it was found that the greater the amount of data in the database, then the speed of the resulting process will decrease because the time needed to access the data will be much longer. The long process of data can cause a decrease in the company’s performance and the length of time needed to make decisions so that this can be a challenge to achieve the company’s competitive advantage. In this study performed an analysis of technique to improve the performance of the database system used by the company to perform tuning on SQL Server 2008 database physically. The purpose of this study is to improve the performance of the database used by speeding up the time it takes when doing query processing. The research methodology used was the method of analysis such as literature studies, analysis of the process and the workings of tuning tools that already exist in SQL Server 2008, and evaluation of applications that have been created, and also tuning methods that include query optimization and create index. The results obtained from this study is an evaluation of the physical application tuning tools that can integrate database functionality of other tuning tools such as SQL Profiler and Database Tuning Advisor.

Dimensions

Plum Analytics

References

Burleson, D. (2010). Oracle Tuning: The Definitive Reference.

Connolly, T., Begg, C. (2010). Database Systems : A Practical Approach To Design, Implementation, and Management. (5th Edition). New York: Pearson.

Karthik, P., Reddy, G. T., Vanan, E. K. (2012). Tuning the SQL Query in order to Reduce Time Consumption. IJCSI International Journal of Computer Science Issues, 9: 418.

Leiter, C., Wood, D., Boettger, A., Cierkowski, M. (2009). Beginning Microsoft SQL Server 2008 Administration. Canada: Wiley Publishing.

Petković, D. (2008). Microsoft SQL Server 2008: A Beginner's Guide. USA: McGraw-Hill.

Sukheja, D., & Singh, U. K. (2011). A Novel Approach of Query Optimization for Distributed Database Systems. IJCSI International Journal of Computer Science Issues, 8: 307.

Whalen, E. (2001). Microsoft SQL Server 2000 Performance Tuning: Technical reference. Washington: Microsoft Press.

Whitten, J. L., Bentley, L. D., Dittman, K. C. (2004). Systems Analysis and Design Methods. (6th Edition). New York: McGraw-Hill.

Downloads

Published

2014-06-30

Issue

Section

Articles
Abstract 445  .
PDF downloaded 667  .