SQL Server数据库性能优化方法

Models of Optimizing SQL Server Database

使用数据库优化技术,可以使SQL Server数据库性能成倍甚至成百倍的提高.本文从分析数据库的组织结构入手,总结出SQL Server数据库性能优化的多种方法:选择性能优越的服务器;利用基于硬件的RAID优化数据库;利用文件组优化数据库;在基于硬件RAID的情况下利用文件组优化数据库.

Using technology of optimizing a database, to make performance of database improve double or 100 times. The article presents models of optimizing SQL Server a database： Select optimizing superior server; Optimizing a Database Using Hardware - based RAID; Optimizing a Database Using Filegroups;Optimizing the Database Using Filegroups with Hardware -based RAID;Performance Considerations.