Performance Monitoring and Tuning of SQL server

Kumaresh, S.S. (2006) Performance Monitoring and Tuning of SQL server. [Student Project Report]

PDF 164.pdf Restricted to Repository staff only Download (841kB)

Abstract

This Dissertation / Report is the outcome of investigation carried out by the creator(s) / author(s) at the department/division of Central Food Technological Research Institute (CFTRI), Mysore mentioned below in this page.

Item Type:	Student Project Report
Additional Information:	This report gives a brief introduction of Database, RDBMS, and also explains about the Performance Tuning and Monitoring of SQL server. This explains about the Performance problems in the database. There are many reasons for these problems like weak design, inefficient queries, poor use of indexes, and out of the data statistics. Monitoring and tuning the major four areas as SQL related, Systems Environment,Indexes and Hardware Bottlenecks, can improve the performance of the database. This report also explains about the various SQL server tools and objects that are used to increase the Performance by utilizing the SQL server’s resources efficiently. The main goal of this project is to increase the performance of the database application.
Uncontrolled Keywords:	Transact-SQL, Query, Performance Tuning, Monitoring, Index, Checklist
Subjects:	000 Computer science, information and general works > 02 Computer Science
Divisions:	Plant Cell Biotechnology
Depositing User:	Food Sci. & Technol. Information Services
Date Deposited:	20 Mar 2007
Last Modified:	28 Dec 2011 09:26
URI:	http://ir.cftri.res.in/id/eprint/484

Actions (login required)

View Item