SQL Server索引概述 ( SQL Server indexes overview )
Just like a book index, SQL Server index has a similar purpose, to provide faster searching, gathering and sorting of information from a database, without need to go through all of the objects over and over. Instead, an index provides the gateway between the table rows and query engine, in order to achieve better both database and query performance.
就像书本索引一样, SQL Server索引也具有类似的目的,即提供更快的搜索,收集和排序数据库信息的功能,而无需一遍又一遍地遍历所有对象。 取而代之的是,索引提供了表行与查询引擎之间的网关,以实现更好的数据库性能和查询性能。
Indexes are not just another type of database object, because they can be also considered as a query performance optimization method, if they are created and used properly.
索引不仅仅是数据库对象的另一种类型,因为如果索引被正确创建和使用,它们也可以被视为查询 性能优化方法 。
In this article, the focus will be on how to monitor SQL Server indexes size.
在本文中,重点将放在如何监视SQL Server索引大小上。
监视SQL Server索引大小 ( Monitor SQL Server indexes size )
As database objects stored on a disk, indexes could impact negatively the storage and overall database performance.
由于数据库对象存储在磁盘上,因此索引可能会对存储和整体数据库性能产生负面影响。
In order to prevent unexpected SQL Server indexes growth and database storage overwhelming, the follow monitoring methods which will be mentioned below.
为了防止意外SQL Server索引增长和数据库存储不堪重负,下面将介绍以下监视方法。
Each of the methods described will separately provide the solution to monitor:
所描述的每种方法将分别提供监视解决方案:
- individual index size with Disk usage by table pre-defined reports in SQL Server Management Studio
- SQL Server Management Studio中的表预定义报告提供的单个索引大小和