Performance audit and optimization at MS SQL server 2000

While the data which is stored on database management systems increases, the issueof storing this data accurately is getting more diffulcult. For discussing about highlyperformed application, its database also should be higly performed. The databasesystems has been effected by lots of internal and external factors.MS SQL Server 2000 database management system has been effected by hardwarefactors, by operating system settings that runs on, by database configuration settings,by server settings, by index options settings and query syntaxes. According to thisfactors the response times of the application requests may change. While there arelots of factor that effects the server performance, the issue of performing this settingtunings, auditing the steps and optimizing the SQL Server 2000 should besystematically. All main settings has got its own sub-setting values. When finishingthe tuning all this main and sub settings the database management systems overallperformance consists. This main and sub settings have got direct effects and alsocross affects to the system and each other when they have all performed.In this study these internal and external effects has been all analysed , performed andwatch on a sales force automation system which is alive for 400 medical sales agentfor 6 months . This application has been fed up with the SQL Server 2000 Databaseas main database server. All the factors has been performed and the reaction of theserver has been observed for a while to find the optimum setting options for bestperformance of the server. As a result some lists has been released; Hardwarebottlenecks control checklist, performance control checklist, operating systemperformance control checklist, SQL Server configuration performancde controlchecklist, SQL Server settings control checklist,SQL Server query performancecontrol checklist, application control checklist, SQL Server jobs control checklist.Also at the end of this study, by the reference of the rules of using t-sql statementsand stored procedures, an optimum nominative syntax program which is calledkonteskuel has been cretaed by coding at vb.net.Key Words: Database performance, database performance optimization, SQL Server2000