Analisis Alat Bantu Tuning Fisikal Basis Data pada Sql Server 2008
Keywords:information technology, database, tuning, SQL Server 2008
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.
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.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: