| SQL Server大数据量数据库性能优化初探 |
| |
| 引用本文： | 吴纲.SQL Server大数据量数据库性能优化初探[J].武汉船舶职业技术学院学报,2010,9(1):27-30,35. |
| |
| 作者姓名： | 吴纲 |
| |
| 作者单位： | 武汉职业技术学院计算机学院,湖北武汉,430074 |
| |
| 摘 要： | SQL Server作为一种企业级的数据库,提供了丰富的特性,开发者可以从多个角度进行性能分析与优化。特别是聚集索引非常关键,而一个表只能有一个聚集索引,应该合理应用。同时要善于利用数据库系统提供的各种工具,有针对性地分析和调校性能。实践表明,只要适当进行优化,在普通服务器平台上,SQL大数据量数据库的性能是基本可用的。
|
| 关 键 词： | 海量数据 优化 索引 聚集索引 |
Performance Optimization Performance Optimization of Mass Data SQL Server Database |
| |
| WU Gang.Performance Optimization Performance Optimization of Mass Data SQL Server Database[J].Journal of Wuhan Institute of Shipbuilding Technology,2010,9(1):27-30,35. |
| |
| Authors: | WU Gang |
| |
| Institution: | WU Gang(Wuhan Institute of Technology,Wuhan 430074,China) |
| |
| Abstract: | As an enterprise-class database,SQL server possesses many functions.Developers may conduct performance analysis and optimization.In particular,as a table can have only one clustered index,the clustered index is critical and should be applied reasonably.At the same time developers must be good at using different database tools to analyze and adjust performance.Practice shows that the performance of mass data SQR database is reliable through proper optimization in a general platform. |
| |
| Keywords: | mass data optimization index clustered index |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
