Verification the performance of Microsoft SQL Server / Nageswary Gannapathy

Microsoft SQL Server is a client / server based relational database management system (RDBMS) that uses T-SQL as its dialect of the SQL language. A client / server database is an application that is divided into a part that runs on a server and a part that runs on workstations (clients). The server...

Full description

Saved in:
Bibliographic Details
Main Author: Nageswary , Gannapathy
Format: Thesis
Published: 2002
Subjects:
Online Access:http://studentsrepo.um.edu.my/12421/1/nageswary.pdf
http://studentsrepo.um.edu.my/12421/
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1831436072981102592
author Nageswary , Gannapathy
author_facet Nageswary , Gannapathy
author_sort Nageswary , Gannapathy
building UM Library
collection Institutional Repository
content_provider Universiti Malaya
content_source UM Student Repository
continent Asia
country Malaysia
description Microsoft SQL Server is a client / server based relational database management system (RDBMS) that uses T-SQL as its dialect of the SQL language. A client / server database is an application that is divided into a part that runs on a server and a part that runs on workstations (clients). The server side provides security, fault-tolerance, performance, concurrency, and reliable backups. The client side provides the user interface. SQL Server developers have the responsibility for designing and implementing the databases. Designing n good database start with understanding the client’s requirements for the database. SQL Server administrators have the responsibility for the day-to-day tasks of mai ntaining and managing the databases. SQL Server administration involves backing up databases and restoring them when necessary, setting up and managing users, managing database security, managing the replication environment, tuning the database system, and trouble shooting any problems that arise. In this proposal, the Verification the performance of Microsoft SQL Server 7.0 performance will be presented. The proposal mostly will touched on the part of tuning and indexes of SQL Server to perform an optimizer performance and shows how it works on retrieving columns and rows of the real datas. For this purpose, a system will be developed to communicate with SQLServer.
format Thesis
id my.um.stud-12421
institution Universiti Malaya
publishDate 2002
record_format eprints
spelling my.um.stud-124212021-06-02T20:49:23Z Verification the performance of Microsoft SQL Server / Nageswary Gannapathy Nageswary , Gannapathy QA75 Electronic computers. Computer science QA76 Computer software Microsoft SQL Server is a client / server based relational database management system (RDBMS) that uses T-SQL as its dialect of the SQL language. A client / server database is an application that is divided into a part that runs on a server and a part that runs on workstations (clients). The server side provides security, fault-tolerance, performance, concurrency, and reliable backups. The client side provides the user interface. SQL Server developers have the responsibility for designing and implementing the databases. Designing n good database start with understanding the client’s requirements for the database. SQL Server administrators have the responsibility for the day-to-day tasks of mai ntaining and managing the databases. SQL Server administration involves backing up databases and restoring them when necessary, setting up and managing users, managing database security, managing the replication environment, tuning the database system, and trouble shooting any problems that arise. In this proposal, the Verification the performance of Microsoft SQL Server 7.0 performance will be presented. The proposal mostly will touched on the part of tuning and indexes of SQL Server to perform an optimizer performance and shows how it works on retrieving columns and rows of the real datas. For this purpose, a system will be developed to communicate with SQLServer. 2002 Thesis NonPeerReviewed application/pdf http://studentsrepo.um.edu.my/12421/1/nageswary.pdf Nageswary , Gannapathy (2002) Verification the performance of Microsoft SQL Server / Nageswary Gannapathy. Undergraduates thesis, University of Malaya. http://studentsrepo.um.edu.my/12421/
spellingShingle QA75 Electronic computers. Computer science
QA76 Computer software
Nageswary , Gannapathy
Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_full Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_fullStr Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_full_unstemmed Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_short Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_sort verification the performance of microsoft sql server / nageswary gannapathy
topic QA75 Electronic computers. Computer science
QA76 Computer software
url http://studentsrepo.um.edu.my/12421/1/nageswary.pdf
http://studentsrepo.um.edu.my/12421/
url_provider http://studentsrepo.um.edu.my/