LN Chavali, L. Hmingliana, Brindha Senthil Kumar, P. Narayana
{"title":"应用软件中数据库性能的一种微调方法","authors":"LN Chavali, L. Hmingliana, Brindha Senthil Kumar, P. Narayana","doi":"10.22232/stj.2021.09.01.02","DOIUrl":null,"url":null,"abstract":"Database tuning is crucial step to enhance the performance of the application software. There are many tools available in Microsoft to evaluate the performance of the stored procedures and identify them. This paper presents a comparative performance of actual and tuned sample stored procedures in SQL Server 2008 R2 of Application software (Microsoft). The results showed there is a marginal gain in the efficiency after the database tuning.","PeriodicalId":22107,"journal":{"name":"Silpakorn University Science and Technology Journal","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2021-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"An Approach to Fine Tuning Database Performance in Application Software\",\"authors\":\"LN Chavali, L. Hmingliana, Brindha Senthil Kumar, P. Narayana\",\"doi\":\"10.22232/stj.2021.09.01.02\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Database tuning is crucial step to enhance the performance of the application software. There are many tools available in Microsoft to evaluate the performance of the stored procedures and identify them. This paper presents a comparative performance of actual and tuned sample stored procedures in SQL Server 2008 R2 of Application software (Microsoft). The results showed there is a marginal gain in the efficiency after the database tuning.\",\"PeriodicalId\":22107,\"journal\":{\"name\":\"Silpakorn University Science and Technology Journal\",\"volume\":null,\"pages\":null},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-01-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Silpakorn University Science and Technology Journal\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.22232/stj.2021.09.01.02\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Silpakorn University Science and Technology Journal","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.22232/stj.2021.09.01.02","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
数据库调优是提高应用软件性能的关键步骤。Microsoft中有许多工具可用于评估和识别存储过程的性能。本文在应用软件(Microsoft)的SQL Server 2008 R2中比较了实际和调优的样例存储过程的性能。结果表明，在数据库调优之后，效率有一个边际增益。
An Approach to Fine Tuning Database Performance in Application Software
Database tuning is crucial step to enhance the performance of the application software. There are many tools available in Microsoft to evaluate the performance of the stored procedures and identify them. This paper presents a comparative performance of actual and tuned sample stored procedures in SQL Server 2008 R2 of Application software (Microsoft). The results showed there is a marginal gain in the efficiency after the database tuning.
求助内容：
应助结果提醒方式：
京公网安备 11010802042870号
