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

The Optimization Design of Application System Performance in SQL Server

在设计开发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.