Performance Audit and Optimization At MS SQL Server 2000
Journal: Electronic Letters on Science & Engineering (Vol.6, No. 2)Publication Date: 2010-09-03
Authors : Osman Ayhan; Feyzullah Temurtaş;
Page : 6-9
Keywords : Database performance; database performance optimization; SQL Server 2000;
Abstract
In this study, these internal and external effects has been all analysed , performed and watch on a sales force automation system which is alive for 400 medical sales agent for 7/24 . This application has been fed up with the SQL Server 2000 Database as main database server. All the factors has been performed and the reaction of the server has been observed for a while to find the optimum setting options for best performance of the server. At the end of this study, by the reference of the rules of using t-sql statements and stored procedures, an optimum nominative syntax program has been cretaed by coding at vb.net 2003
Other Latest Articles
- ERP (Enterprise Resource Planning) and Stock Module
- During Triassic Paleoredoks and Provenance Investigation of Rich Organic Matter Tarasçı Formation (Middle Taurus / Turkey)
- FUZZY Control Strategy Adapting to ISPM-15 Standarts
- Estimate of Changes in Carbon Stocks Based on Land Cover Changes in the Leuser Ecosystem Area (LEA) Indonesia
- Development and Evaluation of Web GIS Application for Groundwater Management of Karanganyar Regency
Last modified: 2016-02-08 01:39:41