SQL Server technical analysis of performance optimization
With the progress of client/server technology and multi-layer architecture,the issue of system efficiency has been increasingly widely discussed.The design and service execution system cannot be optimized due to the lack of the optimization methods and tools provided by the database management system(DBMS)and the knowledge of the database administrators and application developers based on Microsoft technologies.This paper reviewed the objectives to be considered when improving the performance of SQL Server instances and elaborated the techniques used to optimize queries.
NETL
NSTL
万方数据
