SQL Server应用系统性能优化设计  

The Optimization Design of Application System Performance in SQL Server

作　　者：杜津玲[1] 

机构地区：[1]汽车管理学院基础部,安徽蚌埠233011

出　　处：《电脑开发与应用》2009年第3期22-23,26,共3页Computer Development & Applications

摘　　要：在设计开发SQL Server数据库应用系统时,都希望系统能够发挥最佳性能。提高系统性能的方法就是进行各种优化。分析了影响SQL Server数据库应用系统性能的一些因素,从设计数据库、应用程序、索引、查询、优化SQL语句等方面提出几种有效提高应用系统性能的方法。When the design develops SQL Server database application system, hoped that the system can display the optimum performance. Enhances the system performance the method carries on each kind of optimization. This article analyzed some factors which have affected SQL Server database application system performance, from the design of database, application, index, query, optimized the SQL statements and so on to propose several effective methods for enhancement application system performance.

关 键 词：SQL SERVER数据库 应用 系统 性能 优化 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]